Description
The Formulas & Functions Deep Dive course is designed for daily Excel users to deepen their knowledge on how to build advanced formulas and functions. This course will survey 90% of the built in Excel functions to deepen the tools available for data analysts and advanced Excel users to gain more insights from data and improve the efficiency of their formula creation.
This course is structured topically around the built in formula & functions with time spent on building effective formulas, harnessing the power of functions, building business formulas, and using functions to build business models.
Sessions Overview:
Building Effective Formulas (Sessions 1 – 2)
- Setting up basic formulas
- Advanced formula structures
- Troubleshooting & resolving errors
Harnessing the Power of Functions (Sessions 3 – 7)
- Setting up advanced functions
- Text functions deep dive
- Logical & informational functions deep dive
- Lookup functions deep dive
- Time & date functions deep dive
- Math functions deep dive
Building Business Formulas (Sessions 8 – 14)
- Structuring and setting up basic business formulas
- Descriptive statistical formulas
- Inferential statistical formulas
- Applying regression to track trends & make forecasts
- Building loan formulas, investment formulas, & discount formulas
Building Business Models (Sessions 15 – 18)
- Analyzing data with tables
- Analyzing data with PivotTables
- Built in business modeling tools
- Solving complex problems
Use discount code “BrionHurley” to save 10% OFF
