Charity Digital Academy: Advanced Excel - tips and tricks

Join this 3 hour session to find out how to optimise your spreadsheets so they can do 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.

This hands-on workshop will guide you through demos and practical exercises using a sample spreadsheet. Key features covered include:

• Smarter formulas that save you time

• Conditional formatting, data validation, and other techniques to keep your data tidy

• Using Pivot Tables to summarise and rearrange data

• Connect, clean & organise data from different sources using Power Query