Excel Advanced Formulas

In this course, we will dive into the world of Excel's advanced formulas, equipping you with the skills to tackle complex calculations and perform advanced data analysis. We will explore techniques for building large functions, allowing you to combine multiple formulas and functions to solve intricate problems. Additionally, we will delve into Lookups and scenario functions, empowering you to search for and retrieve data from various sources, as well as perform what-if analyses to evaluate different scenarios. You will also discover the power of the INDIRECT function, which enables you to create dynamic references to cells and ranges, enhancing the flexibility and efficiency of your formulas. Furthermore, we will explore the Goal Seek feature, enabling you to set specific targets and have Excel determine the input values required to achieve those goals. By the end of this class, you will have a comprehensive understanding of these advanced formulas and techniques, empowering you to perform sophisticated calculations, conduct in-depth data analysis, and make informed decisions. Get ready to elevate your Excel skills and unlock a whole new level of mastery with advanced formulas.

Building Large Functions

• Text And Formatting Functions
  
• Textjoin
  
• Text Function
  
• Trim/Clean Functions
  
• Create Email Address With Name And Domain
  

Lookups And Scenario Functions

• Find/Exact Functions
  
• Len Function
  
• Match Function
  
• Index Function
  
• Two-Way Lookup With Index And Match
  

INDIRECT

• How To Make Dependent Dropdown Lists In Excel (Data Validation)
  
• Prevent Duplicate Entries (Data Validation)
  
• Using A Formula For Data Validation
  

Goal Seek

• Running Count Of Occurrence In List