I often get asked how to copy a table of cells from Excel onto a PowerPoint slide and animate the table by row. The default paste of cells results in a PowerPoint table, which can’t be animated by row. In this video I show you how to paste the cells as a text box table…
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.
Use Edge Picture in picture to display your webcam beside PowerPoint slides in Teams or Zoom
What is Picture in picture (PiP) in Edge? The Edge browser added the ability on Windows and Mac platforms to pop out compatible videos into their own window that has no browser user interface. By default it is available to anyone using the Edge browser on Windows or Mac, there is no plug-in or extension…
The Globe and Mail March 24 2022
Dave’s article on why we shouldn’t go back to the way in-person meeting were in the past was mentioned in this column by Harvey Schachter.
Excel Tip: Color conditional formatting of directional indicator symbols in cells
A financial professional in one of my courses asked if it was possible to conditionally format the color of a symbol to indicate good or poor performance. The indicator direction and color needed to be set based on the value of the cell. This video shows you how to achieve this by combining formulas and…
Use a second laptop as a second HDMI screen monitor for your primary laptop (Windows or Mac)
A second screen is great for PowerPoint Presenter View or for being more efficient at getting work done. If you don’t have a monitor to plug into your Windows or Mac laptop as a second screen but you have an HDMI port and a second Windows or Mac laptop, you can do it. (If you…
No more “next slide please”; Share keyboard and mouse control with other presenters in Teams & Zoom
You are part of a team that is delivering an important presentation to the executive group. Each person will present a few slides in the overall deck sharing the results in their area. When we were in person, you’d just have the next presenter come up to the front of the room and take the…
Presentations at in-person meetings shouldn’t go back to the way they were before
Now that many business professionals are returning to the office, more meetings will have everyone in a meeting room like in the past. I don’t think this should mean that presentations go back to the way they were before: the presenter standing at the front of the room beside the screen. The lessons we learned…
Use Windows Magnifier to zoom in and pan around a slide or other content in a Zoom or Teams meeting
I recently discovered a new way to present complex or dense slides in a Zoom or Teams meeting. The challenge with complex visuals is that the audience gets easily overwhelmed and doesn’t know where to look. You can’t easily use a laser pointer to direct their attention because they get distracted by the movement. If…
AFP article February 25, 2022
AFP (Association for Financial Professionals) wrote an article about the webinar I was part of discussing data visuals. I shared some tips and showed some makeovers. The response was very positive and we will be doing it again in the spring. The article summarizing the webinar is here.
Force a column, bar, or line chart in Excel to start at zero
Excel changes the starting value for the measurement axis of column, bar, and line charts based on the values being graphed. This can cause a chart to be misleading just because the data got updated. In this video I show you how to add a second invisible data series that forces Excel to always start…