docx, 182.82 KB
docx, 182.82 KB
xlsx, 17.55 KB
xlsx, 17.55 KB
xlsx, 10.29 KB
xlsx, 10.29 KB
docx, 601.12 KB
docx, 601.12 KB
xlsx, 14.37 KB
xlsx, 14.37 KB
xlsx, 16.13 KB
xlsx, 16.13 KB
docx, 271.34 KB
docx, 271.34 KB
xlsx, 9.84 KB
xlsx, 9.84 KB
docx, 296.53 KB
docx, 296.53 KB
xlsx, 17.64 KB
xlsx, 17.64 KB
docx, 249.49 KB
docx, 249.49 KB
*Updated June 2016! 2 more resources added!*
A selection of easy to follow task sheets and accompanying Excel spreadsheet to develop more complex spreadsheet skills. Techniques covered include working with 3D cell references in a formula, beginning to use VLOOKUP, using AND within an IF statement, the PMT function, the ROUND and RANK functions, Data Validation and applying Conditional Formatting.

These Advanced Spreadsheets resources were developed originally to help students build skills required for the Level 3 Advanced ECDL, but are also useful for developing more complex spreadsheet skills for other purposes, both at KS4 and KS5.

Files:
3D Referencing and LOOKUP
3D-Referencing-and-LOOKUP-in-Excel.docx - instructions / task sheet
3D-Ref---Student-Markbook.xlsx - 4 worksheets to be used with this task

Conditional Formatting
Conditional-Formatting---Quick-Practice.xlsx - 5 sets of data requesting different conditional formatting

Data Validation
Data-Validation-in-Excel.docx - instructions / task sheet
Data-Validation-Workbook.xlsx - 3 worksheets to be used with the Data Validation task

IF and AND
IF-AND-in-Excel.docx - instructions / task sheet
Animal-Rescue-Worksheet.xlsx - 4 worksheets to use with the IF and AND task

PMT Function
Loans-Spreadsheet.xlsx - a worksheet containing details of 6 loans to calculate the repayments on
PMT-in-Excel.docx - instructions / task sheet

ROUNDUP and RANK
ROUNDUP-and-RANK.docx - instructions / task sheet
Measurements-and-Statistics.xlsx - multi-sheet workbook containing data to use with the task sheet

Reviews

Something went wrong, please try again later.

This resource hasn't been reviewed yet

To ensure quality for our reviews, only customers who have purchased this resource can review it

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.