Basic
-
Screen Elements
-
Create
-
Basic 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
Basic Functions & PivotTables
-
Absolute Cell References
-
Range Names
-
Sum, Max, Min, Ave
-
PivotTables
-
Slicers
-
PivotCharts
-
Table
Large Worksheets & Charts???
-
Printing Options
-
View Options
-
Hide
-
Charts
-
Sparklines
-
Formatting
-
Format Painter
-
Styles
-
Conditional Formatting
-
Custom Formatting
PivotTables & Charts
-
PivotTables
-
Slicers
-
PivotChart
-
Tables
-
Analyse
-
Charts
-
Sparklines
Functions and Auditing Tools
-
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
Excel Half Day Courses
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.