Advanced Excel and Word Course
Master advanced Excel techniques for KPI analysis and reporting, combined with Word automation for professional document creation.

from 4 to 360h flexible workload
valid certificate in your country
What will I learn?
This Advanced Excel and Word Course teaches you to build reliable KPI formulas, structured data models, and clear summary reports that are easy to update every month. Learn advanced functions, dynamic tables, conditional formatting, automation techniques, and practical mail merge workflows so you can create accurate, reusable templates, document every step, and hand over polished files that teammates can trust and maintain.
Elevify advantages
Develop skills
- Advanced KPI formulas: build SUMIFS, XLOOKUP, and logic for BI performance.
- Structured Excel models: design table-based KPI datasets ready for analysis.
- Dynamic dashboards: apply charts, filters, and conditional formats for clear KPIs.
- Excel automation: use tables, spill ranges, and macros to reuse monthly reports.
- Word mail merge for BI: generate polished KPI memos from Excel data fast.
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
As suas aulas são perfeitas. Adquiri o pacote de um ano e, finalmente, tenho a oportunidade de acompanhar diversos temas do meu interesse sem precisar mudar de plataforma... agradeço por tudo o que fazem, já recomendei vocês a outras pessoas...

Giulio CarloAluno de Marketing Digital
Eu gosto de como as lições são direto ao ponto e como eu consigo alterar capítulos e pular conteúdos que não preciso.

Mariana FerresAluna de Fotografia
Gosto do conteúdo e do modo de apresentação e transcrição de vídeos, o que acelera o processo!

Luciana AlvarengaAluna de Design de Unhas
A plataforma é rápida, simples de usar. A diversidade de conteúdo e os vídeos complementares ajudam muito no aprendizado.

Giulio CarloAluno de Engenharia de Prompt
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