Excel Charting

STL
4.2
13 reviews
  • An eager teacher that knows Microsoft Excel as well as loves Microsoft Excel made what could have been a dull course energizing and moving. Bunches of valuable tips and traps that can be utilized everyday (so invigorating).
    |
  • Entire tutelage was great. Best Excel instruction from where I undertook. Coach clarified things legitimately, great space, not very fast or moderate.
    |
  • Undertook the Excel Intermediate preparing with partners from my association. The coach adopted an adaptable strategy to the course conveyance by guaranteeing that everybody was at a comparative level toward the start of the day, and organizing the key points of the syllabus everyone needed to invest the most energy in. The course was brilliant worth for cash, with great offices inclusive of lunch given in a neighborhood eatery. I would have no delay in utilizing this organization again as a part without bounds.
    |

Course

In London

£ 201-500

Description

  • Start date

    Different dates available

Rated excellent on Trustpilot!

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

This course is also offered as inhouse. STL may go to your premises or you can visit our venue in London.

Facilities

Location

Start date

London
See map
12 Bloomsbury Square, WC1A 2LP

Start date

Different dates availableEnrolment now open
London
See map
2nd Floor, Cruising Association House 1 Northey Street, E14 8BT

Start date

Different dates availableEnrolment now open

About this course

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 & types.

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

Attendance of Excel Introduction or equivalent experience.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

4.2
fantastic
  • An eager teacher that knows Microsoft Excel as well as loves Microsoft Excel made what could have been a dull course energizing and moving. Bunches of valuable tips and traps that can be utilized everyday (so invigorating).
    |
  • Entire tutelage was great. Best Excel instruction from where I undertook. Coach clarified things legitimately, great space, not very fast or moderate.
    |
  • Undertook the Excel Intermediate preparing with partners from my association. The coach adopted an adaptable strategy to the course conveyance by guaranteeing that everybody was at a comparative level toward the start of the day, and organizing the key points of the syllabus everyone needed to invest the most energy in. The course was brilliant worth for cash, with great offices inclusive of lunch given in a neighborhood eatery. I would have no delay in utilizing this organization again as a part without bounds.
    |
100%
4.3
fantastic

Course rating

Recommended

Centre rating

Hannah-Jane

3.5
04/08/2016
What I would highlight: An eager teacher that knows Microsoft Excel as well as loves Microsoft Excel made what could have been a dull course energizing and moving. Bunches of valuable tips and traps that can be utilized everyday (so invigorating).
What could be improved: Nothing.
Would you recommend this course?: Yes

Anonymous

4.0
30/07/2016
What I would highlight: Entire tutelage was great. Best Excel instruction from where I undertook. Coach clarified things legitimately, great space, not very fast or moderate.
What could be improved: Nothing bad.
Would you recommend this course?: Yes

Graham Clarke

4.5
22/04/2016
What I would highlight: Undertook the Excel Intermediate preparing with partners from my association. The coach adopted an adaptable strategy to the course conveyance by guaranteeing that everybody was at a comparative level toward the start of the day, and organizing the key points of the syllabus everyone needed to invest the most energy in. The course was brilliant worth for cash, with great offices inclusive of lunch given in a neighborhood eatery. I would have no delay in utilizing this organization again as a part without bounds.
What could be improved: Everything OK.
Would you recommend this course?: Yes

Alan

3.0
17/04/2016
What I would highlight: My utilization of Excel has especially been constrained by the little measure of information and absence of committed preparing. Once demonstrated new abilities I recall that them and embrace them. The scope of new aptitudes I adapted just by going to the one day workshop was enormous, both professional and individual related. Prescribed.
What could be improved: No negative aspects.
Would you recommend this course?: Yes

Andy

5.0
15/04/2016
What I would highlight: As a client of Microsoft Excel for around 20 years, I was at first suspicious about the benefit of going to this Intermediate Skills course. It rapidly got to be distinctly evident that I had not been finishing a few undertakings in the most proficient way and I am satisfied to state I learned an incredible arrangement. The course was conveyed at a quick yet reasonable pace and the mentor was receptive and supportive. Glad to prescribe to anybody :- )
What could be improved: Nothing.
Would you recommend this course?: Yes
See all
*All reviews collected by Emagister & iAgora have been verified

This centre's achievements

2017

All courses are up to date

The average rating is higher than 3.7

More than 50 reviews in the last 12 months

This centre has featured on Emagister for 7 years

Subjects

  • Excel
  • MS Excel
  • Excel Charting
  • Chart elements
  • Gridlines
  • Ribbon
  • Design
  • Layout
  • Creating Basic Charts
  • Format Options
  • WordArt
  • Printing
  • Chart's Data Source

Course programme

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

Additional information

We include hot restaurant lunch in all training courses. In addition to that, our courses are never cancelled.

Excel Charting

£ 201-500