Excel Intermediate 2 - Data Analysis and more functions and formulae

Course Outline


This one day course is for people who need to analyse large data sets, manipulate data with a range of Excel functions.


At the end of the course delegates will be able to:

  • Use a range of Excel decision and logical functions
  • Use a range of lookup functions
  • Work with Named ranges
  • Data validation to create pick lists and validate data entry
  • Advanced data filters to search for data based on complex criteria
  • Advanced Conditional Formatting using formulas
  • Work with Excel Tables and Pivot Tables and Charts

Course Content

  • Functions
  • Named Ranges
  • Data Validation
  • Advanced Filters and Outlines
  • Auditing Tools
  • Conditional Formatting
  • Pivot Tables

Show the next months in

Location Dates Time Price exc. VAT   Status
Growtrain Ltd PO20 2BX 18 Sep 2020 09:00h – 15:30h £155.00 Registration Closes
Oct 02, 2020 10:00AM

Growtrain Ltd PO20 2BX

18 Sep 2020

09:00h – 15:30h

£155.00 exc. VAT


Register Now » 4 Places Available!
Register Now » 4 Places Available!
Contact Nina or Graham on 01243 216278 or email courses@growtrain.co.uk to book this course
Share This