PowerPoint and Excel Data Visualization: Create Dynamic Financial Presentations, Charts, Graphs, and Diagrams
Description
The number of computers available for use is limited. Due to high registration numbers, we no longer have any available for use. However, you may bring your own laptop or you can attend the class without the computer, and participate in a regular lecture format.
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.
Learning Objectives
Upon completion of this seminar, participants will be able to:
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 whichgraphic works best with your information
Understand the impact of avariety of graphic symbols and colors
Apply Excel’s newcolor scales and icon sets to visually spot trends in data
Add asecondary axis to present a breakout of multiple sets of data
Use flowchart symbols and connectors to create work flow diagrams
Add datatables to charts to quickly present the numeric values
Incorporatephotos, ClipArt, logos, video, sound
Use shapes and templates forworkflow and organization charts
Use freely distributed pre-designedSmartArt templates
Use appropriate animation to enhance and controlvisual display
Package multimedia files with your presentation
Learnhow to link data ranges or charts between Excel and Word and PowerPoint
Learn how to create effective handouts
Learn important presentertips for controlling the visual information during the presentation anddelivering the presentation effectively
Learn how to convert yourPowerPoint presentation into a video file
Learn when to use themultiple axis feature for presenting various types of data
Learn whento use a pie or bar chart to emphasize ranking
Learn data selectiontechniques to populate the graphic elements
Learn how to present PivotTable results in graphic form with Pivot Charts
Provider
Business Learning Institute
Course Level
Update
Professional Area of Focus
Business & Industry
Technology
CPE Field of Study
Computer Science*
8
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 withPowerPoint and Excel
