Excel Charting Specialist

Look at the in depth features of charts and some specialist tools to make your charts come to life.

Course overview

Duration: 1 day (6.5 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.

Objectives 

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

  • 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

Content

Creating and amending charts 
  • Creating Simple Charts
  • Using the Chart Design tab
  • Adding Chart Elements
  • Changing the type of Chart
Formatting charts  
  • Format Chart Area
  • Format Data Series
  • Format Data Point
  • Format Axis
Working with combo charts 
  • Adding additional data to a Chart
  • Customising Chart types
  • Creating Clustered Column/line Charts
Applying conditional formatting on charts 
  • Using IF Statements
  • Highlighting Max/Min Data points in Charts
  • Using Series Overlap
Dynamic charts 
  • Creating dynamic Target vs Actual Charts
  • Introducing the NA function
  • Hiding data used for Charts
Custom formatting charts 
  • Formatting Data Labels
  • Customising number formats
  • Using Trend Arrows to show changes
  • Editing Format Code
Advanced dynamic charts
  • Pivot Chart rules
  • Creating a Pivot Chart
  • Working with your Pivot Chart
Creating calculations
  • Combining all elements to create an Advanced Chart
  • Using Error Bars to create a line
  • Adding a scroll bar and linking with data

Discover more about our courses

Public Training Programme

Explore our current selection of public courses, available as convenient and cost-effective virtual sessions.

Engage with expert instructors and a diverse peer group in an interactive, online learning environment.

Ideal for those valuing flexibility and affordability, our public courses are ideal where you only have small numbers requiring training and offer training from the comfort of your home or office.

Check public dates

View our full catalogue of Leadership, Personal Development, Systems, Office Applications and Project Management courses

View our Leadership and Personal Development course catalogue
View our Systems and Office Applications course catalogue
View our Project Management course catalogue

Get in touch

Contact us

Do you have questions, suggestions, or feedback? We value your input and are here to assist you. Please don't hesitate to get in touch with us via email or phone:

Our dedicated team is ready to respond to your enquiries and provide the support you need. Feel free to reach out, and we'll do our best to assist you.

Thank you for visiting our website, and we look forward to hearing from you!