MyOnlineTrainingHub's video: This 1 Excel function can do 90 of your calculations

⬇️ Download free Excel example file: https://bit.ly/fn-agg1 The AGGREGATE function is the Swiss Army Knife of functions; it’s so versatile it can replace these 19 Excel functions in one fell swoop: AVERAGE, COUNT, COUNTA, MAX, MIN, PRODUCT, STDEV.S, STDEV.P, SUM, VAR.S, VAR.P, MEDIAN, MODE.SNGL, LARGE, SMALL, PERCENTILE.INC, QUARTILE.INC, PERCENTILE.EXC, QUARTILE.EXC But that’s not reason enough to use it, the function-killer reason to use AGGREGATE over any of the 19 standard functions it can replace is because it is far more powerful. Let me show you. LEARN MORE =========== 🏫 LEARN MORE in my Excel courses: https://www.myonlinetraininghub.com/ 📰 EXCEL NEWSLETTER - join 320K+ subscribers here: https://www.myonlinetraininghub.com/excel-newsletter-sign-up 🔔 SUBSCRIBE if you’d like more tips and tutorials like this. 📢 Please leave me a COMMENT. I read them all! 🎯 FOLLOW me on LinkedIn: https://www.linkedin.com/in/myndatreacy/ 🎁 SHARE this video and spread the Excel love. Or if you’re short of time, please click the 👍 💬 EXCEL QUESTIONS: Get help on our Excel Forum: https://www.myonlinetraininghub.com/excel-forum ⏲ TIMESTAMPS ============== 0:00 The Swiss Army Knife of functions 0:19 The problem with other functions 1:00 Array or Reference Form 1:54 Handling arrays 2:59 Exploiting errors 4:38 Caution 5:03 Limitations