HDTutorial
EN
Excel Formulas and Functions Tutorial

Playback starts YouTube’s embedded player (privacy-enhanced mode).

Excel Formulas and Functions Tutorial

4,417,726 views October 25, 2019 12:29

Watch on YouTube
ChannelKevin Stratvert

In brief

This tutorial covers essential Excel formulas and functions to help you perform basic calculations and data analysis efficiently. You’ll learn how to add, subtract, multiply, divide, and use functions like SUM, AVERAGE, and IF to organize and interpret data—ideal for beginners looking to build confidence with Excel.

Key steps

  1. Apply functions like SUM, MIN, MAX, and COUNT to analyze data ranges.
  2. Filter and summarize data using COUNTIF, VLOOKUP, and SUMIF functions.
  3. Display the current time with the TIME function.

Chapters

Description from the creator

🔥 Go from Excel novice to data analysis ninja in just 2 hours with my Excel for Beginners course: kevinstratvert.thinkific.com

Learn how to use formulas in Excel, including the following functions & formulas:

⌚ Timestamps
0:00 Introduction
0:55 Add
1:55 Subtract
2:18 Multiply
2:50 Divide
3:20 Sum
4:46 Min
5:05 Max
5:30 Count
6:15 Counta
6:48 Average
7:20 Median
7:54 Concatenate
8:29 If
9:10 Countif
9:40 Vlookup
10:58 Sumif
11:46 Current Time

📃 Watch related playlists and videos
- Excel: youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqo…
- Pivot Tables: youtu.be/m0wI61ahfLc
- Vlookup & hlookup: youtu.be/8okA22yMwTs
- Mail Merge: youtu.be/_Efb_oMgxEs
- Learn the fundamentals of Excel in just 2 hours: kevinstratvert.thinkific.com

🎁 PARTNERS & DISCOUNTED OFFERS
💻 Hostinger | hostinger.kevinstratvert.com
📋 Notion | notion.kevinstratvert.com
💵 Quickbooks Online | qbo.kevinstratvert.com
🎙️ Voicemod AI Voice Changer | voicemod.kevinstratvert.com
🕵️ VidIQ | vidiq.kevinstratvert.com

Let me know if you have any questions. Also, let me know if there are other topics that you would like to see videos on.

🚩 Connect with me on social
- LinkedIn: linkedin.com/in/kevinstratvert/
- Discord: discord.gg/kHuujY2pZf
- Twitter: twitter.com/kevstrat
- Facebook: facebook.com/Kevin-Stratvert-101912218227818
- TikTok: tiktok.com/@kevinstratvert
- Instagram: instagram.com/kevinstratvert/

🙏 Request How To Tutorial Videos
forms.gle/BDrTNUoxheEoMLGt5

🔔 Subscribe to my YouTube channel
youtube.com/user/kevlers?sub_confirmation=1

🎬 Want to watch again? Navigate back to my YouTube channel quickly
kevinstratvert.com

🛍 Support me with your Amazon purchases: amzn.to/3kCP2yz

⚖ As full disclosure, I use affiliate links above. Purchasing through these links gives me a small commission to support videos on this channel -- the price to you is the same.

#stratvert #excel

About this tutorial

Kevin Stratvert published this 12:29 video tutorial on October 25, 2019. It has been watched 4,417,726 times on YouTube.

Duration
12:29
Published
October 25, 2019
Views
4,417,726
Likes
75,446

Share

Further reading

  • Basic Excel Formulas - List of Important Formulas for Beginners corporatefinanceinstitute.com

    Free Excel Tutorial. To master the art of Excel, check out CFI’s FREE Excel Crash Course, which teaches you how to become an Excel power user.Learn the most important formulas, functions, and shortcuts to become confide…

  • Formulas and Functions in Excel - Easy Excel Tutorial excel-easy.com

    Functions are predefined formulas and are already available in Excel. For example, cell A3 below contains a formula which adds the value of cell A2 to the value of cell A1. For example, cell A3 below contains the SUM fu…

  • Excel Formulas & Functions: Learn with Basic EXAMPLES guru99.com

    Excel allows you to manipulate the data using formulas and/or functions. Functions are generally more productive compared to writing formulas. Functions are also more accurate compared to formulas because the margin of…

This tutorial in other languages