+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 – Master Level

Course Description

This master MS Excel course is designed for users who have attended an advanced 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 financial functions such as PMT, FV, PV and Rate, Lookup and Reference Functions such as Match, Index, Offset, Filter and Sort, Pivot Tables and Charts, Documenting and Auditing, Manipulating Data including Sorting, Compare and Merge and Flash Fill, Automating repetitive tasks with Macros 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

Financial Functions

PMT Function
FV & PV Functions
RATE Function

Using LOOKUP & Reference Functions

Combining MATCH with INDEX
Combining LOOKUP with MATCH
Using LOOKUP Functions with Named Ranges
OFFSET Function
FILTER Function
SORT Function

PivotTables & Pivot Charts

Working with PivotTables
Rearranging PivotTables
Slicers
Formatting PivotTables
Pivot Charts
Using GETPIVOTDATA with Pivot Tables

Documenting and Auditing

Formula errors
Evaluating formulas
Using the Watch Window
Using Comments
Data Validation
Workbook co-authoring
Displaying & printing formulas

Manipulating Data

Sorting by value
Sorting by formatting
Advanced sorting features
Converting Text to Columns
Compare & merge data
Flash Fill
Automating repetitive tasks

Explaining Macros

Macros Security Levels
Recording Macros
Running Macros
Assigning Macros to Quick Access Toolbar

Analytical Options

Goal Seek
Solver
The Analysis Toolpak/Quick Analysis Tool

Scenarios

Data Tables
One Input Variable
Two Input Variable

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