Data Analysis and Visualization with Microsoft Excel
Duration: 2 days
This two-day course focuses on turning raw data into clear, actionable insight. You’ll clean and shape data, build powerful PivotTables and dashboards, use modern data tools like Power Query and Power Pivot, and design visualizations that tell a story decision-makers can act on.
Learning Objectives
- Import, clean, and shape data with Power Query
- Build data models with Power Pivot
- Create advanced PivotTables and PivotCharts
- Design interactive dashboards with slicers and timelines
- Apply visualization best practices
Who Should Attend
- Analysts, managers, and professionals who report on data
- Excel users who build dashboards or summaries
- Anyone who needs to communicate data clearly
Prerequisites
- Solid working knowledge of Excel formulas and tables
- Excel – Part 2 (and ideally Part 3) or equivalent experience
What’s Included
- Authorized courseware and student materials
- Hands-on labs and real-world practice exercises
- Live instruction from an experienced, certified trainer
- Small class sizes for personalized attention
- Attend on campus in Miami or Fort Lauderdale, or live online
- Certificate of completion
With several convenient training delivery methods offered, The Academy makes getting the training you need easy. Whether you prefer to learn in a classroom or an online live learning virtual environment, training videos hosted online, and private group classes hosted at your site. We offer expert instruction to individuals, government agencies, non-profits, and corporations. Our live classes, on-sites, and online training videos all feature certified instructors who teach a detailed curriculum and share their expertise and insights with trainees. No matter how you prefer to receive the training, you can count on The Academy for an engaging and effective learning experience.
Methods
- Instructor Led (the best training format we offer)
- Live Online Classroom – Online Instructor Led
- Self-Paced Video
Speak to an Admissions Representative for complete details
| Start | Finish | Public Price | Public Enroll | Private Price | Private Enroll |
|---|---|---|---|---|---|
| 12/8/2025 | 12/9/2025 | ||||
| 12/29/2025 | 12/30/2025 | ||||
| 1/19/2026 | 1/20/2026 | ||||
| 2/9/2026 | 2/10/2026 | ||||
| 3/2/2026 | 3/3/2026 | ||||
| 3/23/2026 | 3/24/2026 | ||||
| 4/13/2026 | 4/14/2026 | ||||
| 5/4/2026 | 5/5/2026 | ||||
| 5/25/2026 | 5/26/2026 | ||||
| 6/15/2026 | 6/16/2026 | ||||
| 7/6/2026 | 7/7/2026 | ||||
| 7/27/2026 | 7/28/2026 | ||||
| 8/17/2026 | 8/18/2026 | ||||
| 9/7/2026 | 9/8/2026 | ||||
| 9/28/2026 | 9/29/2026 | ||||
| 10/19/2026 | 10/20/2026 | ||||
| 11/9/2026 | 11/10/2026 | ||||
| 11/30/2026 | 12/1/2026 | ||||
| 12/21/2026 | 12/22/2026 | ||||
| 1/11/2027 | 1/12/2027 |
Course Outline
Module 1: Preparing Data
Import and clean data with Power Query and structure it for analysis.
Module 2: Data Modeling
Build relationships and measures with Power Pivot and the data model.
Module 3: Analyzing with PivotTables
Summarize and explore data with advanced PivotTable techniques.
Module 4: Building Dashboards
Combine charts, slicers, and timelines into interactive dashboards.
Module 5: Visualization Best Practices
Choose the right chart, reduce clutter, and present insight clearly.
