+44 (0)20 3283 8799 enquiries@bitesizeltd.com
Log in
+44 (0)20 3283 8799 enquiries@bitesizeltd.com
Microsoft Office Excel 2019

MS Excel 365 Course Outline – Advanced level

Course Description

This Advanced MS Excel 365 Course is designed for users who have attended an intermediate level course or are already confident with the basic features.  The lessons show the desktop and web version.

By the end of this course, you will be able to work with logical functions such as IF, Nesting IFs, IFS and IFERROR as well as using COUNTA, COUNTBLANK, ROUND, SUMIF. Take advantage of Lookup Functions such as V and XLOOKUP. Work with Text functions and work with dates and times when using formulas. Lastly understand when to use which chart to visualise data
with, plus lots more.

Estimated course duration is 3-4 hours. Each lesson takes on average 3-5 minutes to complete.​ This Course is CPD Certified.
Download PDF

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
COUNTBLANK 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
CONCATENATE and CONCAT Functions

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
NETWORKDAYS function
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)
Sparklines
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.

GET IN TOUCH

On-line courses

Face to face Workshops

Virtual On-line Classes

On-line Shop for 1 to 50 licences

Personalise your own course

Create your own branded learning site
bitsy

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!

Sign Up See our Tips