Excel 2007/2010/2013/2016 Advanced - Formulae and Functions
Short course
In Cambridge
Description
-
Type
Short course
-
Level
Advanced
-
Location
Cambridge
-
Duration
1 Day
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. Suitable for: Designed for existing users of Excel.
Facilities
Location
Start date
Start date
About this course
It is assumed that the participant will have either attended an Excel Intermediate course or has equivalent knowledge.
Reviews
Subjects
- Formula referencing
- Create multi function calculations
- MS Excel
- Excel
- Excel 2007
- Excel 2010
- Excel 2013
- Excel 2016
- Accounts
- Accounting
Teachers and trainers (1)
TBA TBA
Trainer
Course programme
Excel Advanced Advanced Formulae and Functions
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 WorkbooksLink workbooks
Use multiple workbooks
Save a workspace
Consolidate information
Forecasting
Goal Seek
Scenario Manager
Solver
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
Additional information
Excel 2007/2010/2013/2016 Advanced - Formulae and Functions