Published On Premiered Jan 17, 2024
Welcome to this Excel tutorial that delves deep into formulas and functions to boost your spreadsheet skills! 🚀 We've combined 20 essential Excel function tutorials in one training video.
âś…Basic Math and Counting Functions:
Begin your journey with the fundamental SUM, MIN, MAX, AVERAGE, COUNT, COUNTA, and COUNTBLANK functions, setting the stage for proficient data handling.
âś…Logical Functions Unveiled:
Demystify logical functions such as AND, OR, and IF, and witness how they can make your data analysis more responsive to specific conditions.
âś…Mastering Lookup Techniques:
Unlock the full potential of VLOOKUP, INDEX, MATCH, XLOOKUP, XMATCH, SUMIFS, and COUNTIFS, giving you versatile tools to find, retrieve, and summarize data seamlessly.
âś…Text Manipulation and Error Handling:
Explore the world of text manipulation with CONCAT, handle errors like a pro with IFERROR and IFNA, and enhance your formula efficiency with the LET function.
âś…Date, Time, and Randomization:
Navigate through Date and Time Functions, ensuring you can handle temporal data effortlessly. Plus, discover the magic of creating randomized lists using the RAND Function.
This tutorial is not just a theoretical walkthrough; each concept is accompanied by practical examples, ensuring you gain a hands-on understanding of these essential Excel functions.
đź“ť 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 - Intro
00:00:19 - SUM Function
00:07:49 - MIN and MAX Functions
00:10:13 - AVERAGE Function
00:14:36 - COUNT, COUNTA, and COUNTBLANK
00:22:02 - Logical Functions (AND, OR, IF)
00:35:15 - MATCH Function
00:38:00 - CONCAT Function
00:45:29 - VLOOKUP
00:55:37 - SUMIFS and COUNTIFS
01:07:21 - INDEX AND MATCH Functions
01:17:49 - XLOOKUP and XMATCH Functions
01:28:00 - Count Cells with Text COUNTIF
01:30:25 - IF, Nested IF, IFS
01:35:55 - Example of IF Function
01:43:04 - Nested IF
01:49:45 - IFS Function
01:58:30 - IFERROR AND IFNA
02:04:31 - LET Function
02:19:42 - Date and Time Functions
02:28:25 - Randomized List and RAND Function
🌍 Get unlimited training with Simon Sez IT’s 170+ courses ⏩ https://www.simonsezit.com/courses/
🚀 Level up your skills with a free 30-day trial to our complete training library of 9,200+ videos ⏩ https://www.simonsezit.com/ssit-first...
đź’» Watch more free popular training tutorials from Simon Sez IT:
🔥Check out our FREE 300+ hour training course playlist here ➡️
   • Simon Sez IT Long Training Courses Â
âś… Check out our free video playlist for Data Analysis using Microsoft Tools 👉    • Data Analysis using Microsoft Tools Â
âś…Microsoft Access Training video playlist 👉    • How to Use Microsoft Access Training ... Â
âś… Microsoft Excel Beginner's Training here 👉    • Microsoft Excel Beginner's Training T... Â
âś… Introduction to Databases Training here 👉    • Introduction to Databases Training Tu... Â
đź’¬Stay in touch!
SimonSezIT.com: https://www.SimonSezIT.com/
LinkedIn:   / simon-sez-it Â
FaceBook:   / simonsezit Â
đź”” Subscribe to our channel:
https://www.youtube.com/simonsezittra...
If you enjoyed the video, please give a thumbs up 👍🏽 ;-)
🔥🔗💡 #ExcelTutorials #productivityhacks