top of page

8 Lessons.


· Basic Formulas


· Named Ranges, AVERAGE, MAX, MIN, Sorting Filtering

· Data Validation


· Graphs and charts


Each lesson includes instructional diagrams and ‘monkey see - monkey do’ video tutorials.

Has EAL support and stretch questioning throughout.

Most also include an online test (self marking, made via Google forms) that assess starting knowledge and progress.

A set of lessons that have proved highly successful.

Each lesson focuses on a real world case study to make the it more engaging and allow students to apply their skills to real world problems.

Also includes an assessment lesson which tests basic skills more widely across unit 6 software (Word, PPT & Excel).

Hope they help.


Please visit for more great teaching resources.

Every penny we make in selling resources goes directly to one of our 14 charity partners.


From youth groups to space science to carbon capture.

Excel Formulas - Basic to Advanced

    bottom of page