Pre-requisites
It is assumed that the participant will have either attended an Excel Intermediate course or has equivalent knowledge.
Objectives
By the end of this course you will be proficient in the use of advanced formulae and functions, you will have gained an understanding of Formula referencing and be able to create multi function calculations.
Formulae
Refresh on Formulae
Absolute referencing
Mixed referencing
Named Ranges
Add & delete a named range
Use named ranges in a formula
Natural Language
Set Display Options
Customise Quick Access Toolbar
Customise the Ribbon
Excel Options
Advanced Autofill
Fill Weekdays
Fill Values Only
Growth Trend
Format Worksheets
Apply accounting, currency & scientific formats
Create custom number formats
Conditional formatting
Multiple Workbooks
Link workbooks
Use multiple workbooks
Save a workspace
Consolidate information
Forecasting
Goal Seek
Advanced Functions
String functions
Logical functions
Random numbers and rounding
Nesting If’s
CountIfs
SumIfs
Handling errors
HLookups
VLookups
Date Functions
Subtotals
Auditing a Worksheet
Check and review data
Finding cells that refer to a specific formula
Finding formulas that refer to a specific cell
Finding errors