Excel for Beginners: Easy Steps to Get Started - How to use Formulas and Functions in Microsoft Excel

5.0 (3)

22 learners

What you'll learn

This course includes

14.5 hours of video
Certificate of completion
Access on mobile and TV

Summary

Keywords

microsoft excel excel formulas excel functions excel tutorial excel for beginners microsoft excel training teachers tech jamie keet how to make a formula in excel how to make a function in excel excel training excel formulas and functions tutorial

Full Transcript

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