Description

The course is presented in four parts.

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

• Column chart
• Bar chart
• Line chart
• Pie chart

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

• How to show a regression trendline?
• How to make charts dynamic for self-service reporting?
• How to make a Chart Title dynamic?
• How to highlight a column?

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

• Combo Chart
• Waterfall Chart
• Gauge Chart

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

• Remove duplicate information from the Chart
• Avoid using 3-D Pie Chart
• Sort in Column/Bar charts
• Avoid distorted axis

Course Key Concepts: Slicer, Combo Chart, Secondary Axis, Waterfall Chart, Gauge Chart, Gantt Chart.