Microsoft Excel: Visualizing Data with Charts [2013]
Microsoft Excel Training Series | Level 2
Course Details
Duration: 1/2 day
Microsoft® Excel® Versions: 2013
Delivery Methods: Instructor-led classroom (ILC) | Virtual classroom (VC) on request
Course Dates: December 28, 2018 (pm) | 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.
Course Overview
This hands-on course is designed for the user who wants to create and format many different types of charts in Excel 2013. 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 2013
- 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
- Working with changed Ribbon tabs
- Using the chart formatting task pane
- 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 2013
- 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 in Excel 2013
- 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
- Using Recommended Charts in 2013
- 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 2023 Avantix® Learning
On-site training
Register now for a public scheduled course or contact us to arrange custom on-site or off-site training options.
Related courses
Microsoft Excel: Intermediate / Advanced
Microsoft Excel: Data Analysis with Functions, Dashboards and What-If Analysis Tools
Microsoft Excel: Visual Basic for Applications (VBA) Macros | Introduction
Microsoft PowerPoint: Introduction
Microsoft Access: Introduction
You may like
What is Power Query in Excel?
Power Query in Excel is a powerful data transformation tool that allows you to import data from many different sources and then extract, clean, and transform the data. You will then be able to load the data into Excel or Power BI and perform further data analysis. With Power Query (also known as Get & Transform), you can set up a query once and then refresh it when new data is added. Power Query can import and clean millions of rows of data.
How to Freeze Rows in Excel (One or Multiple Rows)
You can freeze one or more rows in an Excel worksheet using the Freeze Panes command. If you freeze rows containing headings, the headings will appear when you scroll down. You can freeze columns as well so when you scroll to the right columns will be frozen.
How to Show or Hide Gridlines in Excel
You can remove or hide gridlines in Excel worksheets to simplify worksheet design. By default, gridlines are displayed but do not print. Gridlines are applied to entire worksheets or workbooks, not to specific cells. If you hide gridlines on one worksheet, it doesn't affect other sheets in the same workbook.
You may also like
How to Generate Random Text in Word
If you are creating a Microsoft Word document, template or mockup and you want to create placeholder text, you can generate random text using the built-in RAND function or LOREM function (which generates Latin or Lorem ipsum text).
How to Center Text Vertically in a Word Table (and Fix Common Issues)
You can center or align text vertically in cells in a Word table using commands in the Table Design or Table Tools Design tab in the Ribbon. If the text doesn't seem to align correctly, there are several common issues that may be affecting the alignment including extra blank paragraphs, paragraph spacing and cell margins.
How to Insert a Watermark in Word (like DRAFT)
You can insert a watermark in the background of one or more pages in a Microsoft Word document. Common watermarks are text such as DRAFT or CONFIDENTIAL but you can also add a picture watermark.
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