Excel Yourself/Excel Chart Hacks

Excel Chart Hacks

This session will show you how to achieve improved charts and how to create charts that aren’t built-in to Excel.

Topics covered:
  • using text boxes with charts
  • improving Excel’s default charts – before and after charts
  • Variance chart
  • High – Low Chart (column and line)
  • Conditional colours in a chart
  • Waterfall/Bridge chart
  • Adding banding to a chart
  • handling expanding data ranges
As always, I will share a few general tips along the way.

Level: Intermediate
Duration: 1 hour
Price: AU$25

  • $25

Excel Chart Hacks

Learn how to create non-standard charts in Excel.

Contents

Course materials

The session materials
  • a pdf manual which you can print out and make notes in
  • Excel file to work through during the session
  • the completed file to review if you need to
Excel Charting Hacks 2020.pdf
Chart Hacks 2020.xlsx
Chart Hacks 2020 Complete.xlsx

Course Video recording

Excel Hacks.mp4

Quizzes

Quiz Part One
Quiz Part Two