PowerPoint and Excel Data Visualization: Create Dynamic Financial Presentations, Charts, Graphs, and Diagrams
Description
Most professionals are called upon to present information not only
verbally but also with visual aids, handouts, and presentation software.
Applying graphics to represent or enhance data can help you make a
lasting impression on your audience. Whether you want to “wow” your
audience and/or convey a serious message simply, this course will give
you many examples of how to enhance your presentations in PowerPoint and
Excel. You can choose from the right pre-designed graphic, diagram, or
template or build your own. The content of this presentation applies to
PowerPoint and Excel 2016/2013/2010/2007. Participants will learn many
timesaving tips and receive take-aways for after class use. Format:
Instructor-led hands-on computer training.
Format: Instructor-led hands-on computer training. Bring your own laptop
or use one in the computer lab.
Learning Objectives
Learn to choose the best graphics for your topic and your audience
Place and modify text, diagrams, and graphics in your presentation slides
Learn to add transition and animation when needed to control your presentation
Acquire presenter tips for use during a presentation and use presenter view
Use the diagram features included in PowerPoint to show workflow, overlapping functions and staff organization
Learn the important Excel and Word tips for copying and linking between programs
Create a presentation handout or video file
Create varieties of bar charts, pie charts, trendlines, combination graphs, dual axis using new styles and graphics
Use a variety of accessible formatting features to emphasize and customize parts of the data visualization
Add multiple axes to present comparisons of disparate data in the same chart
Compare pie charts to sideways bar charts to emphasize ranking
Add your customized charts to the chart templates as a user-defined entry for quick application to future charts
Explore the chart variations of Sparklines, waterfall, tree, and bullet
Take away many templates and references for after class use
Major Topics
Learn to focus the message of your presentation
Determine which graphic works best with your information
Understand the impact of a variety of graphic symbols and colors
Apply Excel’s new color scales and icon sets to visually spot trends in data
Add a secondary axis to present a breakout of multiple sets of data
Use flow chart symbols and connectors to create work flow diagrams
Add data tables to charts to quickly present the numeric values * Incorporate photos, ClipArt, logos, video, sound
Incorporate photos, ClipArt, logos, video, sound * Use shapes and templates for workflow and organization charts
Use shapes and templates for workflow and organization charts
Use freely distributed pre-designed SmartArt templates
Use appropriate animation to enhance and control visual display
Package multimedia files with your presentation
Learn how to link data ranges or charts between Excel and Word and PowerPoint
Learn how to create effective handouts
Learn important presenter tips for controlling the visual information during the presentation and delivering the presentation effectively
Learn how to convert your PowerPoint presentation into a video file
Learn when to use the multiple axis feature for presenting various types of data
Learn when to use a pie or bar chart to emphasize ranking
Learn data selection techniques to populate the graphic elements
Learn how to present Pivot Table results in graphic form with Pivot Charts
Provider
Business Learning Institute
Course Level
Update
Professional Area of Focus
Technology
CPE Field of Study
Computer Science*
8.0
Who Should Attend
CPAs and Professionals at all levels of an organization who prepare, review and give presentations with PowerPoint and want to learn more in-depth topics with regard to the new time-saving charting and data visualization features in Excel
Instructor(s)
Judy Borsher
Prerequisites
Basic knowledge of MS Office Application Software and familiarity with PowerPoint and Excel
