Microsoft Excel: Upgrading to Excel 2016

Microsoft Excel Training Series | Level 3

Course Details

Duration: 1 day

Microsoft® Excel® Version: 2016 | 365

Delivery Methods: Instructor-led classroom (ILC) | Virtual classroom (VC) on request

Course Dates: July 18, 2018 | View schedule Course schedule

Course Fee: $295 CDN per person + HST or BYOD (bring your own device): $245 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

During this hands-on course, explore exciting new features available in Microsoft Excel 2016. Changes in the Ribbon, new commands and locations, apps and add-ins will be used and students will customize Excel in different ways. Excel's Flash Fill and new 2016 functions will also be utilized. Several new charts will be generated including treemap, waterfall and Pareto charts. Students will save Excel files as Portable Document Format (PDF) files and use cloud-based services for file sharing.

Prerequisite: Intermediate / Advanced Excel  (earlier versions) 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. For more information including savings for custom group training, email us at info@avantixlearning.ca or contact us by phone.

Related training: View all Microsoft Excel courses >

INCLUDED IN THIS COURSE

  • Comprehensive course manual or published book
  • 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

Microsoft Excel Environment

  • Changes in the 2016 Ribbon
  • Adding new buttons to the Ribbon in 2016
  • New themes in 2016
  • Customizing the 2016 environment using apps
  • Extract and clean data using Flash Fill

Templates

  • Using new financial and calendar templates

Functions

  • Using new 2016 forecast functions

Working with Charts and Maps

  • Overview of charts in 2016
  • Formatting charts in 2016
  • Create treemap, sunburst, waterfall, histogram, Pareto and box and whisker charts in 2016
  • Create 3D geospatial maps

Getting and Transforming Data

  • Overview of the Get & Transform group on the Data tab on the Ribbon
  • Getting started with advanced querying using Power Query

Working with Pivot Tables

  • Changes in pivot tables in 2016
  • Analysing tables of data
  • Using Quick Analysis tools
  • Displaying Table slicers
  • Setting timelines

Data Models and Relationships

  • Getting started PowerPivot tables based on multiple tables
  • Overview of creating one-to-one and one-to many relationships between tables
  • Using automatic time grouping  (such as by year and month)
  • Delayed updating

Working with Files

  • Saving Excel files as Portable Document Format (PDF) documents
  • Sharing workbooks
  • Choosing sheets to share
  • Using cloud-based services such as SkyDrive/OneDrive
  • Inserting comments and markups in cloud-based services

Add-ins

  • Availability depending on versions
  • Overview of the Inquire add-in
  • Overview of Compare add-in

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!

RESOURCES

Microsoft Excel 2016 and 2013 Maximum Limits and Specifications

To request this page in an alternate format, contact our staff.

*Prices subject to change.

Copyright 2022 Avantix® Learning

Woman typing on laptop.

You may like

How to Change Case in Word (Upper, Lower, Title or Sentence Case)

How to Change Case in Word (Upper, Lower, Title or Sentence Case)

You can change case in Microsoft Word documents using formatting commands or by converting case. If you want to be able to easily change case (like removing All Caps), it's best to change case using the Font dialog box. If someone has created upper case text using hard capitals where they have pressed the Caps Lock key and typed the text, then you can convert case using the Change Case command.

How to Modify Table of Contents Formatting in Word

How to Modify Table of Contents Formatting in Word

If you have created a custom or automatic table of contents (TOC) in a Word document, you can add heading levels to the TOC. You can add or edit levels using built-in heading styles or use custom styles as levels.

You may also like

How to Show or Unhide the Quick Access Toolbar in Word, Excel and PowerPoint

How to Show or Unhide the Quick Access Toolbar in Word, Excel and PowerPoint

In 2021 and 365 versions of Word, Excel and PowerPoint, you now have the ability to hide or unhide the Quick Access Toolbar. So if your Quick Access Toolbar seems to have disappeared, it may simply be hidden. In 2021, Microsoft also removed Undo and Redo / Repeat  from the Quick Access Toolbar and moved these commands to the Home tab in the Ribbon.

5 Ways to Insert or Type the Square Root Symbol (√) in PowerPoint (with Shortcuts)

5 Ways to Insert or Type the Square Root Symbol (√) in PowerPoint (with Shortcuts)

You can insert or type the square root symbol in PowerPoint presentations using built-in commands or keyboard shortcuts. The square root symbol or radical sign can be entered in placeholders, text boxes or in equation blocks on PowerPoint slides. You can use an Alt code shortcut, a Math AutoCorrect entry or create an AutoCorrect entry as a custom shortcut.

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: Upgrading to Excel 2016 (Toronto course)
Location
Avantix Learning, 1 Yonge Street, Suite 1801 (Toronto Star Building),Toronto, Ontario, Canada,
Next course starts
July 18, 2018
Next course ends
July 18, 2018

Pin It on Pinterest