This page contains details and links to Excel spreadsheet tutorials for AAT Level 3

Spreadsheet tutorials
Subject  Topic  Spreadsheet topic  Exercise 

Costs and Revenues  Prime cost, production overheads, other overheads  Creating and saving a workbook  Exercise 1.7 
Costs and Revenues  Prime cost, production overheads, other overheads  Adding and formatting text data  Exercise 1.7a 
Costs and Revenues  Prime cost, production overheads, other overheads  Adding and formatting numerical data  Exercise 1.7b 
Costs and Revenues  Prime cost, production overheads, other overheads  Presenting spreadsheet data  Exercise 1.7c 
Costs and Revenues  Labour costs: Bonus based on hours saved  Formulas, IF function  Exercise 3.1 
Costs and Revenues  Labour costs: Piecework with minimum guaranteed wage  Formulas; IF function  Exercise 3.3 
Costs and Revenues  Labour costs: Basic wage and Overtime premium  Cell merging; Autofill; Absolute cell addressing; IF function (adv)  Exercise 3.7 
Showing 7 items