Excel - formulas & functions

Formulas

• What is a formula
• BODMAS theory
• Creating a formula
• Copying formulas
• Absolute References in formulas

Linking Formulas

• Advantages of Linking
• Creating a link

Functions

• What is a function
• Function syntax
• Using Paste function

Date Functions

• The Today function
• The Now function

Text Functions

• The Upper function
• The Lower function
• The Proper function 

Math and Trig Functions

• The Sum function
• Using AutoSum
• The Average function
• The Min function
• The Max function
• The Count function
• The CountA function
• The CountBlank function
• The Int function
• The Round function
• The RoundUp function
• The RoundDown function 

Financial Functions

• The Payment function (PMT)

Logical Functions

• The IF fFunction
• The Countif function 

Is Functions

• The IsError function
• The IsText function
• The IsBlank function

Lookup Functions

• The VLookup Function
• The HLookup function