Choose your language

Basic and Advanced Excel Course

Basic and Advanced Excel Course
flexible workload of 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. Ultimately, 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 the workload. Choose which chapter to start with. Add or remove chapters. Increase or decrease the course workload.
Workload: between 4 and 360 hours

What our students say

Your classes 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 Carlo
Giulio CarloDigital Marketing Student
I like how the lessons are straight to the point and how I can change chapters and skip content that I don't need.
Mariana Ferres
Mariana FerresPhotography Student
I like the content and the way of presentation and video transcription, which speeds up the process!
Luciana Alvarenga
Luciana AlvarengaNail Design Student
The platform is fast, simple to use. The diversity of content and complementary videos help a lot in learning.
André Felipe
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