Spreadsheets for Accounting

AAT Level 3
Session 1

Main Functions of Microsoft Excel

 

​LESSON

Conditional Formatting
Statistical Functions
Sorting and Filtering
Bar, Column and Line Charts
Pie Charts
Session 2

Advanced Functions of Microsoft Excel

 

LESSON

IF Statements
Nested IF Statements
HLOOKUP and VLOOKUP
Pivot Tables