This training aims to use MS Excel and MS PowerPoint to convey story from data. Assuming that data has already been prepared, this module focuses on different ways to present data (using MS Excel) to achieve a certain purpose and to be appreciated by your
audience. Finally, the course will also demonstrate how to maximize MS PowerPoint to prepare for the presentation, both slides and the act of presenting to the audience.
June 5
Monday
8:30AM-4:30PM
YOU CAN JOIN ONSITE IN CUBAO or AT THE COMFORTS OF YOUR HOME VIA ZOOM
Click the "GET TICKETS" to find Payment Methods (GCash, credit card, bank deposit, etc.)
Onsite:
Registration: Php2,799 per person
EARLY BIRD: Php2,499 per person
INCLUSIONS:
- 1 AM snack
- 1 PM snack
- 1 lunch (fastfood)
- Handouts
- Certificate
- overflowing coffee
- WIFI access
BRING OWN LAPTOP
Where: Mpower Learning Manila
222 Vivaldi Residences, 628 EDSA cor Aurora Blvd., Cubao, QC
via Zoom:
Registration: Php2,699 per person
EARLY BIRD: Php2,399 per person
INCLUSIONS:
- PDF handouts
- PDF certificate
OUTLINE
I. Communicating with Data
- Understanding the Language of Data
- Good and Bad Data Visualizations
- Identifying What is Important
- Identifying Your Target’s Needs
II.Choosing the Right Chart to Convey Meaning
- The Three Main Charts: Column/Bar, Line, and Pie Charts
- Showing Relationships with Scatter Charts
- Showing Comparisons with Bubble Charts, Funnel Chart, etc.
- Showing Intersecting Aspects with Stacked Bars
- Showing Distribution with Histograms
- Showing Geographical Information with Map Charts
- Showing Hierarchy with Tree Maps and Sunburst Chart
III. Applying Design Principles in MS PowerPoint for Data Presentation
- Showing Order: Sequencing Your Data Narrative
- Bringing Out the Story with Design Principles: Colors and Formatting
- Animating Charts to Help in Delivering the Message
- Creating Links for Slides Navigation
- Creating Trigger Animation for Interaction and Reasoning
- Highlighting Important Aspects in a Presentation
IV. Creating Dashboards
- Considerations when Designing Dashboards
- Laying Out Your Dashboard
- Making Interactive Dashboards
V. Ethics, Deception, and Fallacies
- Ethics in Data Storytelling
- Data Fallacies
- Avoiding Data Deception
- Cherry Picking
- Data Hacking
Outline
OUTLINE
I. Communicating with Data
- Understanding the Language of Data
- Good and Bad Data Visualizations
- Identifying What is Important
- Identifying Your Target’s Needs
II.Choosing the Right Chart to Convey Meaning
- The Three Main Charts: Column/Bar, Line, and Pie Charts
- Showing Relationships with Scatter Charts
- Showing Comparisons with Bubble Charts, Funnel Chart, etc.
- Showing Intersecting Aspects with Stacked Bars
- Showing Distribution with Histograms
- Showing Geographical Information with Map Charts
- Showing Hierarchy with Tree Maps and Sunburst Chart
III. Applying Design Principles in MS PowerPoint for Data Presentation
- Showing Order: Sequencing Your Data Narrative
- Bringing Out the Story with Design Principles: Colors and Formatting
- Animating Charts to Help in Delivering the Message
- Creating Links for Slides Navigation
- Creating Trigger Animation for Interaction and Reasoning
- Highlighting Important Aspects in a Presentation
IV. Creating Dashboards
- Considerations when Designing Dashboards
- Laying Out Your Dashboard
- Making Interactive Dashboards
V. Ethics, Deception, and Fallacies
- Ethics in Data Storytelling
- Data Fallacies
- Avoiding Data Deception
- Cherry Picking
- Data Hacking
