Excel Magic 7: Creating Excel Charts like a PRO
Learn how to create stunning charts in Excel and become the go-to person in your office with this comprehensive course. Master popular charts like column, bar, line, and pie charts, and discover advanced techniques such as regression trendlines and dynamic chart titles. Build powerful but rarely used charts like combo, waterfall, and gauge charts, and learn best practices for effective charting. Perfect for office workers, professionals, and managers looking to enhance their Excel skills and excel in their careers.
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!
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
User Reviews
Be the first to review “Excel Magic 7: Creating Excel Charts like a PRO”
You must be logged in to post a review.
There are no reviews yet.