Data Analysis with Excel 📈📉📊✅ - 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 📗👉 ============= Please download the example workbook from here - https://chandoo.org/wp/wp-content/uploads/2021/12/complex-excel-formulas-5-real-world-examples.xlsx Companion Article - https://chandoo.org/wp/how-to-write-complex-excel-formulas/ For more Advanced Formula questions & examples, see this page - https://chandoo.org/wp/formula-forensics-homepage/ 💥Watch next 📽👉 ================ 10 Advanced IF formulas - https://youtu.be/-yFpzIRifK4 10 Advanced SUMIF formulas - https://youtu.be/YEt-aYbDTrs 5 Advanced VLOOKUP Tricks - https://youtu.be/240fbiyFFKI Top 10 formulas for any situation - https://youtu.be/Q-XGJbHG8Vo 💻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 Visit https://chandoo.org/wp/excel-school-program/ today to sign up. ~ Have an AWESOME day my friend. 😀🌼🌞 #ExcelFormulas #LEGO