Instructor-led training - Microsoft Excel Training Course - Charting
Request a callback

We'll call during UK business hours

Name:
Number:
0207 987 3777

Microsoft Partner

Learning & Performance Institute - Accredited Training Provider

How to book

Live 12+ month schedule

On-site / Closed company:

60 second quote

Need help or advice?

Enter your name/number and we will call you back

We'll call during UK business hours

Name:
Number:

Excel Charting Training CourseExcel Charting Training Course

Excel 2007, 2010, 2013

Syllabus here

1 day from £225 List price £350

Instructor-led / Microsoft qualified trainers

Courses never cancelled: Guaranteed
Guarantee applies to Microsoft Desktop training and Management Skills Training.

Benefits

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.
Suitable for users of Excel 2013, 2010, 2007

900 Excel events in the next 12 months, live dates & pricing here


Who is this course for?

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

Prerequisites

Attendance of Excel Introduction or equivalent experience.

Benefits

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.

Course Syllabus

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

Excel Charting     1 day course

Onsite/Closed Quote    Introductory Discounts & Offers - Call now!   

Date Location Places
available
Book Next place rate (£) List
price
Pay by
Card
Pay by
Invoice
Mon 8 Dec 2014 Limehouse 7 Book now £258 £268£350
Thu 5 Feb 2015 Southwark 1 Book now £254 £264£350
Mon 23 Mar 2015 Southwark 8 Book now £350 £350£350
Fri 8 May 2015 Limehouse 7 Book now £231 £241£350
Mon 22 Jun 2015 Southwark 8 Book now £350 £350£350
Thu 6 Aug 2015 Bloomsbury 8 Book now £225 £235£350
Fri 9 Oct 2015 Bloomsbury 8 Book now £350 £350£350
Mon 14 Dec 2015 Limehouse 8 Book now £225 £235£350

What you get

Training room

Training is held in our modern, comfortable, air-conditioned suites

Modern-spec IT, fully networked with internet access

"What do I get on the day?"

Learning tools

Breaks and TimingsBreaks and timing

Courses start at 9:30am.
Please aim to be with us for 9:15am.
Joining information (how to get to our venues)

In-course handbookIn-course handbook

Contains unit objectives, exercises and space to write notes

RefreshmentsRefreshments

Available throughout the day:

  • Hot beverages
  • Clean, filtered water
  • Biscuits
Reference materialReference material

Available online. 100+ pages with step-by-step instructions

LunchLunch

Lunch is provided at a local restaurant or pub. Browse the sample menus:

24 months forum access24 months access to Microsoft trainers

Your questions answered by Microsoft qualified trainers online.

Training Formats & Services

Some reasons why thousands of businesses trust us

Transparent quality control
Live 12 month schedule/bookings
Courses never cancelled: Guaranteed
Guarantee applies to Microsoft Desktop training and Management Skills Training.
Reschedule in seconds
Industry leading pricing model
Online quote
24 months training support

Some of our clients:

London 2012 Special Olympics Great Britain BBC
13 delegates 19 delegates 17 delegates
92% would
recommend us
100% would
recommend us
100% would
recommend us
Ricoh Europe plc Transport for London UK Sport
12 delegates 35 delegates 29 delegates
100% would
recommend us
85% would
recommend us
100% would
recommend us
Virgin Media Television HSBC Al Jazeera International Ltd
19 delegates 106 delegates 17 delegates
100% would
recommend us
100% would
recommend us
100% would
recommend us
IOM National Lottery Commission Metropolitan Police
85 delegates 11 delegates 121 delegates
100% would
recommend us
100% would
recommend us
100% would
recommend us
City of Westminster Rabobank Swarovski
41 delegates 54 delegates 27 delegates
91% would
recommend us
100% would
recommend us
96% would
recommend us
British Sky Broadcasting Ltd Hilton Hotels Corporation Marriott International
14 delegates 27 delegates 29 delegates
100% would
recommend us
100% would
recommend us
95% would
recommend us
Lloyds Banking Group HM Treasury White Stuff
124 delegates 29 delegates 16 delegates
97% would
recommend us
100% would
recommend us
94% would
recommend us
Flight Centre The Roof Gardens DHL
33 delegates 18 delegates 42 delegates
97% would
recommend us
100% would
recommend us
94% would
recommend us

If you work with charts regularly and often wish that there was a faster or more efficient way of working - our Microsoft Excel Training Course - Charting will help you to create shortcuts and fine tune your charts.

Check our live schedule for the latest offers on training courses in your area.



Frontpage training London
Course rating:
5.0 stars - based on 56 reviews
Microsoft Certified Partner Institute of Leadership and Management - Certified Courses Learning and Performance Institute - Accredited Training Provider Security Seal verified by visa, mastercard securecard

Connect with us: Google+ · Facebook · Twitter · LinkedIn · Pinterest

2nd Floor, CA House, 1 Northey Street
Limehouse Basin, London, E14 8BT
United Kingdom