One of my most popular Excel Chart Tips videos is the one on conditional formatting of a column chart based on the values being categorized into ranges (video is here). Another option for conditional formatting is to visually focus the audience on one (or more) column based on a condition or a decision you make.…
Tag: 2020
See your notes while sharing slides in Teams or Zoom; Issue #469 July 21, 2020
Last issue I shared how you can use Presenter View with two screens when sharing your slides in a Microsoft Teams or Zoom meeting so that you can see your notes and the attendees see your slides. In this newsletter I want to share three other methods you have for seeing your speaking notes. Method 1: Print…
Presenter View in Teams or Zoom (2 screens); Issue #468 July 7, 2020
In this issue I shared how to use PowerPoint’s Presenter View when delivering a presentation in Microsoft Teams or Zoom. I created two versions of the article, one for Windows 10 here and one for Mac here.
8 ways to engage an online audience; Issue #467 June 23, 2020
In this newsletter I shared this article: 8 ways to engage your audience when presenting in a Microsoft Teams or Zoom meeting
Less time creating slides, more time outside; Issue #466 June 9, 2020
The weather has finally gotten warm enough here to spend a large part of this past weekend outside. We had our first meals this year out on the deck and patio. When the weather is so nice, you don’t want to spend any more time inside creating slides than you have to. In this newsletter…
Building your skills for Teams & Zoom meetings; Issue #465 May 26, 2020
In the last newsletter I shared how meetings in the future will be different and shared links to my videos and guide that review some of the challenges and solutions. These ideas were quoted in an article in Canada’s national business newspaper and led to a radio interview last week. Presenters need to prepare for…
Meetings won’t be the same in the future; Issue #464 May 12, 2020
As we see more governments allow more workers to return to businesses after the coronavirus lockdowns, you need to realize that things are never going back to the way they were before. Business meetings will not look like they did at the start of this year. Companies have announced that a much larger proportion of…
Filter the data series shown on a graph; Issue #463 April 28, 2020
On a recent AFP webinar discussing what CEOs and Boards are expecting from the Finance department during these turbulent times, cash flow forecasting was clearly the biggest request. It was clear that finance teams are having to generate multiple future scenarios based on various assumptions. These forecasts get updated daily, if not more frequently. When…
Virtual presenting resources and tips; Issue #462 April 14, 2020
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…
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…