Ultimate Excel Course #8 - Excel Charts for Simple and Effective Data Presentation

Alan Murray, IT Trainer, Coffee Lover and Lifelong learner

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
12 Lessons (1h 10m)
    • 1. Introduction

      3:02
    • 2. Charts Introduction - Creating your First Charts

      7:36
    • 3. Adding and Removing Chart Elements

      5:23
    • 4. Formatting Charts

      6:42
    • 5. Modify the Chart Axis

      7:22
    • 6. Save Time with Chart Templates

      4:36
    • 7. Combo Charts - Two Chart Types in One Chart

      6:20
    • 8. Using Chart Filters

      2:28
    • 9. Interactive Charts – Change Chart Data with a Drop Down List

      8:03
    • 10. Using Cell Values for Chart Labels

      4:27
    • 11. Automatically Change Colour of Key Chart Values

      7:57
    • 12. Using Sparklines for Quick Data Insights

      6:03

About This Class

f16d37e6

This class is #8 in a series called the Ultimate Excel Course.

In this class you will learn to use charts to present data effectively.

In this class we start with an introduction to creating charts and some of the fundamentals that you need to know.

We then explore some simple changes that can make a great impact on your charts. And then save these as a chart template so that next time, the process is done and just a few clicks.

It is then time for some more advanced features such as using cell values for labels and adding interactivity to the chart. We first explore settings that are built into the charts in Excel.

Then we utilise some of our skills from previous classes in this course the make the chart dynamic. We set up a drop down list, and the user selection from the list changes the data presented by the chart.

We also look at how to automatically change the colour of key values in the chart to bring them to user attention. A Conditional Formatting for charts.

Finally we see Sparklines. This feature is great for quick insights that do not monopolise the paces of your dashboard or report..

The Excel files used during the class are provided so that you can follow along. You can then take on the project exercises to test your skills in action.

Please post any questions in the discussion area and I will get back to you.

Grab a coffee, enroll and let's do this.

Please note that this is class #8 in a series called the Ultimate Excel Course.

You can find direct links to the other classes in the series below.

Class #1 - Excel Formulas Made Easy - Get up to Speed with Excel Formulas Fast

Class #2 - Essential Skills for Working with Large Spreadsheets

Class #3 - Logical Functions - The Decision Making Formulas of Excel

Class #4 - Conditional Formatting: Make your Data Come to Life

Class #5 - Lookup Functions - The Powerful VLOOKUP Functions and Beyond

Class #6 - Validating and Protecting Excel Data

Class #7 - Advanced Formulas for Analysing Data

Class #8 - Excel Charts for Simple and Effective Data Presentation

Class #9 - Cleaning and Preparing Data Ready for Analysis

Class #10 - Formatting your Data Ranges as Tables for Superior Management

Class #11 - Master PivotTables for Powerful Analysis and Reporting

Class #12 - Get & Transform Data with Power Query

Class #13 - Introduction to the Data Model and PowerPivot