Uploaded September 2025 | Updated September 2026, 1 week ago
✅Download the free course files and follow along here:
➡️ simonsezit.com/excel-formulas-beginner-level-demo-file
In this tutorial, learn the must-know Excel formulas every beginner should master for accurate and efficient spreadsheet work. Explore foundational functions like SUM, AVERAGE, COUNT, MIN, and MAX, understand the difference between relative and absolute references, and get hands-on with text functions like CONCATENATE and TRIM. You'll also learn how to use IF and Calculated IFs, plus an introduction to VLOOKUP for basic data retrieval.
📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
00:00:00 - Course Introduction
00:01:52 - SUM, AVERAGE, COUNT, MIN, and MAX Functions
00:12:49 - Relative vs. Absolute References
00:15:44 - CONCATENATE and TRIM Functions
00:27:10 - IF Function
00:32:55 - Calculated IFs Function
00:40:43 - VLOOKUP Function
🌍 Get unlimited training with Simon Sez IT’s 200+ courses ⏩ simonsezit.com/courses
🚀 Supercharge your skills with a FREE 14-day trial to our extensive training library. Learn from 10,000+ ad-free videos and begin your transformation today! ➡️ simonsezit.lpages.co/ssit-14-day-free
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 400+ hour training course playlist here ➡️
youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
🔥 For a full training experience, check out our FREE YouTube course: 👉 youtube.com/@SimonSezIT/courses
✅ Microsoft Excel Tips and Tricks 👉youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
✅ Microsoft Office 2021 and Office 365 Training here 👉youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j
💬Stay in touch!
SimonSezIT.com: SimonSezIT.com
LinkedIn: linkedin.com/company/simon-sez-it
FaceBook: facebook.com/SimonSezIT
🔔 Subscribe to our channel:
youtube.com/simonsezittraining?sub_confirmation=1
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
✅Download the free course files and follow along here:
➡️ simonsezit.com/excel-formulas-beginner-level-demo-file
In this tutorial, learn the must-know Excel formulas every beginner should master for accurate and efficient spreadsheet work. Explore foundational functions like SUM, AVERAGE, COUNT, MIN, and MAX, understand the difference between relative and absolute references, and get hands-on with text functions like CONCATENATE and TRIM. You'll also learn how to use IF and Calculated IFs, plus an introduction to VLOOKUP for basic data retrieval.
📝 Use the timestamps below to navigate to different sections of the course. If you already know one of these topics, skip ahead!
00:00:00 - Course Introduction
00:01:52 - SUM, AVERAGE, COUNT, MIN, and MAX Functions
00:12:49 - Relative vs. Absolute References
00:15:44 - CONCATENATE and TRIM Functions
00:27:10 - IF Function
00:32:55 - Calculated IFs Function
00:40:43 - VLOOKUP Function
🌍 Get unlimited training with Simon Sez IT’s 200+ courses ⏩ simonsezit.com/courses
🚀 Supercharge your skills with a FREE 14-day trial to our extensive training library. Learn from 10,000+ ad-free videos and begin your transformation today! ➡️ simonsezit.lpages.co/ssit-14-day-free
💻 Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 400+ hour training course playlist here ➡️
youtube.com/playlist?list=PLzj7TwUeMQ3hsADWJd2sJh4o8jATTyaRU
🔥 For a full training experience, check out our FREE YouTube course: 👉 youtube.com/@SimonSezIT/courses
✅ Microsoft Excel Tips and Tricks 👉youtube.com/playlist?list=PLzj7TwUeMQ3gv7nwM6ad7r5ma_3UoOPtc
✅ Microsoft Office 2021 and Office 365 Training here 👉youtube.com/playlist?list=PLzj7TwUeMQ3hH_MxteY6LR3OSMHpDkt_j
💬Stay in touch!
SimonSezIT.com: SimonSezIT.com
LinkedIn: linkedin.com/company/simon-sez-it
FaceBook: facebook.com/SimonSezIT
🔔 Subscribe to our channel:
youtube.com/simonsezittraining?sub_confirmation=1
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
