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.
- 1. Making the Move from Excel to Cloud Based Budgeting
- 2. PivotTable Essentials
- 3. Excel Magic 9: Building a Project Tracking “Gantt” Chart
- 4. Excel Efficiency: Spreadsheet Auditing Part 2
- 5. Excel Efficiency: Introduction to Lookup Functions
- 6. Advanced Spreadsheet Techniques in Microsoft Excel
- 7. Excel Efficiency: Tips and Tricks Part 2
- 8. Excel Efficiency: Filtering Data
- 9. Automating Financial Reporting in EXCEL (Part III): Fully-Integrated Annual Filing, Board Book, and Board Deck
- 10. Create Dynamic and Interactive Charts (Text Based Course)
4 Reviews (32 ratings)
Reviews
Prerequisites
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