Basic and Advanced Excel Course
Master Excel from the ground up — from basic data entry to advanced automation, PivotTables, and Power Query. This course gives you the practical skills employers actually look for, covering every major tool in the Excel ecosystem. Whether you are managing reports, analysing data, or building dashboards, you will finish ready to work faster and smarter.

flexible workload from 4 to 360h
valid certificate in your country
What will I learn?
You will start with Excel fundamentals — navigation, formatting, and core formulas — then advance through lookup functions, PivotTables, and dynamic array formulas. You will learn to clean and transform data with Power Query, build interactive dashboards, and automate repetitive tasks using macros and basic VBA. Statistical tools, financial functions, and Solver round out the analytical side of the curriculum. By the end, you will have a complete, professional-level Excel skill set that applies directly to real workplace tasks.
Elevify advantages
Develop skills
- PivotTable Analysis: Summarise large datasets and answer business questions without writing formulas.
- Lookup Functions: Retrieve and cross-reference data accurately using VLOOKUP, INDEX-MATCH, and XLOOKUP.
- Dashboard Design: Build interactive, visually consistent reports with slicers, charts, and form controls.
- Macro Automation: Record and run macros to eliminate repetitive tasks and reduce manual errors.
Suggested summary
Before starting, you can change the chapters and workload. Choose which chapter to start with. Add or remove chapters. Increase or decrease the course workload.What our students say
Your lessons are perfect. I purchased the one-year package and finally have the opportunity to follow various topics of my interest without needing to change platforms... I thank you for everything you do, I've already recommended you to other people...

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

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

Luciana AlvarengaNail Design Student
The platform is fast, simple to use. The diversity of content and complementary videos help a lot with learning.

André FelipePrompt 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