Event Details
*2 HALF DAY EXCEL COURSE*
Please ensure you have a laptop/computer screen and an additional screen connected as this will assist you greatly in the training.
Objectives
The purpose of this 2 half day course is the teach delegates some of the advanced features of Excel. Working with Pivot Tables, & Using What If Analysis Tools, are covered in this module. Extensive hands-on classroom training is provided throughout.
Pre-Requisites
Delegates should be proficient in essential excel skills before starting this module.
Versions ; This course is available for Excel 2007 , 2010, 2016 365
Contents
- Create a PivotTable
- Create a PivotChart
- 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
- Create a macro
9:30am - 12:30pm
Tuesday 17th September 2024
AND
Wednesday 18th September 2024