Below is a variety of half-day courses for basic to the more advanced users. We have half-day courses from learning the basics to specific courses tailored to topics. Feel free to mix and match theses courses to make a full-day course.
Basic
-
Screen Elements
-
Create
-
Calculations
-
Move & Copy
-
Insert & Delete
-
Column Width & Row Height
-
Basic Formatting
-
Print Preview and Send to Printer
-
AutoFill
​
​
Intermediate
-
Work with Multiple Worksheets
-
Use Absolute Cell References
-
Sort & Filter Data
-
Use Functions
​
​
​
Advanced
-
Work with Range Name
-
Consolidate Data
-
Outline & Group a Worksheet
-
Use more Functions
​
​
​
Enhancing Worksheets​
-
Format Cells Dialog Box
-
Custom Formatting
-
Format Painter
-
Conditional Formatting
-
Format a Table
-
Cell Styles
​
​
​
Managing Worksheets
-
Multiple Worksheet
-
Absolute Cell References
-
Range Names
-
Large Worksheets
​
​
​
List Management
-
Sort & Filter Data
-
Advanced Filter
-
SubTotals
-
Remove Duplicates
-
Import & Export Data
​
​
​
PivotTables & Charts
-
PivotTables
-
Slicers
-
PivotChart
-
Tables
-
Analyse
-
Charts
-
Sparklines
​
​
​
Functions
-
Statistical - Max, Min, Average, Count, Large, Small
-
Logical - IF, Nested IF, And, Or
-
Lookup - Vlookup, Hlookup, Xlookup, Filter
-
Date
-
Auditing Tools
​
​
​
Optimising
-
Data Validation
-
Protect
-
Consolidate Data
-
Outline & Group
-
Templates
​
​
​
Automating & What IF Analysis Tools
-
Record a Macro
-
Customise Excel
-
Scenarios
-
Goal Seek
