Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

How to Use Formulas and Functions in Microsoft Excel

Teacher's Tech via YouTube

Start learning Write review
Coursera Ad

Learn AI, Data Science & Business — Earn Certificates That Get You Hired

Learn More → Corporate Finance Institute Ad

Build the Finance Skills That Lead to Promotions, Not Just Certificates

Learn More →

Overview

Google, IBM & Meta Certificates – 40% Off
One Coursera Plus subscription covers most Professional Certificates on Coursera.
Unlock All Certificates
This beginner tutorial teaches how to create formulas and use common Microsoft Excel functions for calculations, dates and times, combining columns, conditional logic, and lookups.

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.

Taught by

Teacher's Tech

Reviews

Start your review of How to Use Formulas and Functions in Microsoft Excel

Start learning

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.