About this Event
This course develops participants’ ability to convert raw data into clear, professional, and insight-driven visuals using Microsoft Excel. It focuses on selecting the right chart, applying purposeful formatting, and presenting information in a way that supports faster and more accurate decision-making. Participants will move beyond default chart settings and learn structured techniques for building dynamic visuals while maintaining ethical and responsible data presentation.​
- Bring own laptop with Excel
INCLUSIONS
For onsite:
- printed handout
- printed certificate
- fastfood lunch
- AM and PM snacks
- candies and coffee
- WIFI access
For via Zoom:
- PDF handout
- PDF certificate
Where in Cubao:
Mpower Learning Manila
222 Vivaldi Residences, 628 EDSA cor Aurora Blvd., Cubao, Quezon City
Objectives
By the end of this course, participants will be able to:
- Select appropriate charts based on data type and communication purpose
- Apply formatting techniques that improve clarity and visual impact
- Create specialized and interactive charts for deeper analysis
- Present charts effectively in reports and presentations
- Practice responsible visualization to ensure accuracy and credibility
Who this Course is For
- Professionals who prepare reports and dashboards
- Analysts translating data into insights
- Managers presenting metrics to stakeholders
- Excel users aiming to elevate their charting skills
Methodologies
- Hands-on chart-building exercises using realistic datasets to reinforce practical skills.
- Facilitated reviews and refinements to strengthen clarity, accuracy, and visual storytelling.
Outline
I. Introduction to Data and Charting Concepts
- Data types: categorical vs. numerical
- Matching charts to purpose: comparison, trends, distribution, relationships
- Choosing metrics: percentages vs. raw values
- Tables vs. charts vs. pie charts
- Effective color usage for readability
II. Creating and Customizing Charts in Excel
- Creating basic charts from structured data
- Modifying formats for clarity and professionalism
- Editing key elements: labels, data series, gridlines, legends, data tables
- Adding titles and annotations for context
III. Special Charts and When to Use Them (Curated Selection)
- Line and Scatter charts for trends and correlations
- Pie, Tree Map, and Sunburst for composition
- Waterfall and Area charts for change over time
- Histograms for distribution
- Map charts for geographic data
- Sparklines for compact trend visualization
IV. Creating Interactive and Dynamic Charts
- Using INDIRECT and OFFSET for interactivity
- Dynamic charts with drop-downs and Named Ranges
- Pivot Charts for filtering and slicing
V. Presenting and Linking Charts to PowerPoint
- Linking charts from Excel
- Embedding vs. linking
- Using Paste Special to preserve format and data
VI. Responsible Data Visualization (Brief Overview)
- Avoiding misleading visuals
- Ethical use of scale, color, and labels
- Promoting transparency in chart design
Event Venue & Nearby Stays
Mpower Learning Manila, 222 Vivaldi Residences, 628 EDSA c.or Aurora Blvd, Mandaluyong City, Philippines
PHP 262.48 to PHP 2728.69








