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: March 15, 2024
6 Reviews (37 ratings)

Reviews

5
Anonymous Author
This course provided a lot of helpful information on creating charts. There were several charts discussed that I was not aware of. I even learned you can create charts from pivot tables. Overall, very good course. I look forward to taking more of the Excel Magic courses.
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.
5
Member's Profile
Great content. Appreciate how each item was explained first and then walked through. Really helped solidify understanding.
5
Anonymous Author
Appreciated the examples used for the course and a great refresher on excel charts.
5
Anonymous Author
Great course. The author demonstrates rare charts that may come in handy
Prerequisites
Course Complexity: Foundational

Basic Excel knowledge
Example: be able to open one Excel file and connect to external data files, etc.
It is recommended to take other Excel Magic series courses by Lenny Wu.
Excel Magic 1: Building Dynamic Formulas
Excel Magic 2: Building Your Report Generation "Bot"
Excel Magic 3: Automating Data Entry with Data Feeds
Excel Magic 4: Ultimate API Reporting in Excel
Excel Magic 5: Building Interactive Budgeting Model in Excel
Excel Magic 6: Excel's 7 Languages
Excel Magic 7: Creating Excel Charts like a PRO
Excel Magic 8: Transforming a Pro-forma into a Dashboard
Excel Magic 9: Building a Project Tracking “Gantt” Chart

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 .
Instructor for this course
  Course Overview CPE
Course Syllabus
INTRODUCTION AND OVERVIEW
  Introduction to Excel Magic 7: Creating Excel Charts like a PRO0:42
  Data Visualization2:08
  Hidden Powers of Excel Charts1:26
  Instructor Introduction1:15
  How this course is compared with “other similar courses”?1:28
  What you will get from this course?0:32
4 Basic Excel Charts
  4 Basic Excel Charts (Part 1)1:35
  4 Basic Excel Charts (Part 2)4:06
  4 Basic Excel Charts (Part 3)4:49
  4 Basic Excel Charts (Part 4)3:37
  4 Basic Excel Charts (Part 5)5:39
Intermediate Excel Charting Techniques
  6 Intermediate Excel Charting Techniques (Part 1)3:28
  6 Intermediate Excel Charting Techniques (Part 2)1:50
  6 Intermediate Excel Charting Techniques (Part 3)2:55
  6 Intermediate Excel Charting Techniques (Part 4)4:14
  6 Intermediate Excel Charting Techniques (Part 5)2:53
  6 Intermediate Excel Charting Techniques (Part 6)5:01
3 Powerful Excel Charts that Are Rarely Used
  3 Powerful Excel Charts that Are Rarely Used (Part 1)2:55
  3 Powerful Excel Charts that Are Rarely Used (Part 2)4:13
  3 Powerful Excel Charts that Are Rarely Used (Part 3)4:44
  3 Powerful Excel Charts that Are Rarely Used (Part 4)3:18
  3 Powerful Excel Charts that Are Rarely Used (Part 5)3:57
  3 Powerful Excel Charts that Are Rarely Used (Part 6)1:21
4 Excel Chart Best Practices
  4 Excel Chart Best Practices (Part 1)1:13
  4 Excel Charts Best Practices (Part 2)1:19
  4 Excel Chart Best Practices (Part 3)1:32
  4 Excel Chart Best Practices (Part 4)2:00
Conclusion
  Takeaways1:32
  Q & A0:31
CONTINUOUS PLAY
  Excel Magic 7: Creating Excel Charts like a PRO1:16:13
SUPPORTING MATERIAL
  Slide: Excel Magic 7: Creating Excel Charts like a PROPDF
  Excel Magic 7: Creating Excel Charts like a PRO Glossary/ IndexPDF
  Workbook: Excel Magic 7: Creating Excel Charts like a PROXLXS
REVIEW AND TEST
  REVIEW QUESTIONSquiz
 FINAL EXAMexam