Gaining Steam in Excel: An Intermediate Guide

This is the second part of our Excel series following on from our Basic session.

Build your knowledge of Excel Features with Data Validation, conditional formatting, tables and much more.

In this 60 minute live webinar session we will demonstrate how to start to interrogate your data and gather information in your Excel sheet. You will walk away knowing how to:

Make it easier to display the data you want to show
Make it easier to work with your data or restrict what others can add into your data.

All the learning materials in this course will be shared with you so you can reference them at a later stage which will be uploaded into the learning portal below.

*Disclaimer* we shall be presenting using the app version of Excel so older or online versions may not be as feature rich.

Badge earned on completion

Difficulty

Shareable Certificate

Key Takeaways

Data Cleansing – get your data ready for analyse with these data cleansing tips and tricks
Using Data Validation – ensure the data being entered meets the correct criteria by using drop-downs and setting parameters
Conditional Formatting – Applying conditional formatting to make your results stand out
Using Filters – to gain insight into your data and interrogate your data by using filters.
History – learn how to generate both spreadsheet and cell history