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

Community

Discover and connect with other attendees.