0   reviews on Udemy

Excel Magic - Building Dynamic Formulas

Building Dynamic Formulas
Course from Udemy
 9 students enrolled
 en
Intermediate to Advanced Excel skills that will help you
- to ace your Excel skills,
- to find state-of-the art Excel functions,
- to make yourself the go-to-person in their office, or
- to be well positioned for your next promotion!

The course is presented in four parts.


First, the course relates earlier course of Top 5 Excel Skills to drive the concept home: Dynamic formulas are your “first” step toward full automation in Excel Modeling!


Next, the course brings the topic of what is a dynamic formula and let students consider if VLOOKUP() is a dynamic formula? It is only a semi-dynamic formula.


Third, we illustrate the top 10 dynamic formulas, including:

o Dynamic range formula

o Table formula

o Conditional formula,

o SUMPRODUCT()

o INDIRECT/ADDRESS

o Array formula


Last, the course explores latest features from Excel 365 that are considered by many to be amazing. They include:

o SORT()

o XLOOKUP()

Excel Magic - Building Dynamic Formulas
$ 94.99
per course
Also check at

FAQs About "Excel Magic - Building Dynamic Formulas"

About

Elektev is on a mission to organize educational content on the Internet and make it easily accessible. Elektev provides users with online course details, reviews and prices on courses aggregated from multiple online education providers.
DISCLOSURE: This page may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

SOCIAL NETWORK