Using Microsoft Excel for Data Driven Presentations

Using Microsoft Excel for Data Driven Presentations covers the last mile between analysis and decision. In one day, participants learn to choose a chart that fits the question, strip the decoration that hides the point, build visuals in Excel that survive being pasted into a deck, and present a number so an audience acts on it. Available by request only, with a three participant minimum.

Description

The day opens with the question, because the chart follows from it. Participants learn to name what they need the audience to conclude, then choose a form that carries it: comparison, composition, distribution, or change over time. Most discover they have been defaulting to one chart type for every purpose.

The middle is subtraction. Participants strip gridlines, legends, effects, and colors that carry no information, and learn why the default chart is designed to look busy rather than to communicate. They practice writing a title that states the finding rather than labeling the data, which is the single highest-return change most of them will make.

The last stretch is durability and delivery. Participants build visuals in Excel that survive being pasted into a deck and updated later, and practice presenting a number so an audience acts on it: leading with the finding, showing only what supports it, and handling the question about methodology without losing the room.

Prerequisites

Participants should be comfortable working with data in Excel and building a basic chart. Those without that foundation should start with Microsoft Excel Beginners (Level 1).

Includes

This course includes

  • Live, instructor led workshop delivered in two 4-hour sessions
  • Hands on rework of your own real charts and reports
  • Chart selection driven by the question rather than habit
  • Practice presenting a number so an audience acts on it
  • Digital learning materials and take home reference guides
  • Certificate of completion for every participant

Objectives

What You'll Learn at a Glance

  • Name what the audience must conclude before choosing a chart
  • Choose a chart form that fits comparison, composition, distribution, or change
  • Strip decoration that carries no information
  • Write a title that states the finding rather than labeling the data
  • Build Excel visuals that survive being pasted into a deck
  • Lead with the finding and show only what supports it
  • Handle a methodology question without losing the room

Overview

The data was right. The slide lost the room.

The analysis was correct. The chart had eleven colors, a legend nobody read, and a title that named the data instead of the finding. The room nodded and did nothing. That is a communication failure, and the person who did the work absorbs the blame.

This workshop is the last mile. Not more analysis, but the translation from a correct number into something that changes a decision. It is a genuinely separate skill, and the people best at the analysis are frequently worst at it.

Finance, operations, and HR leaders use this where good work is not landing with executives or funders. It is the presentation counterpart to our Excel training, which teaches the analysis itself. The speaking side of presenting is Presentation Skills for the Workplace.

Content, datasets, and examples are built around your actual work before delivery. Most groups train live online, and on-site in-person delivery is available by request. This workshop is available by request only, with a three participant minimum, and sits alongside our other data analytics and data literacy workshops.

Tuition

Using Microsoft Excel for Data Driven Presentations is available by request only, scheduled around your team.

  • $495 per participant, with a three participant minimum
  • Private training: request a custom quote. One on one sessions and teams below the three participant minimum are priced case by case
  • Larger groups: request a custom quote. We price larger cohorts case by case based on group size, schedule, and delivery format
  • Optional courseware: the Microsoft Excel Data Analysis & Visualization Student Guide (Logical Operations) is available at $65 per participant and is not included in the course price

Colorado state agencies, higher education institutions, cities, counties, school districts, and certified nonprofits may purchase this course directly through our State of Colorado Price Agreement. Request a quote and we will build pricing around your team.

Similar classes

Microsoft Excel Beginners builds the foundation almost nobody was given. Across two sessions, participants learn to structure a spreadsheet so it can grow, write formulas that do not break when a row moves, format so a reader can follow it, and stop doing by hand what Excel will do for them. The payoff is staff who produce reliable work instead of fragile ones. Available by request only, with a three participant minimum.

More Information

Microsoft Excel Intermediate closes the gap between knowing functions and working efficiently. Across two sessions, participants learn to pull data across sheets and files, build logic that handles the exceptions, clean messy data without retyping it, and summarize thousands of rows into something a manager can read. The payoff is hours back on work that is currently manual. Available by request only, with a three participant minimum.

More Information

Microsoft Excel Advanced turns a capable user into someone who builds tools rather than files. Across two sessions, participants learn to connect and reshape data so a report refreshes instead of being rebuilt, automate the steps they repeat, protect a workbook other people will use, and know when Excel has stopped being the right answer. Available by request only, with a three participant minimum.

More Information

Microsoft Excel Advanced Formulas and Functions is a deep pass on the logic itself. Across two sessions, participants learn to build formulas that handle real exceptions, combine functions without creating something unreadable, work with dates and text that arrive in the wrong shape, and trace a calculation that is producing the wrong answer. Available by request only, with a three participant minimum.

More Information

Microsoft Excel PivotTables teaches the fastest route from raw data to an answer. Across two sessions, participants learn to structure source data so a pivot works, summarize tens of thousands of rows in seconds, slice by any dimension without rebuilding, calculate inside the pivot, and recognize when a pivot is quietly giving them the wrong number. Available by request only, with a three participant minimum.

More Information

Live online Data Analytics Certificate for career changers and job seekers. Learn SQL, Python and Pandas, statistics, Excel, Power BI, and machine learning with scikit-learn in a small cohort taught live by an experienced data instructor. Build portfolio projects in every module and finish with a Capstone presented live. 198 hours. No coding or math background needed. New cohorts start throughout the year.

More Information

Understanding AI and Data Literacy teaches employees to interrogate the numbers and the AI output they are handed. In a half day, they learn to read a chart without being misled by it, ask where data came from and what it leaves out, tell correlation from cause, and evaluate an AI generated analysis rather than forwarding it. The payoff is fewer decisions made on a misread. Available by request only, with a three participant minimum.

More Information

Microsoft Power BI for Data Driven Decision Makers is for managers who use dashboards but do not build them. In one day, they learn to read a report critically, find the filter that is hiding something, tell a real trend from noise, ask the question that gets a useful answer from an analyst, and know when the dashboard cannot answer what they need. Available by request only, with a three participant minimum.

More Information

Tableau for Data Driven Decision Makers teaches leaders to use visual analytics rather than be shown it. Over two days, they learn to interrogate a dashboard someone else built, explore and filter it themselves instead of requesting a new version, tell a design choice that clarifies from one that distorts, and reach a decision they can defend. Available by request only, with a three participant minimum.

More Information

The Excel Master Program is private, one-on-one Excel training that takes one person to the advanced level: four live courses, Intermediate (Level 2), Advanced (Level 3), Advanced Formulas and Functions, and PivotTables, 27 hours over eight sessions. New to Excel? Add Excel Beginners (Level 1) for $199. Taught 100% live online, two sessions per week. Available by request; no public schedule posted.

More Information