Instructor for this course
more

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.

Learning Objectives

  • Identify and 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.
  • Recognize and understand 4 best practices in building Excel Charts.
Last updated/reviewed: July 14, 2021

2 Reviews (3 ratings)Reviews

5
Anonymous Author
Lenny does a great job of explaining and walking through the graphing process. I learned some new shortcuts in addition to the graphing techniques
5
Anonymous Author
Loved the examples shown for the several advanced chart types. The waterfall and combo chart have immediate applications to quarterly IS meetings.

Prerequisites

Education Provider Information

Company:
Illumeo, Inc., 75 East Santa Clara St., Suite 1215, San Jose, CA 95113
Contact:
For more information regarding this course, including complaint and cancellation policies, please contact our offices at (408) 400- 3993 or send an e-mail to .
Course Syllabus
INTRODUCTION AND OVERVIEW
  0:42Introduction to Excel Magic 7: Creating Excel Charts like a PRO
  2:08Data Visualization
  1:26Hidden Powers of Excel Charts
  1:15Instructor Introduction
  1:28How this course is compared with “other similar courses”?
  0:32What you will get from this course?
4 Basic Excel Charts
  1:354 Basic Excel Charts (Part 1)
  4:064 Basic Excel Charts (Part 2)
  4:494 Basic Excel Charts (Part 3)
  3:374 Basic Excel Charts (Part 4)
  5:394 Basic Excel Charts (Part 5)
Intermediate Excel Charting Techniques
  3:286 Intermediate Excel Charting Techniques (Part 1)
  1:506 Intermediate Excel Charting Techniques (Part 2)
  2:556 Intermediate Excel Charting Techniques (Part 3)
  4:146 Intermediate Excel Charting Techniques (Part 4)
  2:536 Intermediate Excel Charting Techniques (Part 5)
  5:016 Intermediate Excel Charting Techniques (Part 6)
3 Powerful Excel Charts that Are Rarely Used
  2:553 Powerful Excel Charts that Are Rarely Used (Part 1)
  4:133 Powerful Excel Charts that Are Rarely Used (Part 2)
  4:443 Powerful Excel Charts that Are Rarely Used (Part 3)
  3:183 Powerful Excel Charts that Are Rarely Used (Part 4)
  3:573 Powerful Excel Charts that Are Rarely Used (Part 5)
  1:213 Powerful Excel Charts that Are Rarely Used (Part 6)
4 Excel Chart Best Practices
  1:134 Excel Chart Best Practices (Part 1)
  1:194 Excel Charts Best Practices (Part 2)
  1:324 Excel Chart Best Practices (Part 3)
  2:004 Excel Chart Best Practices (Part 4)
Conclusion
  1:32Takeaways
  0:31Q & A
CONTINUOUS PLAY
  1:16:13Excel Magic 7: Creating Excel Charts like a PRO
SUPPORTING MATERIAL
  PDFSlide: Excel Magic 7: Creating Excel Charts like a PRO
  PDFExcel Magic 7: Creating Excel Charts like a PRO Glossary/ Index
  XLXSWorkbook: Excel Magic 7: Creating Excel Charts like a PRO
REVIEW AND TEST
  quizREVIEW QUESTIONS
 examFINAL EXAM