ExcelHow2: A guide to understanding Excel spreadsheet software

ExcelHow2: A guide to understanding Excel spreadsheet software
ExcelHow2: A guide to understanding Excel spreadsheet software
ExcelHow2: A guide to understanding Excel spreadsheet software
ExcelHow2: A guide to understanding Excel spreadsheet software
ExcelHow2: A guide to understanding Excel spreadsheet software
ExcelHow2: A guide to understanding Excel spreadsheet software
ExcelHow2: A guide to understanding Excel spreadsheet software
ExcelHow2: A guide to understanding Excel spreadsheet software
Also included in:
  1. This package includes all my top selling Excel resources including How2Excel, an introductory guide to the use of Excel and Excel Dino Park, where you're put in charge of the finances and budget of your own dinosaur Park!
    $12.85
    $9.95
    Save $2.90
Product Description

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.

Total Pages
18 pages
Answer Key
Does not apply
Teaching Duration
3 Weeks
Report this Resource to TpT
Reported resources will be reviewed by our team. Report this resource to let us know if this resource violates TpT’s content guidelines.
Loading...
$4.95
Digital Download
Share this resource
Report this resource to TpT
More products from ROBBOT RESOURCES
Product Thumbnail
Product Thumbnail
Product Thumbnail
Product Thumbnail
Product Thumbnail

Teachers Pay Teachers is an online marketplace where teachers buy and sell original educational materials.

Learn More

Keep in Touch!

Sign Up