Discover Classes. Earn Rewards.

How to Turn Data Into Compelling Visual Presentations

Master transforming data into captivating visual presentations with this practical course by the American Management Association. Learn how to communicate complex data using Microsoft Excel and PowerPoint, and gain insights into graphic design principles. Enhance your data storytelling skills and create impactful charts, graphs, and tables that leave a lasting impression on your audience.

  • All levels
  • 21 and older
  • $2,595
  • Live, interactive online classroom
  • 76 hours over 12 sessions

Start Dates (1)

  • $2,595
  • Live, interactive online classroom
  • 76 hours over 12 sessions
20 seats left
Book
Show all 12 sessions
  • Mon, May 13 at 2:00pm - 5:30pm
  • Tue, May 14 at 2:00pm - 5:30pm
  • Mon, May 20 at 2:00pm - 5:30pm
  • Tue, May 21 at 2:00pm - 5:30pm
  • Mon, Jun 24 at 9:00am - 5:00pm
  • Tue, Jun 25 at 9:00am - 4:30pm
  • Thu, Aug 15 at 10:00am - 6:00pm
  • Fri, Aug 16 at 10:00am - 5:30pm
  • Mon, Oct 14 at 11:00am - 7:00pm
  • Tue, Oct 15 at 11:00am - 6:30pm
  • Mon, Dec 09 at 9:00am - 5:00pm
  • Tue, Dec 10 at 9:00am - 4:30pm
Showing 11 of 1

Class Description

Description

What you'll learn in this microsoft office class:

Visually and clearly present data and the message it represents.

Who Should Attend:

Those with a foundational understanding of Microsoft Excel and PowerPoint, who work regularly with data and wish to design basic and more advanced charts, graphs, and tables

Overview

Communicating data and the story of what that data means has become increasingly important in recent years. As attention spans decrease and the amounts of quantitative information increase, it is crucial to be able to visualize your data for your audiences in the most clear and effective ways possible. A chart that takes 10 seconds to understand, compared to one that takes only 2 seconds, could mean the difference between a sale and no sale.

Your data is only as powerful as your visual presentation of it.

In this course, you will learn the fundamentals and best practices of data visualization techniques, as well as hands-on approaches to using Microsoft Excel and PowerPoint to present your data in a variety of formats.

You will complete multiple exercises and create various types of visualizations and charts throughout the course. You will also work individually and in groups to analyze, redesign, and improve poorly designed charts that are provided.

How You Will Benefit:

  • Understand basic graphic design principles and how audiences process information visually
  • Learn how to make use of emphasis, color, layout, and typography to maximize the clarity of your messages
  • Become familiar with available tools/techniques for data visualization
  • Understand the differences between “Glanceable” and “Referenceable” visualizations and how to harness the power of each
  • Increase the impact and strength of your messages by choosing the most effective chart for a given data set and story in various circumstances
  • Learn the one color that you should make use of in every visualization, the one default element that should be removed from every chart, how legends can confuse your audience, why a bar is nearly always better than a pie, and common design mistakes that distort your data and damage your credibility

What You Will Cover:

  • The history and current landscape of information and data design
  • Basic principles of graphic, information, and layout design
  • “Chart Junk” and how to remove it to improve clarity
  • Basic charts such as pies, columns, bars, lines, and variations of these
  • Advanced charts such as scatters, bubbles, histograms, bullet graphs, combos, and Paretos
  • Specialty charts including units, tree maps, and proportional shapes
  • How to make use of trend lines, reference bands, annotations, and direct labeling
  • When to use Excel and PowerPoint to create tables, how to properly design them, and how to apply conditional formatting to create heat maps and table lenses
  • Tricks, tips, and techniques for overcoming Excel and PowerPoint limitations and creating proper workflows

Special Feature

Course Requirements: MS Windows-based laptop with working browser to connect to the Internet via WiFi network; as well as a minimum of Microsoft Office 2019 or 365 for PC installed. Those with Mac computers may attend and will be able to follow and perform all exercises, but may not receive as detailed technical attention from the instructor.

Course Outline:

Learning Objective

  • Apply Best Practices for Optimizing Data Visualization and information Design to Determine the Most Effective Way to Present the Story of Your Quantitative Information and Data

The World of Data Visualization

  • Discuss the Importance of Information Design and Data Visualization
  • Identify General Options for Telling the Story of Your Data
  • Apply Best Practices for Graphic Design When Presenting Your Data

Chart Types

  • Identify and Eliminate Chart Junk
  • Apply Best Practices for Labeling and Titling When Presenting Your Data
  • Compare and Contrast Three Different Groups of Chart Types
  • Select a Chart Type That Best Communicates and Presents the Data Story You Wish to Tell

Reviews:

★★★★★
"very professional and helpful"
Instructor has a wealth of Microsoft suite knowledge (especially in the world of accounting) and was very professional and helpful. I wish the course was spread out into a longer time frame to fit in more information!

Vera R. 
8/21/2020



★★★★★
"The handouts were excellent"
I learnt a lot that I did not know and it was easily learnt. The handouts were excellent reference materials for when I forget how to do something, they are step by step and easy to follow.

Julie B. 
3/12/2021

Remote Learning

This course is available for "remote" learning and will be available to anyone with access to an internet device with a microphone (this includes most models of computers, tablets). Classes will take place with a "Live" instructor at the date/times listed below.

Upon registration, the instructor will send along additional information about how to log-on and participate in the class.

Refund Policy

For Classroom, Live Online, Express Skills Courses and Webinar programs, you may transfer to a future session, send someone to take your place, or cancel for a 5% fee up to 23 days prior to your program.

If you provide AMA with less than 23 days’ notice, or fail to attend, you will be liable for the entire program fee.

Programs included in AMA On Demand offerings are not eligible for substitution, transfer, cancellation, return, or refund. We appreciate that this is an important investment for you and your company and would like to accommodate your needs the best we can.

Please email us at [email protected]

In any event where a customer wants to cancel their enrollment and is eligible for a full refund, a 5% processing fee will be deducted from the refund amount.

Reviews of Classes at American Management Association (5)

Benefits of Booking Through CourseHorse

  • Booking is safe. When you book with us your details are protected by a secure connection.
  • Lowest price guaranteed. Classes on CourseHorse are never marked up.
  • This class will earn you 25950 points. Points give you money off your next class!

Questions & Answers (0)

Get quick answers from CourseHorse and past students.

Similar Classes

American Management Association

The American Management Association, International (AMA) is the global leader in talent development. Founded in 1923, AMA supports the goals of individuals and organizations through a complete range of educational products and services, including instructor-led classroom and virtual seminars, webinars,...

Read more about American Management Association

CourseHorse Approved

This school has been carefully vetted by CourseHorse and is a verified Online educator.

American Management Association

Give This Course as a Gift Card

  • Thousands of classes
  • No expiration
  • Unique and memorable gifts for any occasion
  • Personalized
  • Explore a passion, gain a new skill, discover a new hobby, engage in a memorable experience
  • Instant delivery
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™

Buy a Gift Card

Book this Class as a Group Event

Booking this class for a group? Find great private group events

Or see all Microsoft Office Group Events

Explore group events and team building activities ranging from cooking, art, escape rooms, trivia, and more.

CourseHorse Gift Cards

  • Creative & unique gift for any occasion
  • Thousands of classes & experiences
  • No expiration date
  • Instant e-delivery (or choose a date)
  • Add a personalized message
  • Lock in a price with the Inflation Buster Gift Card Price Adjuster™
Buy a Gift Card
gift card with the CourseHorse logo gift card with the CourseHorse logo
Loading...