Formula & Functions Deep Dive

$750.00

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.

Category: Uncategorized

Description

Description

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

Note:

If the number of participants does not reach 10, the money will be returned to you, as we cannot start with fewer participants.

Close