CPABC Course: Hands-on Tools and Techniques for Creating Effective Financial Visuals in Excel and PowerPoint (July 13, 2022; Virtual)

Description

Prerequisite

This is not a basic level Excel or PowerPoint course. You need to come already being familiar with the programs and have intermediate level skills, especially in graphing. If you are comfortable with all the skills in this article/video, you will be adequately prepared for this course.

Special Note

This is a hands-on seminar with demonstrations using Office 2016 for Windows. Please bring a laptop with Office 2013 or higher for Windows, or Office 2016 or later for Mac. Bring your laptop, power cord, and external mouse if you prefer that to a trackpad.

Overview

Too many financial presentations rely on huge spreadsheets or paragraphs of text copied onto slides. Audiences say these overloaded slides confuse them and executives don’t take action when they are unsure of the message. This seminar will help you create visuals – clear, effective graphs in Excel or PowerPoint; diagrams that show comparison of value in new ways; and time-based diagrams – that clearly communicate the message behind the numbers.

Who Should Attend

Professionals who use PowerPoint to communicate financial information to others.

Content

  • create graphs in either Excel or PowerPoint that are uncluttered and easy to understand
  • create advanced graphs
  • add labels and other explanatory text to graphs to make the message clear
  • create diagrams that show comparison of values such as proportional shape collections and grouped item comparisons
  • create time-based diagrams to show financial processes or information about when certain financial events occur
  • add callouts to any visual to focus the audience’s attention (and make sure the callout shape or arrow can be seen no matter the background)
  • use builds to focus the attention while you discuss each part of the visual

Register on the CPABC PD website.

By 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.