Excel Magic 7: Creating Excel Charts like a PRO
Excel Magic 7: Creating Excel Charts like a PRO
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 29 lectures (1h 16m) | Size: 522.4 MB
MP4 | Video: h264, 1280x720 | Audio: AAC, 44.1 KHz, 2 Ch
Genre: eLearning | Language: English + srt | Duration: 29 lectures (1h 16m) | Size: 522.4 MB
Learn how to build some of the most stunning charts in Excel!
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