Why Excel Pros LOVE the AGGREGATE function in Excel!

Why do the Excel Pros use the AGGREGATE function in Excel? See four examples of the Excel AGGREGATE function and find out why the Excel pro ranks it as a top function. Download the practise file to follow along - https://computergaga.com/_excel/files/formulas/aggregate.xlsx ⌚ Timestamps 00:00 Why use the AGGREGATE function in Excel 00:40 Ignore subtotals in a range 04:16 Use AGGREGATE with slicers 07:11 Dynamic function selection 09:58 Unlock other formulas to use Slicers 📺 Related Videos Using symbols in your Excel slicers: https://youtu.be/cJN2aGzH0lI FILTER - Is this the best Excel function: https://youtu.be/kdl3mNEyIRE SUMIFS formula in Excel - Five examples: https://youtu.be/ZCgap9FaOoM *** Online Excel Courses *** The Ultimate Excel Course – Learn Everything ► https://bit.ly/UltimateExcel Excel VBA for Beginners ► http://bit.ly/37XSKfZ Advanced Excel Tricks ► https://bit.ly/3CGCm3M Excel Formulas Made Easy ► http://bit.ly/2ujtOAN Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2Siivkm Connect with us! LinkedIn ► https://www.linkedin.com/in/alanmurray-computergaga/ Instagram ► https://www.instagram.com/computergaga1/ Twitter ► http://www.twitter.com/computergaga1 TikTok ► https://www.tiktok.com/@computergaga #excel #excelformulas #excelpro