Two weeks ago my newsletter focused on the massive changes we have all been going through due to the need to socially distance and so many people now working from home instead of an office. Today I want to share some resources and tips for those who have moved their presentations to a virtual platform…
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.
Using superscript numbers to add footnotes to financial reports and graphs in Excel
It is common to use footnotes when reporting financial results. Footnotes allow you to be transparent with the viewer and disclose important assumptions or clarifications so that they can more accurately interpret the results. By using superscript numbers, we can make adding footnotes to financial reports and charts in Excel easier. To create a superscript…
Special COVID-19 update; Issue #461 March 31 2020
Since the last newsletter two weeks ago, so much has changed. Non-essential businesses are closed, we are asked to stay at home, and so many people have started working from home (something I’ve done for over twenty years). I hope that you and your family are following the guidance of local health authorities and staying…
Math Worksheet Generator
All of a sudden, children are out of school and classes have moved to an online format. This is likely unfamiliar territory for kids and their parents. Instead of practice worksheets that would be handed out in class, parents have to figure out how to support their child’s learning at home. When our kids were…
Creating area graphs with Charticulator; Issue #460 March 17, 2020
What can you do if you want to create a chart but the values you have differ by an order of magnitude or more? If you use the standard column or bar graph, you risk the smaller values being virtually invisible because the chart is scaled to show the large values. In my customized workshops…
Creating non-standard shapes; Issue #459 March 3, 2020
In a previous newsletter I showed how using semi-transparent shapes to show categories or groups of items can help explain a complex diagram or image. In the example, I used rectangles because the groups of items were located neatly beside each other. What if the items you want to group are not in a neat…
Hands-on Tools and Techniques for Creating Effective Financial Visuals in Excel and PowerPoint (February 18, 2021; Vancouver, BC)
Dave will be virtually delivering his CPABC course to an in-house finance group at a municipality. This will involve live teaching segments, videos that the participants watch, exercises where they practice the skills they are learning, and live review of questions and extension of the techniques.
Scaling values for related data series; Issue #458 February 18 2020
It is not uncommon that to communicate a message you need to show two or three related data series. It is relatively easy to create a single graph that has all the data series shown. The challenge comes when you have values in the data series that are different by an order of magnitude or…
Test slides when using video wall; Issue #457 February 4 2020
As more conference rooms move from using projectors to using monitors to display presentations, an issue is coming up in larger rooms. While a single large monitor will work in a small to medium sized room, it is too small for a medium to large sized room. To create a larger display, organizations install a…
Half-day virtual session for MBA students (February 1, 2021)
Dave will be delivering a half-day session virtually to the Smith School at Queens University MBA students who come from across Canada and some from international locations.