Fast Track Excel for Data Analytics
for Cambridge Advanced National: Unit F202
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
15 ‘task sheets’ with matching ‘help sheets’ – take students from zero to ‘freeze top row’ in no time!
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
Keywords
- Unit F202: Spreadsheet Data Modelling
- Extended Certificate in IT: Data Analytics (H119)
- Microsoft Excel 365
- Cambridge Advanced Nationals
- Excel Worksheets
- Certificate in IT: Data Analytics (H019)
- OCR Cambridge Advanced Nationals Level 3 Alternative Academic Qualification
- Computing and IT AAQs from 2025