⬇️ Download free Excel example file: 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: myonlinetraininghub.com/
📰 EXCEL NEWSLETTER - join 320K+ subscribers here: 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: 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: 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
#excelfunctions #excelformula #exceltutorial
- This 1 Excel function can do 90% of your calculations! ( Download)
- 10 Excel Formulas That Will Set You Apart (+Cheat Sheet) ( Download)
- How To Calculate The Average In Excel ( Download)
- Ratio Calculations in Excel ( Download)
- How to Convert Minutes to Hours in Excel ( Download)
- How to use Vlookup for Giving range to numbers | Easy Excel Tricks ( Download)
- Excel Formula: Create IF greater than or less than Function formula in Excel (Easy) ( Download)
- How to use the IF function in Excel ( Download)
- Turkey Talk and Beef With Beef ( Download)
- MS Excel - Student Mark Sheet Calculation Sum, Average, Rank, Grade, Pass Fail, Status ( Download)
- Determining the Date 60 and 90 days away in Excel ( Download)
- How to add 10 percent in excel//increase 10 percent in excel//Excel tutorial// learn It 9M ( Download)
- Excel If Greater Than and If Less Than Formula ( Download)
- Rank Your Excel Data with the RANK Function ( Download)
- IF Function with 4 Criteria in Excel | IF Formula with many Conditions ( Download)
