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
Homepage

https://www.udemy.com/course/excel-magic-7-creating-excel-charts-like-a-pro/

Related Downloads :

{related-news}