Fast Track Excel for Data Analytics
for Cambridge Advanced National: Unit F202
15 ‘task sheets’ with matching ‘help sheets’ – take students from zero to ‘freeze top row’ in no time!
15 Task Sheets cover:
- Layout
- Formulae
- Formatting
- Formulae
- IF()
- Investments
- VLOOKUP()
- Sorting and Filtering
- Import & Charts
- Pivot Tables & Charts
- Interest and User Controls
- Errors
- Macros
A good clear resource... questions, step-by-step walkthroughs and assessments; the graphs and charts were all in support of the specification
Develop the spreadsheet skills to tackle the practical elements of their NEA task for Unit F202: Spreadsheet Data Modelling. Task sheets can be attempted by whizzes and novices alike to hone skills, with a matching help sheet for each.
- Essential skills – from basic formulae to pivot charts.
- Use before teaching the theory to quickly contextualise their understanding
- Full solutions provided
Share with others:
What do teachers say about this resource? (12846)
I very much liked the resource and the progression of the activities through the features on offer in the Excel Spreadsheet. A lot of work had clearly gone into creating the resource and the teacher/pupil files to support the material. The links to numeracy (mathematics) in the material were clear. The material offered questions, step-by-step walkthroughs and assessments; the graphs and charts were all in support of the specification ... A good clear resource. The millionaire spreadsheet forecast is good for raising aspiration... Nice and clear.
Keywords
- Certificate in IT: Data Analytics (H019)
- Cambridge Advanced Nationals
- Extended Certificate in IT: Data Analytics (H119)
- Unit F202: Spreadsheet Data Modelling
- OCR Cambridge Advanced Nationals Level 3 Alternative Academic Qualification
- Computing and IT AAQs from 2025
- Excel Worksheets
- Microsoft Excel 365
- Fast Track Software Guides