Using Excel™ and PowerPoint™ to Tell the Story of Your Data
We have all sat through boring presentations where every slide is a table of numbers. You might even be guilty of sharing your data in this way.
To present your data in a format that is compelling and memorable requires creating understandable slides that illustrate the message you are trying to convey.
The good news is that putting together a presentation that tells the story of your data is much easier than you think.
This webinar focuses on the efficient presentation of your Excel data in a PowerPoint presentation. You’ll discover how to format and extract key insights from your Excel data and then design effective charts and graphs to help you tell a great story.
Your instructor will demonstrate exactly what steps to take, and you’ll have access to a recorded version of the program to refer back to as you develop future presentations and further refine your skills.
What You Will Learn
Join us to discover how to create visuals that are easy to understand, how much data to include in your presentation,and the best way to structure your data and create insightful charts and graphs, including:
- Selecting source data for a chart from non-adjacent ranges or from multiple sheets
- Preparing data to create a chart or graph
- Determining which chart types are best for the data being depicted and how to change types quickly
- Inserting trendlines and adjusting gridlines and axes
- Choosing color schemes
- Setting up dynamic charts (those that grow daily, weekly, or monthly) with Excel’s Table feature
- Creating in-cell charts with Sparklines
- Graph and chart shortcuts
- Adding charts and data to PowerPoint
- Linking charts in PowerPoint
Please note: Your instructor will be demonstrating these methods and techniques using PowerPoint and Excel 2016.
How You Will Benefit
After completing this course, you will be able to:
- Format, select, and prepare source data in Excel
- Determine the best chart type to use based upon the data being presented
- Add and link charts to PowerPoint
How Do AMA Webinars Work?
AMA Webinars provide you with a cost-effective and convenient way to boost your know-how. You can participate in the comfort of your office without the need for travel costs and time.
Because the webinar is live, you can ask our expert questions via online chat during the program. In addition, we will be sending you pre-work approximately one day before the program date via email. Please register early to get these materials that will help guide your learning process!
In addition, paid registrants will have a single-user license to access a recorded archive of the program for a full year, allowing you to revisit the material to refresh your memory and reinforce your skills.
Please note that AMA Webinars are designed to provide a one-to-one learning experience for an individual and are not designed to be viewed in a group setting. Program access is available only via the MYAMA account of the registered attendee.
This particular webinar does not offer continuing education credits.
*Microsoft, PowerPoint, and Excel are registered trademarks of Microsoft.
About the Presenters
Transfer, Cancellation and Refund Policy. For Classroom, Live Online and Webinar programs, you may transfer to a future session, send someone to take your place or cancel without penalty at any time up to three weeks prior to your program. If you provide AMA with less than three weeks’ notice, or fail to attend, you will be liable for the entire program fee. Programs included in AMA OnDemand offerings are not eligible for substitution, transfer, cancellation, return or refund. We appreciate that this is an important investment for you and your company and would like to accommodate your needs the best we can. Please call us if you have any questions