Tutorials: Formulas and Functions in Excel

Extract Text from Cells - Intermediate Example  (Intermediate)
- This is a video tutorial that will show you how to use the FIND() LEN() LEFT() a
Remove #N/A Error Result from Empty VLOOKUP() Formulas  (Intermediate)
- This video tutorial will show you how to remove the #N/A error that results in a
Lookups With MATCH() and INDEX() Functions  (Intermediate)
- This video tutorial will show you how to use the MATCH() and INDEX() functions w
Introduction to Making Formulas in Excel  (Easy)
- Here, you will learn what formulas are and how they can benefit you in excel. Th
IF Statement Introduction & Using Nested IF's  (Easy)
- How to use a basic IF statement. If you've never used one before, this will show
HLOOKUP() Function - Introduction  (Intermediate)
- This is a video tutorial that shows you how to use the HLOOKUP() function in exc
Function and Formulas Lookup in Excel  (Easy)
- This video tutorial will show you how to use the insert function feature in exce
AND(), OR(), and IF() Statements/Formulas  (Intermediate)
- How to use AND() and OR() functions within and IF statement and also what the AN
Absolute and Relative Cell References
- & INDIRECT() Function Introduction
(Easy)
- This is a video tutorial for Microsoft Excel which shows you how to make absolut
Dynamically Update a Drop Down Menu/List  (Intermediate)
- This Excel video tutorial shows you how to create a dynamically updating drop-do
Generate Random Numbers (Integers) in Microsoft Excel  (Easy)
- This Excel video tutorial shows you how to generate random numbers (integers) in
Generate Random Numbers with Decimals in Microsoft Excel  (Intermediate)
- This tutorial shows you how to generate random numbers which have decimals in ex
Make Dynamic (Automatically Updating) References in Formulas and Functions in Excel  (Intermediate)
- This excel vidoe tutorial shows you how to make a truly dynamic range reference