Advanced Microsoft Excel

Excel

Course Leaflet – Advanced Excel

Course Leaflet – Advanced Excel (Cymraeg)

Sample Files

Rainfall

Link Excel Data Copy and Paste

Embed Excel Data

Sales – Starter

Sales – Final

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

Filter

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 -Top 10 Sales

Advanced Filter – World

Advanced Filter – Apples or Oranges

Advanced Filter – World and Sales Greater than £1000

Slicers

Subtotals

Pivot Tables

Pivot Chart Example

Original – Unprotected

Protect Worksheet – Locked Cells Only

Protect Workbook

Scenario Manager – Starter

Scenario Manager – Final

Goal Seek – Starter

Goal Seek – Final

Online Quiz

Advanced Excel Quiz

Leave a Reply

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

WordPress.com Logo

You are commenting using your WordPress.com 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.