Excel Charting
- 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 .
- Face-to-Face and Online Instructor led .
- And more... .
Upcoming start dates
Choose between 44 start dates
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
Customer Outreach Award
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.7
Based on 56 reviews.
Write a review!
Reviews are published according to our review policy.
Fiona
01 Mar 2024
Martin was excellent and very helpful. He had a great curriculum and practice workbook set up which was very easy to follow along and proceeded at a logical and manageable pace.
Alison
09 Dec 2019
Great course; thanks
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...
Ads
Martin was a great teacher; the course was really helpful and it covered everything that I wanted. He didn't bothered any questions from me and also introduced further courses t...