Professional Training
4.6 (54 Reviews)

Excel Charting

STL, In London (+21 locations)
Length
1 day
Price
0 GBP excl. VAT
Next course start
1 March, 2024 (+42 start dates)
Course delivery
Classroom, Virtual Classroom
Length
1 day
Price
0 GBP excl. VAT
Next course start
1 March, 2024 (+42 start dates)
Course delivery
Classroom, Virtual Classroom
Leave your details so the provider can get in touch

Excel Charting

STL courses


  • At the end of this course you will have a greater understanding of charting concepts, shortcuts and fine tuning.

    You will learn more advanced techniques for chart layout tabs and chart formatting options and types.

    Armed with all of this you will have greater competence at producing more comprehensive Excel charts based on your working data.

    Also, learning VBA may be a good option for you!

What to expect

  • Courses never cancelled .
  • Restaurant lunch .
  • Last minute rescheduling .
  • 24 month delegate support forum .
  • And more... .

Upcoming start dates

Choose between 42 start dates

1 March, 2024

  • Virtual Classroom
  • Online
  • English

3 May, 2024

  • Classroom
  • London
  • English

31 May, 2024

  • Virtual Classroom
  • Online
  • English

18 June, 2024

  • Classroom
  • London
  • English

16 July, 2024

  • Virtual Classroom
  • Online
  • English

2 August, 2024

  • Classroom
  • London
  • English

30 August, 2024

  • Virtual Classroom
  • Online
  • English

17 September, 2024

  • Classroom
  • London
  • English

15 October, 2024

  • Virtual Classroom
  • Online
  • English

1 November, 2024

  • Classroom
  • London
  • English

29 November, 2024

  • Virtual Classroom
  • Online
  • English

17 December, 2024

  • Classroom
  • London
  • English

14 January, 2025

  • Virtual Classroom
  • Online
  • English

31 January, 2025

  • Classroom
  • London
  • English

28 February, 2025

  • Virtual Classroom
  • Online
  • English

18 March, 2025

  • Classroom
  • London
  • English

15 April, 2025

  • Virtual Classroom
  • Online
  • English

29 April, 2025

  • Classroom
  • London
  • English

30 May, 2025

  • Virtual Classroom
  • Online
  • English

Enquire for more information

  • Classroom
  • Aberdeen
  • English

Enquire for more information

  • Classroom
  • Bedford
  • English

Enquire for more information

  • Classroom
  • Belfast
  • English

Enquire for more information

  • Classroom
  • Birmingham
  • English

Enquire for more information

  • Classroom
  • Bristol
  • English

Enquire for more information

  • Classroom
  • Burnley
  • English

Enquire for more information

  • Classroom
  • Cardiff
  • English

Enquire for more information

  • Classroom
  • Edinburgh
  • English

Enquire for more information

  • Classroom
  • Edinburgh
  • English

Enquire for more information

  • Classroom
  • Glasgow
  • English

Enquire for more information

  • Classroom
  • Leeds
  • English

Enquire for more information

  • Classroom
  • Leicester
  • English

Enquire for more information

  • Classroom
  • Liverpool
  • English

Enquire for more information

  • Classroom
  • London
  • English

Enquire for more information

  • Classroom
  • Manchester
  • English

Enquire for more information

  • Classroom
  • Newport
  • English

Enquire for more information

  • Classroom
  • Nottingham
  • English

Enquire for more information

  • Classroom
  • Portsmouth
  • English

Enquire for more information

  • Classroom
  • Sheffield
  • English

Enquire for more information

  • Classroom
  • Southampton
  • English

Enquire for more information

  • Classroom
  • Sunderland
  • English

Enquire for more information

  • Classroom
  • Wolverhampton
  • English

Enquire for more information

  • Virtual Classroom
  • Online
  • English

Suitability - Who should attend?



Our Charting with Microsoft Excel course is suitable for those with a working knowledge of Excel and familiarity of charts.

Training Course Content



Excel Charting Concepts

Understanding chart terminology
- Identifying chart elements (such as like plot area, chart area, gridlines, and legends)
- Selecting the right chart type
- Understanding the Ribbon and the Design, Layout, and Format tabs

Creating Basic Charts Quickly

- Selecting data to display as a chart
- Creating charts instantly with shortcuts
- Creating presentation-ready charts with just a few adjustments
- Creating graphic-in-cell charts with Sparklines

Fine-Tuning Charts with Design Tab Choices

- Switching rows and columns for a different view of the data
- Setting a default chart type and creating a template
- Dealing with empty and hidden cells
- Choosing a chart style from 48 colourful variations
- Changing the location of a chart
- Moving and resizing a chart

Layout Tab Options

Inserting Pictures, Shapes, and Text Boxes
- Using pictures as chart elements
- Adding shapes and arrows
- Adding floating text and text boxes
Adding Titles, Labels, and Legends
- Adding and editing chart titles
- Adding horizontal and vertical titles
- Linking titles to content
- Showing different scales
- Specifying the position of tick marks and axis labels
- Changing the numeric format on labels
- Adding, editing, and removing legends
- Adding and editing data labels
- Showing the source of a chart's data
Using Axes and Gridlines
- Modifying axis scaling
- Working with gridlines
Using the Analysis Tools
- Analyzing existing and future data with trendlines
- Adding drop lines
- Adding high-low lines and up-down bars
- Adding error bars

Format Options

Adding Shapes and WordArt Styles
- Selecting shape fill and outline
- Adding shape effects
- Applying WordArt styles
Using Other Formatting Tools
- Formatting lines and borders
- Filling an area with a colour gradient
- Specifying line style and weight
- Working with chart text
- Changing the rotation of chart text

Adjusting Specific Chart Types

- Column, line and pie charts
- Area, stock, and XY charts
- Doughnut, bubble, and radar charts
- Creating a Waterfall chart

Changing a Chart's Data Source

-Pasting new data into a chart
-Creating charts from multiple data sources
-Adding new data using a table

Printing and Sharing Charts

- Printing charts
- Copying and linking charts with Word and PowerPoint

Expenses



List price £350, promotional rates available. STL are the only company to offer a dynamic pricing and availability model, updated live on our site, daily on this portal. Closed group training options available (at your offices, UK wide/International or our London Venues). Contact us below.

Request information - obligation free

Contact course provider

Fill out your details to find out more about Excel Charting.

  Contact the provider

  Get more information

  Register your interest

Country *

reCAPTCHA logo This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Customer Outreach Award

customer-outreach-badge-2019

We believe that it should be easy for you to find and compare training courses. 

Our Customer Outreach Award is presented to trusted providers who are excellent at responding to enquiries, making your search quicker, more efficient and easier, too.

Reviews by course attendees

Average rating 4.6

Based on 54 reviews.
Write a review!
5/5
Alison
09 Dec 2019

Great course; thanks

5/5
Jools
09 Dec 2019

Most useful topic: Pivot tables

5/5
Julie
09 Dec 2019

Perhaps the files could have been emailed earlier in the week to avoid any problems on the day; otherwise really enjoyed the course; thanks very much. Kind regards

STL
1 Northey Street, 2nd Floor, CA House
E14 8BT London

STL

Helping businesses improve performance with proven learning and development solutions. London-based with a global reach. STL seek to provide an unrivalled value and quality service, enabled by our strong working culture. Our 500+ courses deliver learning solutions across leadership and...

Read more and show all courses with this provider

Ads