If you would like to learn how to navigate and use excel on your own, then this one day classroom training is for you.

This Central London training course, may contribute to ACCA members’ Continuing Professional Development requirements. 

EXCEL FOR BEGINNERS TO INTERMEDIATE - 1 DAY TRAINING COURSE

Navigation (Parts of the Screen)
Sheet within a workbook
Moving around on a sheet
Menu Bar
Toolbar - Toolbar options
Name Cell
Function (formula box)

Grouping Columns & Rows
Grouping / Hiding Rows & Columns
Grouping in Groups
Why Grouping instead of hiding

Cutting, Copying & Pasting
Using Ctrl keys
Using Icons
Using Menu
Dragging / Auto fill
Copying values and formulas between sheets
Copying values and form

Copy with absolute address Copying formulas
Using absolute addresses
Using F2 & F4
Using cell names

10 Formulas / Functions
= SUM
= Max / Min / Average
= Left / Right / Mid
= Concatenate
= Sumif
= VLookup
= HLookup
= Indirect

Using Filters
Using Sub totals

For availability, click here

 

This course costs £245 and you will receive your own PC, training manual, refreshments and a light lunch.

If you have a colleague that would like to attend, then they may share your PC for an additional £100.  All prices exclude VAT.