How calculations work in Excel
Adding and Subtracting Numbers
Multiplication and Division
Percentage calculations
Understanding BODMAS
SUM function
AUTOSUM
Useful Basic Functions AVERAGE, MIN, MAX and COUNT
Referencing
Relative and absolute cell references
Linking within a workbook
3D references
References between workbooks
Conditional Formatting
Conditional Formatting Types
Highlight Cells different colours based on their value
Top Bottom Rules
Icon Sets
Data Bars
Colour Scales
Customising Conditional Formatting
Date and Time Calculations
Date Shortcuts
TODAY and NOW functions
DATEDIF function
YEAR, MONTH, DAY, TEXT functions
NETWORKDAYS function
Miscellaneous
Adding, Editing and Deleting Notes
Using the Fill tools
Custom lists
Working with data
Sorting
Filtering
Splitting data
Splitting windows
Freezing rows and columns
Presenting Data Using Charts
Creating a chart
Modifying charts
Formatting charts
Advanced Chart Features
Multi-Axis charts
Quick Analysis Tool
EXCEL 365 LEVEL II - 1 day intermediate course
This intermediate course builds on the introductory level I course. It extends learner knowledge by looking in more detail at cell referencing and how calculations work in Excel. It then goes on to cover cell and condition formatting and how to display data in the form of charts.