Excel Power Coaching for Accountants

Microsoft Excel is the essential tool for accountants. As well as calculations, Microsoft Excel can process data and save you hours of mindless work.

This coaching is targeted at financial professionals who are experienced Excel users, and it will deliver the skills and ideas to automate their time-consuming tasks, and extract meaningful information from large data tables.

½ Day Intensive

Public Course

Consultancy Available

Printable Version

Outline

The essential shortcuts

Table design

Layout data for best results

Reorganise existing data into
a workable table

Record macros

Create a macro to format a
spreadsheet

Create a macro to add data and
run calculations on a datasheet

Templates

Create a template for data entry

Secure the template to protect
formulas

Control the data types that can be input on the template

Data analysis

Advanced Pivot Tables

Link sheets and files in Excel

Import and link information from the web

Complex formulas

Simple method to create complex formulas

Analyse complex formulas

Array formulas

Question Time

Afterwards…

If you would like to have a course customised for your organisation, please contact us.

Back to Software Training Course List