Excel Magic 7: Creating Excel Charts like a PRO

Excel Magic 7: Creating Excel Charts like a PRO

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

Learn how to build some of the most stunning charts in Excel!

Url: View Details

What you will 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!

Rating: 0

Level: Intermediate Level

Duration: 1.5 hours

Instructor: Lenny Wu, MBA, CPA, CGA