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 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- See Excel Introduction.
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 12th November 2024
AND
Wednesday 13th November 2024