top of page

## Spreadsheets for Accounting

###### AAT Level 3

###### Session 1

#### Main Functions of Microsoft Excel

##### Conditional Formatting

##### Statistical Functions

##### Sorting and Filtering

##### Bar, Column and Line Charts

##### Pie Charts

###### Session 2

#### Advanced Functions of Microsoft Excel

##### IF Statements

##### Nested IF Statements

##### HLOOKUP and VLOOKUP

##### Pivot Tables

bottom of page