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.

example image
1 Events

Filters, Sorting including advanced filters

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

example image
1 Events

Charts Part 1

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

example image
1 Events

Pivot Tables Part 1

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

example image
1 Events

Hints and Tips Part 3

This one-hour session covers some more hints and tips for all users of Microsoft Excel including A S...

example image
1 Events

Pivot Tables Part 2

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

example image
1 Events

Visualising Data

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

example image
1 Events

Hints & Tips Part 4

This one-hour session covers some more hints and tips for all users of Microsoft Excel including App...

example image
1 Events

Pivot Tables Part 3

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

Diploma
Yes
Modules
8
Duration
8 hours