Why Excel Pros LOVE the AGGREGATE function in Excel!
Computergaga
@computergagaAbout
Welcome to my channel where you can expect videos on Excel tips and formulas to help you in your day to day work. Videos on using the latest Excel features, formulas, advanced Excel tips, VBA and Power BI. If you have a question, please ask. I try to reply to as many comments as I can. My apologies if I do not respond. It is very difficult to respond to everybody. Who am I? My name is Alan, I'm a Microsoft MVP and I have been training people how to get the most from Excel for over 20 years. I am the author of two Excel books "Advanced Excel Success" and "Advanced Excel Formulas". I love working with data and helping people improve their Excel skills and save time. I live in a town called Ipswich in the UK and I'm a father to two wonderful kids.
Latest Posts
Video Description
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
You May Also Like
Craft Essentials You Can't Miss
AI-recommended products based on this video
4-in-1 Wooden Activity Desk & Chair Set – Birch Plywood Table with Reversible Whiteboard & Chalkboard, 3 Storage Areas for Learning, Art, and Organization
Windshield Repair kit, DIY Glass Cracked Repair Kits, Easy to Use Automotive Glass Nano Repair Fluid, Scratch Chip Cracks Repair Kit (2 Pack) (Black)
Windshield Repair kit, DIY Glass Cracked Repair Kits, Easy to Use Automotive Glass Nano Repair Fluid, Scratch Chip Cracks Repair Kit (2 Pack) (Black)
Windshield Repair kit, DIY Glass Cracked Repair Kits, Easy to Use Automotive Glass Nano Repair Fluid, Scratch Chip Cracks Repair Kit (2 Pack) (Black)
Windshield Crack Repair kit Windshield Repair kit, Glass Repair kit, DIY Glass Cracked Repair Kits, Easy to Use Automotive Glass Nano Repair Fluid, Scratch Chip Cracks Repair Kit 2 Pack (Drakgray)
DOWN HOME Cooling Comforter Queen Size, Cooling Blanket for Hot Sleepers All Season, Q-max>0.4 Double-Side Cold Fabric, Bamboo Breathable Lightweight Summer Duvet Soft Quilt, Blue Strips, 90"x90" OEKO-TEX STANDARD 100
DOWN HOME Cooling Comforter King Size, Cooling Blanket for Hot Sleepers All Season, Q-max>0.4 Double-Side Cold Fabric, Bamboo Breathable Lightweight Summer Duvet Soft Quilt, Blue Strips, 90"x108" OEKO-TEX STANDARD 100
LEGO Technic Bugatti Bolide Racing Car Building Set - Model and Race Engineering Toy for Back to School, Collectible Sports Car Construction Kit for Boys, Girls, and Teen Builders Ages 9+, 42151
LEGO Technic Mercedes-AMG F1 W14 E Performance Pull-Back Car Toy, Vehicle Building Set for Boys and Girls, Mercedes Race Car Toy Model, Gift for Kids Ages 7 and Up, 42165
LEGO Speed Champions 2023 McLaren Formula 1 Race Car Toy for Play and Display, Buildable McLaren Toy Set for Kids, F1 Toy Gift Idea for Boys and Girls Ages 9 and Up who Enjoy Independent Play, 76919
LEGO NINJAGO Kai's Ninja Race Car EVO, 2 in 1 Race Car Building Toy Set, Kids Can Build an Off Road Vehicle or Race Car, Ninja Minifigure with Toy Swords, Gift for Boys, Girls and Kids Ages 6+, 71780
unibouti 2 Pack Graduation Cap Headband - Grad Cap Head Band Insert with Hook and Loop Sticker - Graduates Essential Hairband for Securing Graduation Hat
