Data Visualization: Charting Like a Pro

This training aims to use MS Excel to create basic to advanced and interactive charts.

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:

1. printed handout
2. printed certificate
3. fastfood lunch
4. AM and PM snacks
5. candies and coffee
6. WIFI access

For via Zoom:

1. PDF handout
2. 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