Excel Dashboads e KPIs - Aprenda rápido e com eficiência
Master Excel presentations! Learn dynamic charts & pointer graphs for impactful data visualization. Boost your data storytelling skills.
Course Content
Excel Dashboads e KPIs - Aprenda rápido e com eficiência is an intermediate-level Udemy course taught by Fabio Passarella. It runs 6h 59m, is taught in Portuguese, and includes a certificate of completion. Learners rate it 4.9 out of 5 from 17 reviews, with 118 students enrolled. It is a paid course, last updated September 2025.
Excel Dashboards & KPIs: Master Dynamic Reporting with PowerPivot (Office 365)
Unlock the power of data visualization with this comprehensive Excel course focused on creating dynamic dashboards and impactful KPIs using PowerPivot within Microsoft Excel Office 365. This course is designed for intermediate Excel users looking to elevate their data analysis and presentation skills.
What You'll Learn:
- Create Interactive Dashboards: Transform raw data into visually engaging and interactive dashboards that update automatically.
- Master PowerPivot: Learn to efficiently analyze and summarize large datasets using PowerPivot for deeper insights.
- Develop Key Performance Indicators (KPIs): Define, track, and visualize crucial KPIs to monitor business performance.
- Dynamic Charts & Graphs: Create professional, data-driven charts (including donut charts, column charts, pie charts, and scatter plots) that dynamically respond to data changes.
- Essential Excel Functions: Gain proficiency in powerful functions like INDEX, MATCH, AGGREGATE, TEXT, PRI.MAIUSCUL, and more to manipulate and analyze data effectively.
- Data Interaction & Visualization: Learn to interact with data, lists, and graphs to create compelling presentations.
- Advanced Techniques: Explore overlay graphics, control boxes, control tools, links, and buttons to enhance dashboard functionality.
- Practical Projects: Apply your skills through two ready-made projects: a reservoir level indicator and a school grade indicator.
- Data Presentation & Storytelling: Present complex data in a clear, concise, and visually appealing manner to drive informed decision-making.
- Tables and Lists: Learn how to use tables and lists to organize and manage data effectively.
- Basic & Dynamic Charts: Reinforce your understanding of fundamental and dynamic chart creation.
Course Features:
- Step-by-Step Video Lessons: Learn at your own pace with clear, concise video tutorials (5-10 minutes each).
- Downloadable Files: Access all necessary files and resources for hands-on practice.
- Expert Guidance: Benefit from structured lessons and practical exercises.
- Office 365 Focused: This course is specifically designed for the latest version of Microsoft Excel Office 365. A free introductory lesson for the standard Excel version is also available.
- Reinforcement Section: Address any knowledge gaps with a dedicated section covering PROCV, TABLES, basic charts, and dynamic charts.
Who is this course for?
This course is ideal for professionals who already have an intermediate level of Excel knowledge and want to:
- Improve their data analysis skills.
- Create professional-looking dashboards.
- Track and monitor key performance indicators.
- Present data effectively to stakeholders.
- Gain a competitive edge with data-driven insights.
Need a web app built? Hire the team behind TutorialSearch.io
We ship fast, production-grade full-stack apps (Next.js, React, edge infra) — the same stack that powers this site.