It's easy to pick up and start using Excel for small data collection tasks, only to find they grow into large unwieldly spreadsheets full of inconsistencies and time-consuming work arounds.

Join this session to find out how to get your spreadsheets on track and doing what they're meant to be doing - saving you time, facilitating effective service delivery and enabling you and your team to get insight into the bigger picture.

There are 2 prior courses relating to this session that you can join, to build your knowledge and skills in Microsoft Excel further. Please see below for links to book onto those sessions.

This session will cover

• Data validation & pick lists
• Splitting columns
• Introduction to pivot tables

Pre-course requirement

You will need to be able to join this session from a PC or laptop with Excel installed to be able to participate in the training. The session is designed for people using Microsoft Excel 2016, 2019, 2021 or the Microsoft 365 Excel desktop App on a Windows PC / laptop. If you have an earlier version of Excel, are using the Microsoft 365 Web App in a browser, or are working on a Mac, you'll find that some of the features we look at either don't exist or are accessed differently. Please check the version of Excel you are running by opening Excel, click on ‘file’ and then on ‘account’ and you will see the version you are running in the right hand-side of the window.

To Register