How to 'BUILD' Excel Formulas - 5 Advanced Examples

Want to become an Excel PRO? Then you must build your formula skills. In this in-depth video, I share how I solve 5 real world problems with advanced Excel formulas. Watch my build and learn. EVERYTHING WILL BE AWESOME!!!

The formulas are,
1) Best Student name by GPA
2) Best sales person in a location
3) Extracting last name from text
4) Multiple IF Condition
5) Manager's manager mystery

Video timestamps⏱👉
===================
0:00 - Introduction to complex formulas
1:28 - (1) Best GPA student name formula
2:37 - Second highest GPA student
3:27 - Top 5 students with GPA - LARGE formula approach
4:07 - Top 5 students with INDEX & SEQUENCE trick
5:48 - (2) Best salesperson by territory
8:14 - Calculating the amount & proportion for best salesperson
9:31 - (3) Extracting last name
9:54 - Last name without formula
10:52 - Last name with formula
14:32 - (4) Employee salary bonus with complex IF conditions
18:48 - (5) Manager's manager mystery formula
20:38 - Fixing errors with the formula

Sample file 📗👉
=============

💥Watch next 📽👉
================

💻Want to LEARN Excel in one go? GET MY COURSE
===========================================
If you want to learn Excel from basics to advanced uses, understand how to process data, create amazing graphs and reports, then please go for my Excel School program. This course is trusted by more than 10,000 people to date. In this concise & in-depth course, you will learn:
✅Power Query
✅Excel tables & references
✅Important formulas for data analysis
✅Pivot tables, pivot charts & slicers
✅Excel charts
✅Advanced charts
✅Interactive charts
✅Data validation, shortcuts & productivity
➕(OPTIONAL) Excel dashboards

~
Have an AWESOME day my friend. 😀🌼🌞

#ExcelFormulas #LEGO

[canirmalchoudhary]

Great challenges. I enjoyed it. I think sometimes it is better to use PQ flash fill rather than Excel flash fill because PQ flash fill is M-coded and it can be re-used after "Refresh" query. So even if input changes, this less-code automation will always work.

[sbabu]

Thanks chandoo... You make our lives so easy with every Video you share... We are blessed to have you as support... Hats off to you... 🙏

[sanjaysrivastava]

Have been following for many years and he stays fresh & AWESOME even now .

[studymate]

Every single time I watch your video, I am like "Wow This is so cool!"

[bobwhelan]

Phenomenal video. Each example has made me think about how to approach other complex queries also. Thank you

[gurleenkaur]

Thanks for the AMAZING video. Today I was having difficulty in writing nested formula of ifs and AND functions but your video cleared all my doubts .

[shreyanshdangi]

Very inforamtive video but difficult in sequence like you tokd to view power video first in one of the question

[shriram]

This video is ocean of knowledge.
Thank you Chandoo!

[arunvenkatesh]

Best student name and top 5 list was my need and luckily I got it today. Thanks for the video

[abhilashn]

wondeful examples... as usual you are rockstar(Piano star)...

[sowmivis]

Watching your videos regularly. Your style of illustrations are pretty good. Thanks for the tips & tricks.

[jctevmv]

excellent stuff ... just that the no. of spaces shown after the substitution needs that extra 1 to fetch the correct no. of spaces ... do inform if i got that wrong

[Fxingenieria]

Espectacular!!! Thank you, just what I am looking for !!

[chrism]

Thanks Chandoo, this was a great video!

[kannanmassey]

Gm . Very well explained and easy to see formulas working. Thanks alot. Excel from the begining is there any playlist like that pls guide as your style for explaining things is addictive.

[surajbhardwaj]

Brilliant sir....😀. Your teaching style is so good...

[krish]

Really useful for using complex formulas.

[ExcellenceInExcel]

Hi chandoo, what about this formula for extracting right most value =TRIM(RIGHT(SUBSTITUTE(A2, " ", REPT(" ", 255)), 255))

[hardiksanghvi]

Hi Chandoo I tried to do exercise ADV1 in my Excel but I do not have the sort and sequence functions in Excel so what are the other options could you please tell me even though I do not have xlookup.

[ctfnmvm]

Why Ariel D shows twice in =xlookup(Large {array}) formula