Course Description
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.
About Your Instructor
BJ Wilson is a Microsoft Certified Trainer and Excel expert with Osprey Productions. He has been helping people learn Microsoft Office for the past 10 years.
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 yo
Agenda
What You Will CoverJoin 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
Please note: The presenter will be demonstrating these methods and techniques using Excel for Office 365, however much of the functionality is also available to users of earlier versions of Excel on both Windows and Mac.
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 home or office without the need for travel costs and time.
BONUS: Paid registrants will also get a single-user license to access a recorded archive of the program for a full year.
*Microsoft, PowerPoint, and Excel are registered trademarks of Microsoft.
Audience
Cancellation: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