Creating professional business charts 59.99 €

1) Introduction

An overview of the course and what will be learnt

2) A framework for business chart design

A design framework for creating business charts covering Setting (audience and context), Fit (choice of chart and fit to data), Style (clear and consistent formatting) and Action (highlighting insight ...

3) Audience Expectations

Part 1 of the design framework: "Setting". Focus on understanding the audience.

4) Clarity and Style

Part 3 of the design framework: "Style". Focus on simplicity, clarity and consistency.

5) Patterns and Fit: The selection process

Part 2 of the design framework: "Fit". Focus on the chart selection process.

6) Patterns and Fit: Categories of charts

Part 2 of the design framework: "Fit". Focus on the categories of charts for selection.

7) Insights and Action

Part 4 of the design framework: "Action". Focus on creating context, highlighting insights and calling to action.

8) Formatting Introduction

An outline of this section on Formatting charts in Excel. The section has two parts: the four lectures on formatting fundamentals are for beginners to charts in Excel. The formatting for business styl ...

9) Formatting Fundamentals: Data

Part 1 of 4 in formatting fundamentals for those starting out. Focus is on readying data.

10) Formatting Fundamentals: Chart Shaping

Part 2 of 4 in formatting fundamentals for those starting out. Focus is changing the form and type of chart.

11) Formatting Fundamentals: Chart Series

Part 3 of 4 in formatting fundamentals for those starting out. Focus is on applying general formatting to the series on a chart.

12) Formatting Fundamentals: Chart Elements

Part 4 of 4 in formatting fundamentals for those starting out. Focus is on application and formatting of chart elements.

13) Business Style Formatting - PART 1

The key lecture in the section on taking a chart from its default excel output to a business-ready style chart.

14) Business Style Formatting - PART 2

15) About this section

See the attached guide on how to navigate through this section, in case you wish to skip directly to your chart of choice. It provides an overview and reference on the application and step-by-step con ...

16) Columns, bars and the power of grouping and stacking PART 1 - APPLICATION

Lecture guide on the OVERVIEW and APPLICATION of the following charts:Stacked columnGrouped columnBarSubcategory variation on column + barPivotChart variation on column

17) Columns, bars and the power of grouping and stacking PART 2 - CREATION

Lecture guide on the STEPS TO CREATE (with accompanying Excel example workbook) the following charts:Stacked columnGrouped columnBarSubcategory variation on column + barPivotChart variation on colu ...

18) Scatter plots, histograms and regressive efficacy

Lecture guide (1. overview, 2. steps to create and 3. accompanying Excel example workbook) to create the following charts:ScatterplotHistogram

19) Line charts and their combinations

Lecture guide (1. overview, 2. steps to create and 3. accompanying Excel example workbook) to create the following charts:Line graphCombination graph

20) Doughnuts (donuts!?) over pies

Lecture guide (1. overview, 2. steps to create and 3. accompanying Excel example workbook) to create the following charts:Doughnut chartsSunburst charts

21) Waterfall charts and decomposing the movement of money

Lecture guide (1. overview, 2. steps to create and 3. accompanying Excel example workbook) to create the following charts:Waterfall charts

22) Bubble charts on growth, share and such measures

Lecture guide (1. overview, 2. steps to create and 3. accompanying Excel example workbook) to create the following charts:Bubble charts

23) Radar charts and scoring

Lecture guide (1. overview, 2. steps to create and 3. accompanying Excel example workbook) to create the following charts:Radar chart

24) Mekko charts and categorizing a market

Lecture guide (1. overview, 2. steps to create and 3. accompanying Excel example workbook) to create the following charts:Mekko chart

25) Presentation tactics and PowerPoint interfacing

How to publish your Excel charts in Powerpoint and Word

26) The complete wrap!

27) Bonus lecture: Heatmaps

Lecture guide (1. overview, 2. steps to create and 3. accompanying Excel example workbook) to create a heatmap