This hands-on one-day training course has been designed to give delegates a solid understanding of intermediate level tools and concepts used in Excel, specifically in writing and using formulas in order to increase their knowledge and productivity.


Users with a basic understanding of Microsoft Excel who want to take their knowledge of the basic features further in a short space of time. Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction course.

MODULE 1:  Working with Functions and Formulas

Some key formulas and functions essential to Excel users along with features to help manage formulas, functions and ranges.

  • Creating Formulas
  • Common Aggregate Functions (eg. SUM)
  • IF and Nested Functions
  • Using the VLOOKUP Function
  • Formulas with Absolute References
  • Text Functions
  • Date Functions 

MODULE 2:  Managing Tables in Microsoft Excel

Managing spreadsheet data in table format, an excellent feature to administrate large sets of data.

  • Creating Excel Tables
  • Sorting and Filters
  • Formatting Your Form
  • Using Formulas on and in an Excel Table
  • Totals in Tables 

MODULE 3:  Data Tools in Excel

Features to help with managing spreadsheet data making it a less daunting and repetitive task to manage the data.

  • Text to Columns
  • Remove Duplicates
  • Conditional Formatting
  • Flash Fill
  • Data Validation