COURSE INFORMATION

This course looks specifically at formulas using Functions. There are over 400 Functions in Excel in many categories.  This Master Class course sits between Intermediate and Advanced course topics and goes beyond the basic aggregate Functions and looks at some of the most popular categories.

  • Functions types and the Insert Function tool
  • Using Nested functions to create more complex formulas
  • Formula Auditing Tools
  • Formula structure and rules
  • Absolute cell references
  • Use the Insert Function tool
  • Aggregate Functions (SUM, COUNT, AVERAGE, MAX, MIN)
  • Range Names
  • Half Day Course
  • Delivery at Carnegie Conference Centre 
  • AM classes are: 9.30am - 12.30pm 
  • PM classes are: 1.30pm - 4.30pm 

£125 Includes: 

  • All course materials
  • Refreshments