Excel – Charting Specialist

Duration: 1 day (6 hours)

Our Excel Charting Specialist course examines how to unlock the full potential of Charts in Excel. It investigates the useful tools needed for creating bespoke Charts, allowing you to creatively present data more visually.

By the end of the course, you will have an awareness of the tools used for creating more advanced Charts and will be able to create your own Dynamic Charts.

The course is designed for existing users of Excel who are looking at more advanced ways to visualise data in Excel using Charts.

By the end of the course you will be able to be:

  • Create and Amend Charts
  • Format multiple areas of a Chart
  • Use a Combo Chart
  • Apply Conditional Formatting to a Chart
  • Create Dynamic Charts
  • Work with Custom Formatting
  • Create an Advanced Dynamic Chart
  • Creating Simple Charts
  • Using the Chart Design tab
  • Adding Chart Elements
  • Changing the type of Chart
  • Format Chart Area
  • Format Data Series
  • Format Data Point
  • Format Axis
  • Adding additional data to a Chart
  • Customising Chart types
  • Creating Clustered Column/line Charts
  • Using IF Statements
  • Highlighting Max/Min Data points in Charts
  • Using Series Overlap
  • Creating dynamic Target vs Actual Charts
  • Introducing the NA function
  • Hiding data used for Charts
  • Formatting Data Labels
  • Customising number formats
  • Using Trend Arrows to show changes
  • Editing Format Code
  • Combining all elements to create an Advanced Chart
  • Using Error Bars to create a line
  • Adding a scroll bar and linking with data
Back to all courses