Excel Advanced Formulas
Welcome to Excel VIII Advanced Formulas class!
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.
We don't currently have this class on the schedule, but we can add it for you! Please choose an available day and time or call us at (909) 981-6331 for more information.
Need a Different Date?
Do the current classes not work for your schedule, or are no classes currently available? No problem! Visit our Schedule a Class page and choose an available day and time or call us at (909) 981-6331 for more information.
Building Large Functions
- Text And Formatting Functions
- 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
- How To Make Dependent Dropdown Lists In Excel (Data Validation)
- Prevent Duplicate Entries (Data Validation)
- Using A Formula For Data Validation
- Running Count Of Occurrence In List