Microsoft Excel: Visualizing Data with Charts 
Microsoft Excel Training Series | Level 2
Duration: 1/2 day
Microsoft® Excel® Versions: 2010
Delivery Methods: Instructor-led classroom (ILC) | Virtual classroom (VC) on request
Course Dates: June 27, 2018 (am) | View schedule
Course Fee: $185 CDN per person + HST or BYOD (bring your own device): $145 CDN person + HST*
Note: Public scheduled dates for this course are delivered as live instructor-led classroom training.
This hands-on course is designed for the user who wants to create and format many different types of charts in Excel 2010. Students will learn to select contiguous and non-contiguous areas and to generate charts from data. Many different types of charts will be created using different strategies. Throughout this course, the instructor will include numerous tips, tricks and shortcuts.
Prerequisite: Microsoft Excel: Introduction or equivalent knowledge and skills.
Custom training: This course may be delivered at your site or ours as an instructor-led or virtual classroom solution. Contact us at email@example.com for more information including savings for custom group training.
Related training: View all Microsoft Excel courses >
INCLUDED IN THIS COURSE
- Comprehensive course manual
- Keyboard shortcuts quick reference
- Sample and exercise files
- Refreshments (for classes conducted in Avantix Learning classrooms)
- Follow-up email support
Microsoft Excel Tools
- Customizing the Quick Access Toolbar with chart tools
- Applying themes to automate formatting of charts
Creating Charts in Excel 2010
- Selecting contiguous and non-contiguous source data
- Inserting charts on a worksheet or on a new chart sheet
- Moving charts to a worksheet or a chart sheet
- Using a keyboard shortcut to create a chart
- Choosing a chart type
- Changing the chart type
- Formatting using the chart formatting dialog box
- Adding alternative text
Managing Source Data
- Editing data
- Adding data to the source
- Making the source dynamic
- Breaking the connection to source data
Formatting Charts in Excel 2010
- Selecting elements in a chart
- Using chart formats to improve the appearance of your charts
- Applying different types of formatting to chart elements
- Resetting a chart’s formats
- Adding chart elements such as chart titles and axis titles
- Adding trendlines
Saving and Using Chart Templates
- Saving time by creating chart templates
- Applying a chart template
- Customizing the Quick Access toolbar
Creating and Formatting Pie Charts
- Different types of pie charts
- Issues with data sources for pie charts
- Using the Pie of Pie chart or Bar of Pie chart
Other Types of Charts
- Creating combination charts
- Designing Pareto charts
- Creating waterfall charts
- Presenting timelines with timeline charts
- Displaying trends using miniature charts in cells called Sparklines
- Formatting Sparklines
Charts and Other Office Programs
- Copying a chart to Word or PowerPoint
- Linking to Excel charts in Word or PowerPoint
Register Now for a public course at our downtown Toronto location at 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada.
Do you need more information? Contact us!
To request this page in an alternate format, contact our staff.
*Prices subject to change.
Copyright 2019 Avantix® Learning Inc.
You may like
You can easily show or hide formulas in a number of ways in Microsoft Excel. You can use a keyboard shortcut, click a button and even use a formula to show formulas …
You can achieve some interesting effects by cropping images to shapes in PowerPoint. However, if you want to crop an image to a circle, you’ll need to combine cropping options.
If you want to extract all images (or even just one or two) from a Microsoft PowerPoint deck to use in another presentation, there are a couple of ways to extract images …
You may also like
You can highlight values in fields or records in Microsoft Access reports using conditional formatting. Certain conditions must be met in order for the formatting to be applied …
You can insert lines in Microsoft Word by drawing lines or by using borders. In this article, we’ll teach your how to insert or delete lines created with paragraph borders.
There are a few ways to keep a Microsoft Word row or table together on one page. The method you use depends on several factors including the size of the table …
Microsoft, the Microsoft logo, Microsoft Office and related Microsoft applications and logos are registered trademarks of Microsoft Corporation in Canada, US and other countries. All other trademarks are the property of the registered owners.
Avantix Learning | 1 Yonge Street, Suite 1801 (Toronto Star Building), Toronto, Ontario, Canada M5E 1W7 | firstname.lastname@example.org