These are the ONLY 15 functions you need to know in Excel (to get most things done)

Learn the most important Excel functions and how to use them for business data analysis.

Formulas & Techniques covered in this video:
====================================
SUMIFS
COUNTIFS
AVERAGEIFS
XLOOKUP
MAXIFS
INDEX + MATCH
FILTER
MAX
LARGE
~
How and when to use each formula
Working with wildcards & patterns
Using date ranges in your criteria
Multiple criteria with formulas
How to combine formulas to solve a problem

Download the Sample Workbooks:
============================

⏱Topics in the video:👇
===================
0:00 - Introduction to the data & 15 Formulas
1:20 - Q1 Total Downloads of SugarRush App (SUMIFS)
3:17 - Q2 Total downloads for C apps (wildcards)
5:04 - Q3 Uninstalls in December 2021 (Using Dates)
7:00 - Q4 Downloads in Oct, Nov, Dec 2021 (Date Ranges)
9:21 - Q5 How many times we had more than 8000 downloads per app month? (COUNTIFS)
10:52 - Q6 5 star rating % for Sugar Rush (Complex Problem)
12:31 - Q7 Average uninstalls for Subway Wafers (AVERAGEIFS)
13:10 - Q8 Which month has highest uninstall ratio? (MAX & XLOOKUP)
16:23 - Q9 Average monthly downloads (AVERAGEIFS)
17:06 - Q10 Most downloads in any month / app? 2nd and 3rd places also? (MAX, LARGE)
18:18 - Q11 Which month and app was that? (XLOOKUP, INDEX+MATCH)
20:02 - Q12 In October 2021, which app has most 1star ratings? (XLOOKUP vs. FILTER)
23:35 - Q13 Does it change by December 2021? (XLOOKUP vs. FILTER)
24:50 - Q14 What are the best download figures for each app? (MAXIFS)
26:00 - What is the least downloaded app in each month? (FILTER)
28:03 - How to learn more?

👋 ALTERNATIVE FORMULAS FOR OLDER EXCEL VERSIONS:
==================================================

XLOOKUP alternative = Use INDEX MATCH.
Instead of =XLOOKUP(F61,F53:F59,C53:C59)
use = INDEX(C53:C59, MATCH(F61, F53:F59,0))

MAXIFS alternative = Use MAX(IF()) Array formula.
Instead of =MAXIFS(data[Downloads],data[App],C99)
Use =MAX(IF(data[App] = C99, data[Downloads])) and press CTRL+Shift+Enter to get the correct result.

NEXT STEPS FOR YOU 👌
====================
💥💥💥
💥💥💥

Additional videos on the formulas:
===========================

~

Don't forget to be AWESOME 😎

#Excel #DataAnalysis

[utubeAgape]

Really appreciate this video, using common analysis questions and then walking through how you would get the answers. This is teaching method is one of the best ways to learn - thank you!

[shujashakir]

The claim that knowing these 15 function in excel is enough to get most your analysis work done is true. In fact, It wouldn't be incorrect to say that this one video was enough for me to understand the entire logic on which Excel works. After watching it, I did not have to look any further. Thanks Chandoo bhaiyya for this. You may not be aware of the miracle you created here!

[shreyanshdangi]

I learn so quickly after watching your videos, especially this one. Your real work examples and explanations make all the difference. Love this video. Look forward to seeing more. Thanks

[hstppt]

I am so happy I found your channel. You're a great teacher. I no longer feel overwhelmed by the prospect of learning data analysis in Excel!

[RajeshAcharya-emqk]

This is one of the best Excel Video have ever seen, so much of details and explanation about each and every formula with example so that its easily understandable. Thanks Very much and hope to have more video in future.

[snowwhite]

Many thanks Chandoo. You're a brilliant teacher!

[largeroomnolight]

Thank you so much!!! 🥰 You’re the best. 🌟🌟🌟 I’ve been working on this spreadsheet all night then I found your video and now I was able to use these formulas to make everything work. You’re a blessing 🙏🏾

[legacygk]

Thank you so much! Your commitment and charisma are second to none.

[kennethgray]

You are the BEST, Chandoo! Thanks from Georgia, USA.

[yashmittal]

Just loved the video Chandoo. Would love it if you do more of these.

[chunksssstv]

Thank you Chandoo for providing us such resources for our learning. Really appreciate your efforts

[sarikadatta]

THANKS A LOT Chandoo you don't know how much you're helping the newbies as well as the experienced.
Many blessings your way

[thehve]

Once again wonderfully thought out examples, and excellently presented. Thank you

[jeanlambert]

great video, thanks @Chandoo for posting it showing some of the most useful functions that are available only in Excel 365 !

[BRUNOABG]

Even if you're very familiar with all the functions presented here, there's always the chance of getting a alternative way of doing things that you weren't familiar with. Good content.

[MonAlde]

I enjoyed following this exercise. Thank you man!

[Amr-Ibrahim-AI]

Thank you for the very useful tutorials. I'm an advanced Excel user but I learned some new techniques here.
Much appreciated Chandoo!

[sujitsengupta]

Excellent! Judicious selection of 15 most useful functions! Intelligent demonstration!

[nipunshetty]

Great Teacher and Inspiration for Many People Sir👌👌👌

[livestrong]

Number 14 is answered like number 15. Love the channel, thank you!!