Skip to content
Underscore Logo Underscore Logo Underscore Logo
  • HOME
  • ABOUT
  • SERVICES
    • Consultancy
    • Resourcing
      • Clients
        • Integrated Project Resourcing
      • Associates
    • Talent Development
      • Training Courses
      • Public Training Programme
      • L&D Consultancy
      • Bespoke Programmes
      • Psychometrics
  • INSIGHTS
    • Blog
    • White Papers
    • Podcast
    • Case Studies
  • CONTACT US
  • HOME
  • ABOUT
  • SERVICES
    • Consultancy
    • Resourcing
      • Clients
        • Integrated Project Resourcing
      • Associates
    • Talent Development
      • Training Courses
      • Public Training Programme
      • L&D Consultancy
      • Bespoke Programmes
      • Psychometrics
  • INSIGHTS
    • Blog
    • White Papers
    • Podcast
    • Case Studies
  • CONTACT US
  • HOME
  • ABOUT
  • SERVICES
    • Consultancy
    • Resourcing
      • Clients
        • Integrated Project Resourcing
      • Associates
    • Talent Development
      • Training Courses
      • Public Training Programme
      • L&D Consultancy
      • Bespoke Programmes
      • Psychometrics
  • INSIGHTS
    • Blog
    • White Papers
    • Podcast
    • Case Studies
  • CONTACT US

Excel – Charting Specialist

Excel – Charting SpecialistEleanor Bruce2023-02-23T11:42:46+00:00
  • Overview

  • Objectives

  • Content

  • Book

  • 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 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
  • 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

  • Combining all elements to create an Advanced Chart
  • Using Error Bars to create a line
  • Adding a scroll bar and linking with data
  • Book

Click here to view next available dates and complete booking request.

Please email training@underscore-group.com if you would like to discuss the course before booking or to discuss bespoke programme options.

Back to all courses
  • About
  • Contact Us
  • Privacy Notice
  • Insights and Resources
  • Talent Development
  • Resourcing

Get Social

Image of Underscore logo, consisting of the word underscore written in white text, with an orange underline, representing an underscore, the company name.
Page load link
This website uses cookies and third party services. Ok
Go to Top