Creating professional business charts

Creating professional business charts, available at $54.99, has an average rating of 4.45, with 27 lectures, 2 quizzes, based on 14 reviews, and has 73 subscribers.

You will learn about Create business professional level graphs and charts in Excel Learn step-by-step how to create 15 of the most important charts in business Fit the right chart to the right data Apply formatting and style techniques Extract key chart insights and illustrate context and actions This course is ideal for individuals who are Anyone developing charts for management, executive or board decision making or Market planners, strategists and divisional support persons or Management consultants or Financial managers, modelers and quants analysts It is particularly useful for Anyone developing charts for management, executive or board decision making or Market planners, strategists and divisional support persons or Management consultants or Financial managers, modelers and quants analysts.

Enroll now: Creating professional business charts

Summary

Title: Creating professional business charts

Price: $54.99

Average Rating: 4.45

Number of Lectures: 27

Number of Quizzes: 2

Number of Published Lectures: 27

Number of Published Quizzes: 2

Number of Curriculum Items: 29

Number of Published Curriculum Objects: 29

Original Price: $39.99

Quality Status: approved

Status: Live

What You Will Learn

Create business professional level graphs and charts in Excel
Learn step-by-step how to create 15 of the most important charts in business
Fit the right chart to the right data
Apply formatting and style techniques
Extract key chart insights and illustrate context and actions

Who Should Attend

Anyone developing charts for management, executive or board decision making
Market planners, strategists and divisional support persons
Management consultants
Financial managers, modelers and quants analysts

Target Audiences

Anyone developing charts for management, executive or board decision making
Market planners, strategists and divisional support persons
Management consultants
Financial managers, modelers and quants analysts

This course brings together everything you need to know tocreate professional business charts that make an impact, bring data to life, andreveal key insightsat 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 stylesand 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 chartsand structure the underlying data, making charting seamless and simple.

We NEVER 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 / applicationand 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 🙂

Course Curriculum

Chapter 1: Business data visualization leading practice

Lecture 1: Introduction

Lecture 2: A framework for business chart design

Lecture 3: Audience Expectations

Lecture 4: Clarity and Style

Lecture 5: Patterns and Fit: The selection process

Lecture 6: Patterns and Fit: Categories of charts

Lecture 7: Insights and Action

Chapter 2: Chart Formatting

Lecture 1: Formatting Introduction

Lecture 2: Formatting Fundamentals: Data

Lecture 3: Formatting Fundamentals: Chart Shaping

Lecture 4: Formatting Fundamentals: Chart Series

Lecture 5: Formatting Fundamentals: Chart Elements

Lecture 6: Business Style Formatting – PART 1

Lecture 7: Business Style Formatting – PART 2

Chapter 3: Creating top business charts

Lecture 1: About this section

Lecture 2: Columns, bars and the power of grouping and stacking PART 1 – APPLICATION

Lecture 3: Columns, bars and the power of grouping and stacking PART 2 – CREATION

Lecture 4: Scatter plots, histograms and regressive efficacy

Lecture 5: Line charts and their combinations

Lecture 6: Doughnuts (donuts!?) over pies

Lecture 7: Waterfall charts and decomposing the movement of money

Lecture 8: Bubble charts on growth, share and such measures

Lecture 9: Radar charts and scoring

Lecture 10: Mekko charts and categorizing a market

Chapter 4: Concluding

Lecture 1: Presentation tactics and PowerPoint interfacing

Lecture 2: The complete wrap!

Lecture 3: Bonus lecture: Heatmaps

Instructors

Rolf Moes
Business strategy and finance

Rating Distribution

1 stars: 0 votes
2 stars: 0 votes
3 stars: 2 votes
4 stars: 4 votes
5 stars: 8 votes

Frequently Asked Questions

How long do I have access to the course materials?

You can view and review the lecture materials indefinitely, like an on-demand channel.

Can I take my courses with me wherever I go?

Definitely! If you have an internet connection, courses on Udemy are available on any device at any time. If you don’t have an internet connection, some instructors also let their students download course lectures. That’s up to the instructor though, so make sure you get on their good side!

Menu