SUPER DYNAMIC TABLE

Course Objective

In this course, students will learn how to use Pivot Tables to create reports, analyses, and data summaries quickly and easily, even without using complex formulas. Throughout the lessons, techniques will be presented that facilitate the organization and analysis of large volumes of information.

By the end of the course, participants will be able to structure dynamic reports and transform data into clear and useful insights to support decision-making in their daily professional lives.

Program content

1. Initial Module
2. General Design
3. General Formatting
4. Values – Basic Calculations
5. Relative Calculations
6. Group
7. SLICERS
8. INFODATED
9. Count Uniques
10. Calculated Field
11. Filters and Sorting
12. Graphs
13. Combining Tables

Supporting material for download | Super Pivot Table

Methodology

Practical lessons, with step-by-step demonstrations and examples applied to real-life corporate situations, allowing the student to follow along and reproduce the exercises.

Instructor

Known as Edu do Excel, the instructor is a Microsoft-certified expert, entrepreneur, and professional with over 25 years of experience as an executive. Supply Chain in large multinational industries.

Throughout his career, he used Excel as a strategic tool for data analysis, report creation, and decision support, standing out for his ability to transform complex information into clear and objective analyses.

Currently, he dedicates himself to sharing this knowledge through his own teaching method, based on real-world challenges and situations, providing practical and applied learning relevant to everyday professional life.

Target Audience

Recommended for professionals who work with data in Excel and want to create more efficient and organized reports, such as analysts, administrative assistants, finance professionals, logistics professionals, HR professionals, and corporate areas in general.

General Recommendations

Basic knowledge of Excel is recommended, such as navigating spreadsheets and organizing data in tables.

About Instructors

Reviews