How to Use Formulas and Functions in Microsoft Excel

Overview

Save Big on Coursera Plus. 7,000+ courses at $160 off. Limited Time Only!

Grab it

Learn essential Excel skills in this comprehensive 26-minute video tutorial. Master basic math formulas, popular functions like SUM, COUNT, AVERAGE, and VLOOKUP, and advanced techniques such as working with dates, combining columns, and using conditional functions. Follow along with timestamps for easy navigation, download the practice file, and gain practical knowledge on utilizing the function wizard. Perfect for beginners and intermediate users looking to enhance their Microsoft Excel proficiency.

Syllabus

Intro.
Basic math formulas.
Starting with the SUM Function in Excel (with shortcuts).
The COUNT function.
Take a look at the status bar in Excel.
AVERAGE, MEDIAN and MODE functions.
MIN and MAX functions in Microsoft Excel.
Functions and formulas with Date and time in Excel.
Using formulas to combine columns.
If statements in Excel.
How VLOOKUP works.
Conditional functions (SUMIF, SUMIFS, COUNTIF, etc.).
How to use the function wizard.