Excel Intermediate 2 - Data Analysis and more functions and formulae

Outline

Audience

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

Objectives

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

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
Contact Graham on 01243 216278 or email courses@growtrain.co.uk to book this course
Share This