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