Excel Magic 7: Creating Excel Charts like a PRO

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

The course is presented in four parts.

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!.

Course Content

  • Introduction –> 6 lectures • 8min.
  • 4 Basic Excel Charts –> 5 lectures • 20min.
  • 6 Intermediate Excel Charting Techniques –> 6 lectures • 20min.
  • 3 Powerful Excel Charts that Are Rarely Used –> 6 lectures • 21min.
  • 4 Excel Chart Best Practices –> 4 lectures • 6min.
  • Conclusion –> 2 lectures • 2min.

Excel Magic 7: Creating Excel Charts like a PRO

Requirements

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

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