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

MS Excel 365 Course Outline – Expert Level

Course Description

This expert MS Excel course is designed for users who have attended a master level course. The lessons show the desktop and web version.

By the end of this course, you will be able to explore Pivot Tables, using calculated fields, items, sorting, grouping fields and using VLOOKUP’s with Pivots amongst other topics.  You’ll be able to work with Macros, integrate Excel with Word, use Advanced Formula Features with creating Dynamic Named Ranges, look at information Functions including ISERR, ISERROR, ISBLANK, ISNUMBER, ISNA and ISFORMULA and work with Database Functions covering DSUM, DCOUNT, DMIN, DMAX and DAVERAGE plus lots more.

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

Topics Covered

Exploring Pivot Tables

Creating Calculated Fields
Creating Calculated Items
Sorting Pivot Table Data
Creating Filter Fields
Showing Filter Page Fields
Drilling Down Into the Data
Creating Pivot Tables from Multiple Ranges
Grouping Fields
Using VLOOKUP’s with Pivots
Percentages of Parent Row Totals
Summarise Values By
Inserting Timelines

Working with Macros

Assign Macros to Worksheet Controls
Exploring the Visual Basic Editor
Making Simple Edits to Macros
Disable Screen Flashing
Inserting Breakpoints
Creating Worksheet Functions
Using Worksheet Functions
Distributing Worksheet Functions

Excel Integration

Creating Hyperlinks to Files and Websites
Creating Links to Workshop Locations and Emails
Using Excel Data in Word
Using Excel Charts in Word
Using Excel Data as a Mail Merge
Importing & Exporting Data

Database Functions

DSUM & DCOUNT Functions
DMIN & DMAX Functions
DAVERAGE Function

Advanced Formula Features

Creating Dynamic Named Ranges
Assigning Formula Names
Data Validation with the INDIRECT Function
Creating Running Totals

Information Functions

ISERR Function
ISERROR Function
ISBLANK Function
ISNUMBER Function
ISNA Function
ISFORMULA Function

Introduction to Array Formulas

Understanding Array Formulas
Creating Array Formulas
Understanding Dynamic Arrays

Using Power Query

Cleaning and Shaping Data
Combining Data with Merge
Combining Data with Amend
Loading and Refreshing

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