Microsoft Excel Video Guides - School Production

This resource contains 66 videos which take students through how to use the basics and more advanced features of MS Excel.

An intro video showing what students will create can be found here.

This is a tried and tested unit which works with a broad range of abilities and usually takes about 8 hours to complete in full.

Students need to create a school production spreadsheet which contains IF Statements, charts, vLookups, Macros, Conditional Formatting to name but a few.

The pack contains a checklist which students can use to monitor their progress. The checklist also links to all of the videos.

Save for later
  • Example-Spreadsheet.xlsm
  • Music-Festival-Model.pptx
  • Video-Guides.docx

About this resource


Created: Jun 15, 2017

Updated: Apr 23, 2018

Unit of work

xlsm, 168 KB



pptx, 1 MB


Unit of work

zip, 241 KB


Report a problem

Tes Paid Licence

How can I re-use this?