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!***
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!***
Get this resource as part of a bundle and save up to 22%
A bundle is a package of resources grouped together to teach a particular topic, or a series of lessons, in one place.
Something went wrong, please try again later.
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.
Been waiting for a resource like this! <br /> Life changing!
Another fantastic resource! Amazing.
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.
£4.95