Excel Advanced Level
Please ensure you have a laptop/computer screen and an additional screen connected as this will assist you greatly in the training.
The purpose of this two half-day course is to teach delegates some of the advanced features of Excel.Working with Pivot Tables, Using What If Analysis Tools, Auditing tools and Writing Macros are all covered in this module. Extensive hands-on classroom training is provided throughout.
Delegates should be proficient in essential excel skills before starting this module- See Excel Introduction & Intermediate.
Versions ; This course is available for Excel 2010, 2013,2016, & 365
· Create a PivotTable
· Create a PivotChart
· Create a Macro
· Use Goal Seek
· Use Scenarios
· Use Solver
· Audit Worksheets
· Protect Worksheets and Workbooks
· Use Consolidation
· Apply Conditional Formatting
· Apply Data Validation
· Import and Export information
Training & Events