FREE Microsoft Excel Course - Top 10 Excel Functions you should learn in 2024

Excel has 400+ FUNCTIONS, and most of these are a WASTE of time. If you want to get good with Excel in a short time, focus on these 10 instead. Once you know how to use and combine them, you can learn more. So, what are the 10? SUMIFS XLOOKUP FILTER COUNTIFS INDEX EDATE UNIQUE TEXTJOIN SORT IFERROR Let's dive in. ⏱ VIDEO TOPICS: =============== 0:00 - Most Excel functions are useless 0:42 - Number 1 function - SUMIFS 1:52 - XLOOKUP function 2:40 - How to get multiple values with lookup? (FILTER function) 3:43 - COUNTIFS Function 5:49 - INDEX Function 6:40 - The most important function 6:57 - EDATE Function 7:50 - TEXTJOIN Function 8:25 - Using TEXTJOIN in a FUN way 9:07 - UNIQUE Function 9:57 - SORT Function 11:05 - IFERROR Function 11:52 - What if you don't like FUNCTIONS? 📁 SAMPLE FILE ============== Refer to this page for more on this topic + free example workbook to practice - https://chandoo.org/wp/top-10-excel-functions/ 💡 LEARN MORE ============== ▶ Pivot Tables for Data Analysis with 8 quick examples - https://youtu.be/aofsdpjvK7w ▶ Power Query & Data Cleansing for Beginners (10 examples) - https://youtu.be/q7EpoOwBcnM ▶ Power Pivot for Beginners (20+ examples) - https://youtu.be/PQ5lALdFHCU ▶ Only 15 Functions you need - https://youtu.be/B5hayFelHDU 🧰 Specific Functions: ▶ XLOOKUP - https://youtu.be/DDlZXXEI1bU ▶ FILTER - https://youtu.be/JuTdj2j-9Kg ▶ SUMIFS - https://youtu.be/YEt-aYbDTrs ▶ INDEX - https://youtu.be/kly0uPIM4IU ▶ DATE formulas - https://youtu.be/NIvTVKZqmM0 ▶ Dynamic Array functions - https://youtu.be/ONaS7IMKJPM 👩‍💻 Courses: If you want to learn more than these 10, consider my Excel School program. This comprehensive course can help you navigate Excel data analysis situations with ease and grace. You will learn how to use and combine various Excel functions to solve work problems quickly. You will also learn how to apply pivot tables, charts, power query and dashboards to elevate your performance. Check out Excel School and join here - https://chandoo.org/wp/excel-school-program/ ~ What does A1 say to SUM()? You add value to me 😍 #excel