Microsoft Excel: Introduction to Data Visualization with Charts
Microsoft Excel Training Series | Level 2
Course Details
Duration: 1/2 day (am)
Microsoft® Excel® Versions: 2016 | 2019 | 365 (Windows)
Delivery Methods: Instructor-led classroom (ILC) | Virtual classroom (VC) on request
Course Dates: April 13, 2020 (am) | View schedule 
Course Fee: $175 CDN per person + HST (bring your own device) or $225 CDN per person + HST (Avantix Learning provides device)*
Note: Public scheduled dates for this course are delivered as live instructor-led classroom training.
Course Overview
This instructor-led Excel course is designed for the user who wants to take advantage of the various types of charts in Excel 2016 and later versions. Students will learn to select contiguous and non-contiguous areas and to generate charts from data. Students will format charts using different charting tools. A variety of charts available in Excel 2016 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)
- Certificate of completion
- Follow-up email support
Course Topics
Using Excel Buttons and Themes
- Adding chart related buttons to the Quick Access Toolbar
- Applying themes to format charts consistently
Generating Charts from Data
- Selecting different types of source data
- Inserting embedded charts or charts sheets
- Moving charts to a worksheet or a chart sheet
- Generating charts with keyboard shortcuts
- Selecting a chart type
- Changing the chart type
- Using recommended chart types
- Adding alternative text to charts
Working with Source Data
- Editing source data
- Adding new data to the source
- Creating a dynamic data source
Applying Formatting to Charts
- Selecting elements in a chart
- Adding elements to a chart
- Applying chart styles and styles
- Resetting a chart
- Adding a trend line to a chart
Saving Time with Chart Templates
- Saving custom chart templates
- Applying a custom chart template
Using New Chart Types
- Creating Treemap charts
- Inserting Sunburst charts
- Generating Waterfall charts
- Creating Histogram charts
- Designing Pareto charts
- Inserting Box and Whisker charts
Inserting Sparkline Charts
- Displaying trends using in-cell charts called Sparklines
- Formatting Sparklines
Creating Timelines
- Presenting timelines with timeline charts
Charts and Word or PowerPoint
- 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 2022 Avantix® Learning
On-site training
Register now for a public scheduled course or contact us to discuss 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 Excel: Introduction to Power Query to Get and Transform Data
Microsoft Excel: Introduction to Power Pivot and Data Modelling
You may like
How to Lock Cells in Excel (Protect Formulas and Data)
It's easy to lock and protect cells in Microsoft Excel to prevent users from changing data or formulas. This involves a two-step process …
How to Stop or Control Green Error Checking Markers in Excel
In Microsoft Excel, errors are flagged with small green marker or triangle in the upper left corner of the cell. However, these indicators display when there may be an error but is, in fact, not an error.
How to Password Protect Your Excel Worksheets and Workbooks
You can password protect worksheets and workbooks in Excel. If you want to prevent other users from opening or modifying an Excel workbook, you can encrypt the file with a password. You can also protect workbook structure where you can prevent users from deleting, renaming, moving or unhiding worksheets. Password protection can be added to your Excel file in several ways.
You may also like
4 Ways to Delete a Table in Word
You can delete a table in a Word document in 4 simple ways – using the Ribbon, using the context menu, using the Backspace key or by selecting a paragraph and a table and pressing Delete.
How to Make Columns in Word
You can make columns in Word documents in a few different ways. There are two types of columns you can create – newspaper-style columns where the text flows from column to column or tables with columns and rows. You can create documents that contain two, three or more columns. In this article, we'll review how to set up newspaper-style columns. If you want to create a table, check out How to Create a Table in Word (4 Ways).
4 Ways to Create a Table in Word
You can create a table in a Word document in 4 easy ways using the Ribbon. A table is a grid made up of columns and rows that intersect to form cells. You can insert text, numbers and images in a table. Once you have inserted a table, you can easily add and resize columns and rows and change table 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