IT Courses - Advanced Excel

Venue: Broomfield Hall
Hours: 0.20
Cost (£): 125.00

Course Overview

Validated by Derby College, this one-day workshop is designed to give individuals who already have a good understanding of the programme'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

Course Dates

Course Title Course Date
IT Courses - Advanced Excel 13/10/2017 BOOK Now
IT Courses - Advanced Excel 08/01/2018 BOOK Now
IT Courses - Advanced Excel 14/05/2018 BOOK Now
IT Courses - Advanced Excel 09/07/2018 BOOK Now