Excel Video Tutorials

Formula Basics

• How to enter a formula
• How to apply a formula to an entire column
• Relative and Absolute cell referencing

If Functions and Formulas

• Conditional Expressions
• Introduction to the IF function

Summing and Counting Functions and Formulas

• COUNT Function
• MAX Function
• MIN Function
• SUM Function

Advanced Excel Formulas

• VLOOKUP Function and formulas
• Introduction to Date functions
• Linking Data between sheets and workbooks

Other Useful Stuff

• Conditional formatting - Introduction
• Pivot Tables - Introduction
• Excel's Evaluate formula tool