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
