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 2021 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 Replace Spaces in Excel with Underscores (_), Dashes (-) or Other Values
You can quickly replace blank cells in Excel with zeros, dashes or other number or text values (0, -, N/A, Null or other text). It’s useful to fill blank cells with a number, symbol or value if you want to use the data set as the source for a pivot table or use other data analysis tools.
How to Convert Pounds to Kilograms or Kilograms to Pounds in Excel (kg to lb)
You can convert pounds to kilograms (lb to kg) or kilograms to pounds using formulas with operators or functions in Excel.
3 Excel Strikethrough Shortcuts to Cross Out Text or Values in Cells
You can apply strikethrough to text or values in Excel to cross out or create a line through a cell or part of a cell. There are 3 common ways to apply strikethrough in your Excel worksheets – using a built-in keyboard shortcut, using the Font dialog box, or by adding a command to the Quick Access Toolbar.
You may also like
How to Cut a Shape Out of an Image in PowerPoint (Cookie Cutter Trick)
Starting in Microsoft PowerPoint 2013, you can use the Merge Shapes tool to crop an image to a circle. You can use either Intersect or Subtract to cut out a circle (or other shape) from a picture.
5 PowerPoint Keyboard Shortcuts to Start a Slide Show
The outline has been an integral part of Microsoft PowerPoint for many years. It is dynamically linked to slide placeholders and is organized in a hierarchical way.
How to Stop Word from Changing Formatting Automatically
You can stop Word from changing formatting automatically in your documents by turning off AutoFormat As You Type settings in the AutoCorrect dialog box. If text or formatting is changing, there are several options you can turn off.
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