How2Excel: A guide to understanding Excel spreadsheet software
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!***
$6.18
Save for later
  • How2Excel.xlsm

About this resource

Info

Created: Feb 27, 2017

Updated: Aug 15, 2019

xlsm, 15 MB

How2Excel

Report a problem

Get this resource as part of a bundle and save up to 22%

Tes Paid Licence

How can I re-use this?