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
Grade Levels
Product Rating
Product Q & A
File Type

Unknown Format

Be sure that you have an application to open this file type before downloading and/or purchasing.

14 MB|18 pages
Share
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
Loading...
$4.21
Digital Download
List Price:
$4.95
You Save:
$0.74
More products from Rob-Bot Resources
Product Thumbnail
$0.00
Product Thumbnail
$0.00
Product Thumbnail
$0.00
Product Thumbnail
$0.00
Product Thumbnail
$0.00
$4.21
Digital Download
List Price:
$4.95
You Save:
$0.74
Teachers Pay Teachers

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

Learn More

Keep in Touch!

Sign up