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.sharepoint.com/:x:/g/personal/jamie_leveragingdigital_com/EYOTH-D8bPJNk0BjpQzLlMUB5NVu6zJqCYC1gXj-UYh_oA?e=bjydfT
My playlist to all of my Microsoft Excel Tutorials: https://www.youtube.com/playlist?list=PLmkaw6oRnRv8lAKbKbflJRqS-9wuYNWUw
VLOOKUP Tutorial: https://youtu.be/Lw03WcG4mt4
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: https://youtu.be/k1VUZEVuDJ8
Microsoft Excel for Beginners - Level 2: https://youtu.be/bhZckWTLkJM
Microsoft Excel for Beginners - Level 3: https://youtu.be/47yu50CsH00
