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