Date(s) - 08/01/2019
9:00 am - 4:30 pm
This one-day course is appropriate if you are a regular user of Excel and are confident with Excel techniques such as formula creation, naming of cells, list sorting and filtering, PivotTables, data validation techniques, worksheet protection, and recording of simple macros.
It is assumed attendees have strong general computing skills, are familiar with the Windows environment and have attended an intermediate course or have equivalent experience with Excel.
At Course Completion
At the completion of the course you should be familiar with a range of advanced techniques that enable the creation of sophisticated Excel workbooks.
This course covers Excel versions 2010, 2013 and 2016.
review of intermediate spreadsheet concepts/features
“what-if” analysis (goal seeking, scenario manager, data tables, Solver)
lookup and error checking functions
creating user-defined functions
consolidating data and linking worksheets and workbooks
review of Pivot Tables
manipulating external data using Pivot Tables
statistical analysis using the Analysis Toolpak add-in
creating and using workbook templates
creating and editing macros using Visual Basic for Applications