Event Details

*ONLINE 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 18th June 2024

AND

Wednesday 19th June 2024

Community

Discover and connect with other attendees.

AB