Professional Business Charts in Excel

Learn how to create professional graphs and charts to make an impact with clients, executives and decision makers

This course brings together everything you need to know to create professional business charts in Excel that make an impact, bring data to life, and reveal key insights at a glance.

You will learn about the key business and finance charts you'll need for all general management and executive decision making. That's 15 charts in all, and you do not need to know any more unless you're a specialist! You will develop a deep understanding of how to select the right graph for the data, applying the best styles and revealing the most relevant insights, no matter how complex. With step-by-step guidance on how to construct each of the charts, along the way you'll uncover all the handy tips and tricks you'll need to format charts and structure the underlying data, making charting seamless and simple.

We do not settle for the standard Excel chart output and ALWAYS demonstrate the important extra mile: how to structure and style your chart (and data) to a ready-to-publish business professional standard. Every chart is available as a downloadable resource, in a ready-to-go, fully formed and publishable format. You'll walk away from this course able to create each and every one of the charts in the exact same professional format.

In the hands-on lectures, we explore both the overview / application and the construction of each graph / chart. You'll gain a practical sense of how each chart is used in a business and finance setting, fitting both discrete and continuous data, from category-based through relative share, as well as correlation, rating, ranking and aggregation. This includes mastering well-known charts like column and bar, and learning to build lesser-known charts like Marimekko from scratch in Excel with no plugins at all!

We cover these charts:

• Stacked column charts

• Grouped column charts

• Bar charts

• Subcategory variations on bar / column charts

• PivotChart variation on column charts

• Line charts

• Combo charts

• Scatterplots

• Histograms (both prior and post Excel 2016)

• Doughnut charts

• Sunburst charts

• Waterfall charts (both prior and post Excel 2016)

• Bubble charts

• Radar charts

• Mekko charts

• Heatmaps

• An attempt to talk you out of pie charts :)