Intermediate Microsoft Excel – Princess Gate – 21st February 2020



Sample Files

Functions Explanation

Sports Shop – VAT – Starter

Sports Shop – VAT – Final

Sports Shop Orders – Starter

Sports Shop Orders

Data (Data file for Filter, Subtotal and Pivot Table Exercises)


Filter -Grapes Only

Filter Grapes and Oranges

Filter – Apples Origin Local

Filter – Friday Sales Greater than £200

Filter – Sales Local Between £200 and £300

Filter – Europe Top 10 Sales


Pivot Tables

Pivot Chart Example

Original – Unprotected

Protect Worksheet – Locked Cells Only

Protect Workbook

Online Quiz

Intermediate Microsoft Excel Quiz

Advanced Excel Quiz

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.