Microsoft Excel: Visualizing Data with Charts [2010]

Microsoft Excel Training Series | Level 2

Course Details

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

Register for this training course.

Course Overview

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 info@avantixlearning.ca 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

Course Topics

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

Sparklines

  • 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 2024 Avantix® Learning

Microsoft Excel charting training course in Toronto.

You may like

How to Insert or Type U with an Accent Mark in PowerPoint (Ù, Ú, Û, Ü, ù, ú, û, or ü)

How to Insert or Type U with an Accent Mark in PowerPoint (Ù, Ú, Û, Ü, ù, ú, û, or ü)

You can insert or type u with an accent mark in PowerPoint using built-in tools or keyboard shortcuts (including Alt code shortcuts). The letter u can be inserted with an accent in both upper or lower case. The following are common accented characters that you can insert or type in PowerPoint in upper or lower case: grave (Ù or ù), acute (Ú or ú), circumflex (Û or û) and umlaut (Ü or ü).

How to Insert or Type O with an Accent Mark in PowerPoint (Ò, Ó, Ô, Õ, Ö, ò, ó, ô, õ or ö)

How to Insert or Type O with an Accent Mark in PowerPoint (Ò, Ó, Ô, Õ, Ö, ò, ó, ô, õ or ö)

You can insert or type o with an accent mark in PowerPoint using built-in tools or keyboard shortcuts (including Alt code shortcuts). The letter o can be inserted with an accent in both upper or lower case. The following are common accented characters that you can insert or type in PowerPoint in upper or lower case: grave (Ò or ò), acute (Ó or ó), circumflex (Ô or ô), tilde (Õ or õ) and umlaut (Ö or ö).

How to Replace Zeros (0) with Blanks in Excel

How to Replace Zeros (0) with Blanks in Excel

There are several strategies to replace zero values (0) with blanks in Excel. If you want to replace zero values in cells with blanks, you can use the Replace command or write a formula to return blanks. However, if you simply want to display blanks instead of zeros, you have two formatting options – create a custom number format or a conditional format.

You may also like

How to Insert or Type I with an Accent Mark in Word (Í, í, Ì, ì, Î, î, Ï, or ï)

How to Insert or Type I with an Accent Mark in Word (Í, í, Ì, ì, Î, î, Ï, or ï)

You can insert or type i with an accent mark in Word using built-in tools or keyboard shortcuts (including Alt code shortcuts). The letter i can be inserted with an accent in both upper or lower case. The following are common accented characters that you can insert or type in Word in upper or lower case: grave (Ì or ì), acute (Í or í), circumflex (Πor î) and umlaut (Ï or ï).

How to Insert or Type A with an Accent Mark in Word (À, Á, Â, Ä, à, á, â, or ä)

How to Insert or Type A with an Accent Mark in Word (À, Á, Â, Ä, à, á, â, or ä)

You can insert or type a with an accent mark in Word using built-in tools or keyboard shortcuts (including Alt code shortcuts). The letter a can be inserted with an accent in both upper or lower case. The following are common accented characters that you can insert or type in Word in upper or lower case: grave (À or à), acute (Á or á), circumflex ( or â) and umlaut (Ä or ä).

10 Word Shortcuts to Select Text Using a Keyboard

10 Word Shortcuts to Select Text Using a Keyboard

You can use several shortcuts in Word to select text in your documents using only your keyboard. When you select text, it will typically be highlighted in grey. After you select text, you can cut, copy, or delete the selected text or apply character or paragraph formatting.

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 | info@avantixlearning.ca

Upcoming Training
Course
Microsoft Excel: Visualizing Data with Charts [2010] (Toronto course)
Location
Avantix Learning, 1 Yonge Street, Sutie 1801 (Toronto Star Building),Toronto, Ontario, Canada,
Next course starts
June 27, 2018
Next course ends
June 27, 2018

Pin It on Pinterest