How to use Formulas and Functions in Microsoft Excel

In this video tutorial, I will show you how to use formulas and functions in Microsoft Excel. I will start with basic math formulas in Excel and show you some of the very popular and powerful functions. Use the timestamps below to help you navigate through this video.

Download the practice file here. You will need to go to file and save as: https://leveragingdigitalinc-my.share...

My playlist to all of my Microsoft Excel Tutorials:    • Excel for Beginners: Easy Steps to Get Sta...  
VLOOKUP Tutorial:    • Vlookup Function in Excel for Beginners  

0:00 Intro
0:49 Basic math formulas
3:20 Starting with the SUM Function in Excel (with shortcuts)
5:47 The COUNT function
6:29 Take a look at the status bar in Excel
8:10 AVERAGE, MEDIAN and MODE functions
10:05 MIN and MAX functions in Microsoft Excel
10:54 Functions and formulas with Date and time in Excel
14:11 Using formulas to combine columns
16:05 If statements in Excel
19:26 How VLOOKUP works
21:34 Conditional functions (SUMIF, SUMIFS, COUNTIF, etc.)
24:33 How to use the function wizard

Microsoft Excel for Beginners - Level 1:    • Microsoft Excel Tutorial -  Beginners Level 1  
Microsoft Excel for Beginners - Level 2:    • Microsoft Excel Tutorial - Beginners Level 2  
Microsoft Excel for Beginners - Level 3:    • Microsoft Excel Tutorial -  Beginners Level 3