Скачать или смотреть Excel Formulas and Functions - Tutorial for Beginners (2025)

If Excel formulas and functions have ever confused you, you're not alone. In this step-by-step tutorial, you'll learn exactly how to use formulas and functions in Excel—even if you're just getting started.

We’ll cover:
• The difference between formulas and functions
• How to perform calculations like sum, average, max, and more
• The powerful IF function for logic
• How to fix common mistakes with absolute vs relative references

👍 If this helps you save time and boost your spreadsheet skills, consider liking and subscribing!
💬 Got a function you'd like me to cover next? Drop it in the comments.


Host: Kevin Stratvert

📚 RESOURCES
Download the sample Excel workbook to follow along: https://1drv.ms/x/s!AmxrofZZlZ-whqYWT...

⌚ TIMESTAMPS
00:00 - Intro to Excel formulas & functions
00:23 - Understanding formulas in Excel
01:23 - Referencing cells vs hardcoding numbers
02:09 - Subtract, multiply & divide with formulas
03:33 - When to use functions instead of formulas
04:04 - How to use the SUM function
05:14 - Key difference: formula vs function
05:31 - Using the AVERAGE function
06:12 - Using the MAX function
06:39 - Using the MIN function
06:49 - Using the COUNT function
07:05 - Using the IF function with logic
08:42 - Bonus: IF function walkthrough with function helper
09:16 - Explore Excel’s function library
09:44 - Absolute vs relative cell references
11:30 - Wrap-up and next steps

📺 RELATED VIDEOS
Playlist with all my videos on Excel:    • ❎ How to use Excel  

📩 NEWSLETTER
Get the latest high-quality tutorial and tips and tricks videos emailed to your inbox each week: https://kevinstratvert.com/newsletter/

🔽 CONNECT WITH ME
Official website: http://www.kevinstratvert.com
LinkedIn:   / kevinstratvert  
Discord: https://bit.ly/KevinStratvertDiscord
Twitter:   / kevstrat  
Facebook:   / kevin-stratvert-101912218227818  
TikTok:   / kevinstratvert  
Instagram:   / kevinstratvert  

🎁 TOOLS AND DISCOUNTS
✅ 🎙️ Voicemod AI Voice Changer | 5% off | https://link.xsolla.com/KZBi89AY
✅ 🌐 Squarespace Websites | https://squarespace.syuh.net/XYaqYM
✅ 🛍️ Shopify | https://shopify.pxf.io/XY9rPa
✅ 📋 Notion | https://affiliate.notion.so/rffva4tr71ax
✅ 🤖 ElevenLabs Text-to-Speech | https://try.elevenlabs.io/taqepq60mptr
✅ 💵 Quickbooks Online | https://bit.ly/intuitquickbooksonline
✅ 👥 Hubspot | https://hubspot.sjv.io/DKo6jb
✅ 📈 Semrush | https://bit.ly/semrush14dayfreetrial
✅ 🎥 Descript | https://get.descript.com/sf22jb63w2tx

🎒 MY COURSES
Go from Excel novice to data analysis ninja in just 2 hours: https://kevinstratvert.thinkific.com/

🙏 REQUEST VIDEOS
https://forms.gle/BDrTNUoxheEoMLGt5

🔔 SUBSCRIBE ON YOUTUBE
https://www.youtube.com/user/kevlers?...

🙌 SUPPORT THE CHANNEL
Hit the THANKS button in any video!
Amazon affiliate link: https://amzn.to/3kCP2yz

⚖ DISCLOSURE
Some links are affiliate links. Purchasing through these links gives me a small commission to support videos on this channel. The price to you is the same.

#stratvert #excel