Excel Advanced Functions Course
Gain mastery over advanced Excel functions to develop dynamic dashboards, automate essential SaaS metrics such as churn and MRR, and produce reliable, error-free reports. Ideal for technology professionals seeking quicker data analysis, neater models, and informed product choices based on solid data insights.

from 4 to 360h flexible workload
valid certificate in your country
What will I learn?
This course teaches advanced Excel techniques to clean data, model effectively, create strong tables, and prevent formula errors. Learners will gain expertise in SUMIFS, COUNTIFS, SUMPRODUCT, XLOOKUP, INDEX/MATCH, LET functions, and dynamic arrays for precise reports and dashboards. It covers automating key metrics like monthly MRR, churn rates, and usage with strong validation to ensure spreadsheets remain efficient, reusable, and reliable for decision-making.
Elevify advantages
Develop skills
- Advanced aggregation formulas: develop rapid SUMIFS, COUNTIFS, and SUMPRODUCT reports.
- Dynamic lookups and indexing: excel in XLOOKUP, INDEX/MATCH, and table references.
- Dashboard automation: produce filter-based KPIs, charts, and reusable monthly displays.
- SaaS metrics in Excel: execute full churn, MRR, and active user computations.
- Date logic for analytics: construct rolling months, period keys, and sturdy time filters.
Suggested summary
Before starting, you can change the chapters and the workload. Choose which chapter to start with. Add or remove chapters. Increase or decrease the course workload.What our students say
Your classes are perfect. I purchased the one-year package and finally have the chance to follow several topics I'm interested in without having to switch platforms... I appreciate everything you do, I've already recommended you to others...

Giulio CarloDigital Marketing Student
I like how the lessons are straight to the point and how I can switch chapters and skip content I don't need.

Mariana FerresPhotography Student
I like the content and the way the videos are presented and transcribed, which speeds up the process!

Luciana AlvarengaNail Design Student
The platform is fast and easy to use. The variety of content and the extra videos really help with learning.

Giulio CarloPrompt Engineering Student
FAQ
Who is Elevify? How does it work?
Do the courses have certificates?
Are the courses free?
What is the course workload?
What are the courses like?
How do the courses work?
What is the duration of the courses?
What is the cost or price of the courses?
What is an EAD or online course and how does it work?
PDF Course