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-whqYWTt644fIJdfvP0w?e=NUTb8I
⌚ 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: https://www.youtube.com/playlist?list=PLlKpQrBME6xLYoubjOqowzcCCd0ivQVLY
???? 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: https://www.linkedin.com/in/kevinstratvert/
– Discord: https://bit.ly/KevinStratvertDiscord
– Twitter: https://twitter.com/kevstrat
– Facebook: https://www.facebook.com/Kevin-Stratvert-101912218227818
– TikTok: https://www.tiktok.com/@kevinstratvert
– Instagram: https://www.instagram.com/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?sub_confirmation=1
???? 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
