xlsm, 14.72 MB
xlsm, 14.72 MB
Ideal to support the delivery of GCSE, BTEC and ECDL ICT courses!

If you like the quality of my other resources, you won't want to miss this!!!

A comprehensive guide on a broad range of differentiated Excel skills which include;
Data Types: Raw, Changing Type, Relative & Absolute Cell Referencing
Formatting: Cells, Colours, Font & Borders
Basic Arithmetic Formulas: Simple arithmetic (+ - * /), Relative & Absolute Formulas, Common Errors
Functions: SUM, AVE,MIN, MAX, COUNT, COUNTA, ROUND
Advanced Functions: BOOLEAN (< > =), COUNTIF, IF, Nested IF, LOOKUP, CONCATENATE
Applying Cell Referencing
Validation Rules: Including Drop Down Lists
Using Table Filters
Creating Graphs and Charts
Conditional Formatting
Creating Macros

Each skill includes a tutorial and a task to show you how to apply it.

There are also two consolidation exercises which require the application of a range of skills learned within the tutorials. These include;
Create an Interactive Spreadsheet
Dream Team Generator

A checklist at the start of the workbook allows you to keep track of your progress.

***Please Leave a Review!***

Reviews

5

Something went wrong, please try again later.

annah_sigola

6 years ago
5

Ro_Milli0110

7 years ago
5

I'm not an expert on Excel - I don't use it much. I like the way it is set out so that you can do the exercises and then progress onto the next stage. I learnt some good shortcut tips.

john195

7 years ago
5

Been waiting for a resource like this! <br /> Life changing!

TMarshall123

7 years ago
5

Another fantastic resource! Amazing.

rohan8

7 years ago
5

Really well written and gave me some great help in running my classes

Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.