Excel Magic 7: Creating Excel Charts like a PRO




Excel Magic 7: Creating Excel Charts like a PRO

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

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

Url: View Details

What you will 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!

Rating: 0

Level: Intermediate Level

Duration: 1.5 hours

Instructor: Lenny Wu, MBA, CPA, CGA


Courses By:   0-9  A  B  C  D  E  F  G  H  I  J  K  L  M  N  O  P  Q  R  S  T  U  V  W  X  Y  Z 

About US

The display of third-party trademarks and trade names on this site does not necessarily indicate any affiliation or endorsement of course-link.com.


© 2021 course-link.com. All rights reserved.
View Sitemap