Microsoft Office Excel – Formula Expert Class
1 Day Duration
Overview
This specialist course, is aimed at Excel users who have basic formula knowledge, but would like to experience the full capabilities of Excel. It covers a recap on the rules to follow when creating formulas, then works through over 50 of the most popular functions built in to Excel. The course also covers combining functions together to create intelligent and sophisticated reporting spreadsheets.
Recapping the Basics
BODMAS Theory
Operators
Formula bar and formula palette
Most Common Functions
SUM
COUNT
MAX
MIN
AVERAGE
Statistical Functions
COUNTA
COUNTBLANK
COUNTIF
FORECAST
LARGE
SMALL
MEDIAN
MODE
Financial Functions
PMT
Lookup and Reference Functions
LOOKUP
VLOOKUP
HLOOKUP
COLUMN
HYPERLINK
ROW
Mathematical Functions
EVEN
EXP
INT
ODD
ROUND
ROUNDDOWN
ROUNDUP
SUBTOTAL
SUMIF
Date and Time Functions
TODAY
NOW
DATE & DATEDIF
DAY
MONTH
YEAR
WEEKDAY
NETWORKDAYS