Language

Office 365

Excel

Millions of people use Excel on a daily basis, but many have never had any training. In this series we look at the most commonly used aspects of the software, from the basics e.g. creating calculations, sorting and filtering and adding charts, through the intermediate levels e.g. Lookup functions, Logical Functions, Text functions, Tables, Pivot tables and visualising data with maps and conclude with some more advanced topics including Data Consolidation, Sensitivity analysis, What If analysis, Auditing, Error handling and Protection and creating Dashboards. All sessions are one hour long and are complete with practice exercises and written notes.

Pivot Tables From Scratch module
3 Events

Pivot Tables From Scratch

Pivot Tables are one of the most revered – and feared – elements Of Excel. In this one-hour...

Filters (Sorting, Including Advanced Filters) module
2 Events

Filters (Sorting, Including Advanced Filters)

This one-hour session explores fundamental Excel skills that every user should benefit from including...

Charts Part 1 module
2 Events

Charts Part 1

One of the most used features of Excel is the ability to visualise data with charts, and this session...

Formulas Refresher module
2 Events

Formulas Refresher

This one-hour session is an essential for any Excel user that has never had formal training or is a bit...

Hints and Tips Part 2 module
2 Events

Hints and Tips Part 2

Learn how to get the most out of Microsoft Excel. In this course, you will learn how to automatically...

Hints and Tips Part 3 module
2 Events

Hints and Tips Part 3

This is a 5-part series though sessions don't need to be completed in succession. This one-hour session...

Hints and Tips Part 1 module
2 Events

Hints and Tips Part 1

Tips and tricks for Microsoft Excel including how to insert a chart, format shortcuts and incrementing...

Lookup Functions module
2 Events

Lookup Functions

Every Excel user knows that VLOOKUP is a tricky function to manage, but there are alternatives few people...

Hints and Tips Part 4 module
1 Event

Hints and Tips Part 4

This is a 5-part series though sessions don't need to be completed in succession. This one-hour session...

Hints and Tips Part 5 module
1 Event

Hints and Tips Part 5

This is a 5-part series though sessions don't need to be completed in succession. This one-hour session...

Extending and Customising a Pivot Table module
1 Event

Extending and Customising a Pivot Table

In this one-hour session we continue our exploration of Pivot Tables, and cover Expanding Pivot Table...

Logical Functions module
1 Event

Logical Functions

Logical functions in Excel allow you to have the program make decisions based on criteria you specify....

What If Analysis module
1 Event

What If Analysis

Excel has a number of tools that allow predictions to be made depending on several variables. This can...

Excel Tables module
1 Event

Excel Tables

Because of Excel’s tabular format a lot of people believe that they are already familiar with tables,...

Auditing, Error handling and Protection module
1 Event

Auditing, Error handling and Protection

Auditing tools allow users to problem solve formulas and ensure accuracy and error handling is an essential...

Hints and Tips Part 6 module
1 Event

Hints and Tips Part 6

Excel added a new feature a few years ago that makes it super easy to fill lists of things in a different...

Visualising Data module
0 Events

Visualising Data

In this session we discover how a simple Pivot Table and Chart can be graphically filtered to show your...

Charts Part 2 module
0 Events

Charts Part 2

This one-hour session continues the discussion of charts made in Part 1 and covers Plotting on a second...

Expanding a Pivot Table and Normalising Data module
0 Events

Expanding a Pivot Table and Normalising Data

In the final Pivot Tables session we conclude our training on this subject by discovering how the same...

Date and Time Functions module
0 Events

Date and Time Functions

Excel has many functions dedicated to dates and times, for example, to “date stamp” an invoice...

Data Consolidation module
0 Events

Data Consolidation

If your role involves combining sets of data that span several periods of time, it can be tricky if they...

Data Tables (Sensitivity Analysis) module
0 Events

Data Tables (Sensitivity Analysis)

Sensitivity analysis is a process by which different results can be predicted according to a number of...

Text Functions module
0 Events

Text Functions

Excel has a number of functions specific to text rather than numbers. In this one-hour session we look...

Hints and Tips Part 7 module
0 Events

Hints and Tips Part 7

Excel, and indeed all of Microsoft 365, has recently been upgraded with AI-powered tools. This Hints...

FAQ's

You can view the system in your local time by going to My Account > Edit Profile (Or click the timezone in the top bar > edit profile), once here you'll see a dropdown called timezone. If you change this to your timezone the platform will reflect this.
If you go to the My Account area, you will see all the learning events you've attended. You can download the related handouts for as long as you maintain your subscription. You can watch recordings of all events for up to 30 days after the event.
If you go to the My Account area, you will see all the learning events you've attended. You can access the recording of any session you attended for 30 days afterwards.
They will be emailed to you automatically and are accessible via the certificates tab on the My Account page.
Any courses or modules which are CPD accredited are clearly indicated
There may be an issue with your choice of speaker, please check your settings in Zoom.
Yes - our courses are designed to be accessed using any mobile device
On your Login page, hit the Forgotten Password button. Follow the instructions on the next Reset Password screen and you're done!
Courses:
24
Duration
24 hours
Login / Register
In order to access events you must have an Account.
Login / Register