Creating Reports With EXCEL Charts and Graphical Tools

Quickly Craft Effective Presentations and Reports from Your Data

Excel includes a wealth of formatting tools to add power and flair to your presentations and reports so that you can deliver the "big picture" at a glance. This interactive webinar demonstrates these Excel features to help you tell the story of your data.

You will watch and learn quick methods for creating charts, learn how (and why) to use different chart types, and how to alter the look of a chart with layout, color, and content changes. Your instructor will guide you through transforming your raw numbers into visually appealing and meaningful reports using standard Excel features and some powerful add-ins that are free to use.

One often overlooked benefit of this course: Depicting your data in a chart can reveal insights that are hidden in the columns of numbers.

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.

In a nutshell, you’ll get simple and powerful tips for making your data more readable and understandable. Step-by-step, your instructor will demonstrate how to:

• Make your PivotTable data visually appealing with fonts, number formatting, layout, etc.
• Construct PivotTables so that it is easy to create summary reports
• Use charts and infographics  to succinctly display your data
• Explore, visualize and present your data using the “Power View for Excel” add-in
• Create 3-D geographic reports using the “Power Map for Excel” add-in
• Deploy style and design tips and tricks to build meaningful charts and graphs
• And the list goes on and on!

This webinar is designed to help intermediate Excel users create visually impactful reports. The training will be delivered using Excel 2016 for Windows®. However, much of the functionality is available in Excel 2013 and 2010 as well.

How You Will Benefit

After completing this course, you will be able to:

• Describe how to create charts and infographics with Excel
• Explain how to bring your reports to life using Excel add-ins

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.

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.

*Microsoft, Excel, and PivotTables are registered trademarks of Microsoft.

To fully participate in this electronic, interactive and live session, please check your system (or ask your IT department) to ensure it meets the following requirements:

Supported OS, Browser and Additional Requirements

• Windows 7 and above; Google Chrome (v66.0 & above), Internet Explorer (v11.0 & above), Mozilla Firefox (v55.0 & above), or Microsoft Edge (v16 & above)
• Mac OS X 10.11, 10.12 and 10.13; Google Chrome (v66.0 & above), Apple Safari (v11.0 & above) and Mozilla Firefox (v55.0 & above)
• Ubuntu 14.04 and 16.04; Red Hat Enterprise Linux 6; Google Chrome and Adobe Flash Player 23.0
• Google Android 4.4 or later
• Apple iOS: iOS 8.1.2 or later

If you are using an unsupported version of a Windows, Mac, or Linux operating system, you may experience difficulty in viewing and/or listening to the event.

Test Your Computer

The audio portion of this AMA web event will be delivered directly through your computer’s speakers or attached headphones. To fully participate in this electronic, interactive, live session, please test your system and review the requirements (or ask your IT department) before the program begins:

TEST NOW

Additional Requirements:

• Minimum bandwidth requirement is 512 kbps for meeting attendees
• POP-UP Blockers must be turned off to access the program.

Important tip - Please allow 15 minutes prior to joining a session to conduct your set-up and testing!

Need further assistance? Visit the complete technical requirements for Adobe Connect.