When you are using a clustered column graph in Excel that has two or more data series, how do you tell the viewer which set of columns is which data series? The default method is to use colors and the legend. This video shows you a way to add the data series names into one…
Author: Dave Paradi
Dave Paradi has over twenty-two years of experience delivering customized training workshops to help business professionals improve their presentations. He has written ten books and over 600 articles on the topic of effective presentations and his ideas have appeared in publications around the world. His focus is on helping corporate professionals visually communicate the messages in their data so they don't overwhelm and confuse executives. Dave is one of fewer than ten people in North America recognized by Microsoft with the Most Valuable Professional Award for his contributions to the Excel, PowerPoint, and Teams communities. His articles and videos on virtual presenting have been viewed over 4.8 million times and liked over 17,000 times on YouTube.
Solve inconsistent audio quality in hybrid meetings with an Anker PowerConf speaker
If you are running hybrid meetings, where some people are in the room and some are attending virtually, you’ve likely run into the common issue with audio quality. When you are using your laptop mic as the room mic the remote attendees can’t hear the people who are sitting at the other end of the…
FinancialViz Makeover: Table of metrics to 3 visuals based on the message for each metric
This makeover is based on a recent example from a session I delivered at a conference in Philadelphia. I commonly see tables of related metrics in the slides from the participants in my FinancialViz training courses. In this video I show you how to turn the table into 3 visuals, each one based on the…
P2F2
Thanks for attending my pre-conference session at P2F2 2022 in Philadelphia. Below are some resources to further your skills on some of the topics I covered during the session. These are the types of skills I teach in my customized live virtual FinancialViz training courses. Create charts that are easy to update and re-use This…
Thank the creators of YouTube videos that solve your problem
Like many people, I search for solutions to problems with Excel, Outlook, Office 365, and home repairs on YouTube. Often I will find a video that solves the exact problem I am having. I am so thankful to the creators who produce these videos. For many people YouTube is considered a free training site. Some…
FinancialViz makeover: Make a Top 5 / Bottom 5 bar chart communicate clearly
This makeover is a recent visual I worked on and is similar to the “Top 5 / Bottom 5” visuals I see in my FinancialViz training courses. In this video I show you how to make the message clearer and it is done only using Excel, what you are already using. If you want to…
YouTube is a poor substitute for a customized software training course
Too many managers have decided that they don’t need to train their staff on any common office software like Word, Excel, PowerPoint, Outlook, or Teams because their staff can find the answer to any question on YouTube. They figure it saves the cost of a training course from an expert. I think they are wrong…
Moving from WFH to the office: Introduction
You’ve been working from home for the last two and a half years. Now you are starting to return to the office some days of the week. You’ve got comfortable with your WFH setup. Going back to the office will be a little strange, but you think things will just go back to the way…
Moving from WFH to the office: Attending a hybrid meeting or presentation
This article is part of my series on changes business professionals should prepare for as they return some days to the office and we move from a work from home (WFH) environment to a hybrid meeting environment. You can see the full list of articles here. In this article I share three tips for attending…
Fixing the “Values don’t add to 100% because of rounding” issue in Excel pie charts & tables
Too often I see a footnote on an Excel chart or table in a presentation that says “the values don’t add to 100% because of rounding.” Sometimes the values don’t add to 100% and there is no footnote, it just appears to be a mathematical mistake. Both of these situations cause doubt in the mind…