Navigation

Spreadsheet tutorials

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

  • Search for the topic to find the exercise you would like to complete.  
  • Download/view the video file from the list at the bottom of the page. 
Showing 7 items
SubjectTopicSpreadsheet topicExercise
Sort 
 
Sort 
 
Sort 
 
Sort 
 
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
Č
č
ď
Exercise1.7.mp4
(2867k)
Deborah Seed,
Jan 18, 2012, 1:19 PM
č
ď
Exercise1.7a.mp4
(7789k)
Deborah Seed,
Jan 18, 2012, 1:58 PM
č
ď
Exercise1.7b.mp4
(12795k)
Deborah Seed,
Jan 18, 2012, 2:35 PM
č
ď
Exercise1.7c.mp4
(7283k)
Deborah Seed,
Jan 18, 2012, 11:38 PM
č
ď
Exercise3.1Formulas,IFfunction.mp4
(13993k)
Deborah Seed,
Jan 18, 2012, 11:41 PM
č
ď
Exercise3.3.mp4
(8161k)
Deborah Seed,
Jan 19, 2012, 2:07 PM
č
ď
Exercise3.7.mp4
(15642k)
Deborah Seed,
Jan 19, 2012, 1:33 PM
Comments