Microsoft Excel

Gain Confidence
The Excel introduction course begins with understanding the theory and quickly moves onto useful things to know with tips and best practices.  You will be shown the basics of writing formulas so you have a sound foundation and how to keep them simple.

Introduction Courses
1. Overview of Excel
2. Creating a Spreadsheet
3. Formatting Spreadsheet
4. Using $ to Fix Formulas
5. Linking Formulas

Beyond the Basics
The intermediate course is aimed at those who are comfortable with the features set out at the introduction level where you can navigate quickly and efficiently around your spreadsheet.  At this stage you should be comfortable using the mouse as well as a variety of keyboard shortcuts to use Excel efficiently.  This level offers a total of three separate courses as shown below.

Intermediate Courses
1. Using Mid & Find Functions
2. Logical Functions (IF, AND & OR)
3. Database Management

Advanced Features
Our advice is to take the advanced level courses once you have gained sufficient confidence with both the introduction and intermediate levels.  This will allow you to step into the remaining topics of the Excel program comfortably by applying a combination of formula writing techniques, and a sound understanding of how to use Excel without experiencing common errors which are often reported by users.

Advanced Courses
1. VLOOKUP and Match Functions
2. Using Pivot Tables