IT Courses - Advanced Excel

Venue: Broomfield Hall
Hours: 7.00
Cost (£): 180.00

Course Overview

Validated by Derby College, this one-day workshop is designed to give individuals who already have a good understanding of Excel's key features the opportunity to learn more advanced skills.

Course Content

The course will cover the following topics:

  • Pivot tables
  • Data consolidation
  • Using outlines
  • Lookup functions
  • Statistical, Math and Trigs functions
  • Nested and Array functions
  • Data tables
  • Data validation
  • Auditing spreadsheets
  • Introduction to Macros
Check Available Course Dates & Book »