Excel Magic 7: Creating Excel Charts like a PRO

What you'll learn:
- to build some of the most stunning charts in Excel
- to make yourself the go-to-person in their office, or
- to be well positioned for your next promotion!

Requirements
Basic Excel
Example: be able to open one Excel file, etc.

Description
The course is presented in four parts.

First, the course reveals the 4 popular Excel Charts used by everyone. They are:

o Column chart

o Bar chart

o Line chart

o Pie chart

Next, the course presents 10 mostly used Excel Charting techniques, including:

o How to show a regression trendline?

o How to make charts dynamic for self-service reporting?

o How to make a Chart Title dynamic?

o How to highlight a column?

Third, the course demonstrates how to build 3 powerful Excel Charts that are rarely used. They are:

o Combo Chart

o Waterfall Chart

o Gauge Chart

Last, the course illustrates 4 best practices in Excel Charting. They are:

o Remove duplicate information from the Chart

o Avoid using 3-D Pie Chart

o Sort in Column/Bar charts

o Avoid distorted axis

Learning Objectives

● Master 4 basic but popular Excel charts

● Recognize 4 basic formatting techniques

● Discover 6 intermediate charting techniques

● Explore how to build 3 powerful but rarely used Excel Charts

● Understand 4 best practices in building Excel Charts

The course is presented in four parts.

First, the course reveals the 4 popular Excel Charts used by everyone. They are:

o Column chart

o Bar chart

o Line chart

o Pie chart

Next, the course presents 10 mostly used Excel Charting techniques, including:

o How to show a regression trendline?

o How to make charts dynamic for self-service reporting?

o How to make a Chart Title dynamic?

o How to highlight a column?

Third, the course demonstrates how to build 3 powerful Excel Charts that are rarely used. They are:

o Combo Chart

o Waterfall Chart

o Gauge Chart

Last, the course illustrates 4 best practices in Excel Charting. They are:

o Remove duplicate information from the Chart

o Avoid using 3-D Pie Chart

o Sort in Column/Bar charts

o Avoid distorted axis

Learning Objectives

● Master 4 basic but popular Excel charts

● Recognize 4 basic formatting techniques

● Discover 6 intermediate charting techniques

● Explore how to build 3 powerful but rarely used Excel Charts

● Understand 4 best practices in building Excel Charts

Who this course is for
Office workers, Professionals, and Managers