Data Visualization: Charting Like a Pro

This training aims to use MS Excel to create basic to advanced and interactive charts. The module focuses on navigating the interface of Excel to perform tasks that are not as straightforward as just creating a regular chart.

• 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

TIME

All schedules are set at 8AM-5PM. However, if the headcount is low, the training may be set at 9AM-4PM or 9AM-5PM. Your certificate, still, will indicate 8 hours.The start time and end time will be finalized three days before the class. Please look for an email from inquire@insightsmanila.com or chat with us to confirm.

OUTLINE

I. Introduction to Charting in Excel
• Creating Basic Charts
• Modifying Chart Formats• Editing Chart Elements and When to Use Them
• Labels: Axis and Data Labels
• Data Points and Data Series
• Gridlines and Tick Marks
• Legends and Data Tables

II. Creating Special Charts
• Showing Relationships with Scatter Charts
• Sparklines
• Showing Flow of Numbers using Waterfall Charts and Bridge Charts
• Maximizing Area Charts
• Histograms
• Bubble Charts
• Showing Geographical Data with Map Charts
• Showing Hierarchy with Tree Maps and Sunburst Charts

III. Executing Complex Chart Concepts
• Charts with Triple Axis
• Creating Thermometer Charts
• Creating Gauge Charts

IV. Creating Interactive Charts
• Dynamic Charts using INDIRECT
• Dynamic Charts using OFFSET
• Dynamic Charts using Pivot Charts

V. Linking Charts to PowerPoint
• Linking Charts from Excel to PowerPoint
• Embedding Charts
• Using Paste Special to Link Charts