Syllabus Detail

• Create solutions using a spreadsheet application using:

  • functions
  • charts
  • lookup table
  • sorting
  11 ATAR, 12 GEN

1. Functions

2. Charts

3A. Learn
Make a solution with a Vlookup Example from a Teacher's Marks Book 

3B vlookup (continued)

        Go to the our AIT website page HERE and make your own vlookup spreadsheet

3C Microsoft background details about Lookup HERE

3D Microsoft details about vLookup HERE

 4. Sorting

Further Research

• Learn everything there is to know about Excel from Microsoft's Office Support website

Found an error or enhancement? Please fill out this contact us form.