Help yourself to our tools and resources

On this page, you’ll find a variety of resources, including handouts, course files, tools and training videos.

All these resources are free for you to use – please feel free to download them.

Handouts and info sheets

Excel Large Data sets (crime) – Warning – this file is nearly 100mb in size. Only download if you have a fast internet connection!

Serena’s Excel files

Microsoft PowerPoint training files

PowerPoint training day files

Microsoft Word training files

Word training day files

Training videos

Samples of our training

Take a look at these videos if you’d like to see how we explain things and get a taster for our style of training – or if you just want to learn a bit about Excel!

For a better experience, we’d suggest that you click the button to make the video full-screen as you watch it.

Part one of our guide to Excel PivotTables	Part two of our guide to Excel PivotTables
Adding calculated items to Excel PivotTables
Part one of our guide to conditional formatting in Excel	Part two: Advanced use of conditional formatting in Excel
Using Excel’s Subtotals tool	How to sort left to right in Microsoft Excel