Microsoft Office Excel 2019

MS Excel 365 Course Outline – Advanced level

Topics Covered

Logical Functions

IF Function
Nesting Functions
AND & OR Functions
NOT Function
IFS Function
IFERROR Function
IF with AND and OR Functions

Maths and Statistical Functions

COUNTA Function
COUNTIF Function
ROUND Function
SUMIF Function
INT Function
RANK Function
SMALL and LARGE Functions

Lookup Functions

VLOOKUP Function
HLOOKUP Function
Using the INDEX Function
Using the MATCH Function
INDIRECT function
UNIQUE function
XLOOKUP Function

Text Functions

Text Case Functions
LEFT, RIGHT and MID Functions
TRIM Function
LEN Function
SEARCH Function

Working with Dates and Times

Calculations with dates
Calculations with times
Subtracting and adding date values
Date/Time functions
Age calculations
Adding and subtracting years, months and days
WORKDAY function

Exploring Charts

Value Comparison Charts (Column, Bar)
Category Comparison Charts (Pie, Doughnut)
Time Related Charts (Line, Area)
Data Correlation Charts (Scatter)
3D Data Charts (Bubble, Surface)
Financial Charts (Stock)
Multiple Criteria Charts (Radar)
Data Frequency Charts (Histogram, Pareto)
Process Charts (Waterfall, Funnel)
Visual Analysis Charts (Box and Whisker)
Hierarchical Data Charts (Sunburst, Treemap)
Geographical Charts (Map)
Combined Charts
Advanced Chart Editing
Advanced Chart Formatting

Can't see what you need?

All Microsoft Office Online Courses are based on a typical one day training course at a specific skill level and are included in our full online library. If you require a more tailored course to meet a particular learning need, get in touch.

All Personal Development Online Courses are 15 minute modules that complement our Bite Size methodology and work well together to create a great training plan.

Great deals for Corporate licences – give us a call.


Sign up for our free weekly tip

Receive a free nugget of IT Learning every week! It will give you a good feel for how we write and design our lessons and you could learn something new every week too!