Excel Charting
-
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
Description
-
Type
Course
-
Location
-
Start date
Different dates available
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
Start date
Start date
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.
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 rating
Recommended
Centre rating
Hannah-Jane
Anonymous
Graham Clarke
Alan
Andy
This centre's achievements
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
Excel Charting