This course is for experienced users of Excel who wish to gain a wider understanding of how more complex formulas and functions can be used in their everyday tasks.
Logical Functions
Testing cell contents using the If function
Nested Ifs
Multiple tests using If, And & Or
SumIfs, CountIfs And AverageIfs
Naming Ranges
Revision of absolute & mixed cell addressing
Naming a cell for use in a formula
The Name Manager
Lookup Functions
Lookup functions
Combining the Index And Match functions
Is Functions
IsError
IsText
IsNumber
IsBlank
Nesting If & Is functions
Date and Time Functions
Custom formats for dates & times
Today, Now
Year, Month, Week, Day, Weekday
Hour & Minute
Calculating dates
Text Functions
Text to columns tool
Left, Right & Mid
Concatenate
Upper, Lower & Proper
Trim & Find
Formula Auditing
Tracing errors
Tracing precedents & dependents
Showing formulas
Evaluating formulas
New Functions in 2013
IfNA
Days
IsFormula
FormulaText
Xor
Previous knowledge of Excel is essential as is the ability to construct basic formulas and functions.