Excel training

...Day Course Assumed Knowledge: A working knowledge of Excel gained from prior attendance on a Jarrold Training Microsoft Excel Introduction course or from a user environment...

...The course features dozens of diagrams saved in PDF format. You will have access to all of these diagrams. You can study them at your leisure... Learn about: IF statements, Nesting VLOOKUP, Advanced MATCH...

...want to learn how to utilise these advanced functions and features to improve the efficency of their spreadsheets. Learn how to create and use If Statements...

...Inserting functions -Building formulas -Sharing sheets and live collaborating with other users -Using comments -Export sheets -Printing sheets ‑ This... Learn about: Google Slides, Google Apps, Product Design...

...who wish to continue advancing their knowledge of Excel Microsoft Excel Advanced - Level 2 One Day Course Course Aims: This course is designed to provide...

...nested functions to build complex formulas. This Excel course also covers the auditing of formulas and and the handling of errors. Building formulas Entering and editing formulas... Learn about: Microsoft Excel, IT Auditing, MS Excel...

...for delegates wishing to gain an introduction to Excel. Course review: Microsoft Excel is the world's most popular spreadsheet application and makes calculating...

...is increasingly important in today’s competitive business environment and, whether you are currently employed or a job seeker, Microsoft Office Specialist... Learn about: Creating Pivot Tables, Formatting worksheets, Lookup Data Using Functions;...

...practical understanding Microsoft Excel Advanced - Level 1 One Day Course Course Aims: This course is designed to provide delegates with the knowledge...

...Getting native Excel data; Getting data From relational databases; Getting data From .CSV And .TXT files; Getting tabular data from a web page Transforming... Learn about: Data Types, DAX Language, MS Excel...

...advanced features Course review: Microsoft Excel is the world's most popular spreadsheet application and makes calculating, displaying and sharing data...

...Apps Script is a scripting language for light-weight application development in the G Suite platform. ... According to Google, Apps Script... Learn about: Web Applications, JSON Data, Web Page...

...The Immediate Window Function procedures Sub versus function, User-defined functions, Declaring a function, Calling a function, Private and public scope... Learn about: MS Excel, Alerts property, Dialogue boxes...

...Switching Between Views, Using Help, Closing A Workbook And Exiting ExceOn Your Own Working With Data Entering Text And Numbers, Entering Simple Formulas... Learn about: Cell borders, Cell styles, MS Excel...

...Filtering Data Using Autofilter, Creating Custom FiltersOn Your Own Working With Charts Creating A Chart, Moving A Chart, Resizing A Chart, Changing The Layout And Style... Learn about: Totaling Data, Financial Training, Deleting Rows...

...Advanced Number-Crunching Functions Controlling rounding sensitivity, Using SUMIF and INDIRECT , Using wildcards with SUMIFS, AVERAGEIFS, MINIFS and MAXIFS... Learn about: Data analysis, Advanced Filters, MS Excel...

...Creating a Pivot Table Exploring an Insurance Policy Example, Changing the Pivot Table Layout, Charting the Data in a Pivot Table Modifying a Pivot Table... Learn about: Table Layout, Pivot table, Report Filter...

...Click events Creating Add-ins Add-ins defined, Creating an add-in, Installing and add-in, Controlling add-ins with VBA, Add-ins collection, Add-in properties... Learn about: Formatting Cells, Microsoft Office, Color Scales...

...Appending data with common column headers; Merging data with common rows; Combining all files in a folder The Power Query Formula Language Using The Formula... Learn about: Power Query, MS Excel, Pivot table...

...Stepping through macros, Getting help on macros Objects, properties and methods About Excel objects, Using the Object Browser , Range object... Learn about: Adding comments, Targetting cells, Visual Basic training...