top of page

Spreadsheets for Accounting

AAT Level 3
Session 1

Main Functions of Microsoft Excel

 

​LESSON

​

Conditional Formatting

 

Worked Example

Model Answer

​

Exercise 1

Model Answer

​

Exercise 2

Model Answer

​

Statistical Functions

 

Worked Example

Model Answer

​

Exercise 1

Model Answer

​

Exercise 2

Model Answer

​

Sorting and Filtering

 

Worked Example

Model Answer

​

Exercise 1

Model Answer

​

Exercise 2

Model Answer

​

Bar, Column and Line Charts

 

Worked Example

Model Answer

​

Exercise 1

Model Answer

​

Exercise 2

Model Answer

​

Pie Charts

 

Worked Example

Model Answer

​

Exercise 1

Model Answer

​

Exercise 2

Model Answer

​

Session 2

Advanced Functions of Microsoft Excel

 

LESSON

​

IF Statements

 

Worked Example

Model Answer

​

Exercise 1

Model Answer

​

Exercise 2

Model Answer

​

Nested IF Statements

 

Worked Example

Model Answer

​

Exercise 1

Model Answer

​

Exercise 2

Model Answer

​

HLOOKUP and VLOOKUP

 

Worked Example

Model Answer

​

Exercise 1

Model Answer

​

Exercise 2

Model Answer

​

Pivot Tables

 

Worked Example

Model Answer

​

Exercise 1

Model Answer

​

Exercise 2

Model Answer

​

bottom of page