Microsoft Excel: Upgrading to Excel 2013

Microsoft Excel Training Series | Level 3

Course Details

Duration: 1 day

Microsoft® Excel® Version: 2013

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

Course Dates: Contact us to arrange a date. | View schedule Course schedule

Course Fee: Custom training rates apply.

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, students will review exciting new features available in Microsoft Excel 2013. Changes in the Ribbon, new commands and locations, apps and add-ins will be introduced and students will customize the Quick Access toolbar. Students will use Excel's new Flash Fill and create formulas using some of the new functions available in 2013. New chart and pivot table features will be used including Quick Analysis tools and timelines. A brief introduction to data models and relationships will also be included in this course. Students will save Excel files as Portable Document Format (PDF) files and use cloud-based services for file sharing.

Prerequisite: Intermediate/Advanced Excel 2007 or 2010 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

  • Work with the Ribbon and the Quick Access Toolbar
  • New locations of commands and new commands and features in 2013
  • Customizing the Quick Access toolbar and the Ribbon
  • Adding Apps
  • Key commands on the File tab/Backstage View

Workbook Management

  • Using some of the new Excel 2013 templates
  • Creating new sheets in new ways
  • Using Flash fill
  • Creating formulas using some of Excel 2013's new functions

Working with Charts

  • Recommended charts in 2013
  • Setting chart options
  • Formatting charts in 2013
  • Customising data labels
  • Inserting a people graph

Working with Pivot Tables

  • Recommended pivot tables in 2013
  • Analysing tables of data
  • Using Quick Analysis tools
  • Displaying Table slicers
  • Setting timelines
  • Drilling down to detail levels in a PivotTable or PivotChart
  • Drilling up for a high-end view

Data Models and Relationships

  • Brief introduction to creating PivotTables based on multiple tables
  • Quick overview of creating one-to-one and one-to many relationships between tables

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

RESOURCES

Microsoft Excel 2016 and 2013 Maximum Limits and Specifications

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!

Copyright 2017 Avantix Learning Inc.

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

*Prices subject to change.

^ Back to top

Woman typing on laptop.

You may like

How to Lock Cells in Excel (3 Ways)

How to Lock Cells in Excel (3 Ways)

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 Password Protect Your Excel Worksheets and Workbooks

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

How to View Document Statistics in Microsoft Word

How to View Document Statistics in Microsoft Word

Microsoft Word automatically tracks statistics about your documents. These statistics appear in Word Properties and include the file name, directory, template, author, editing time, last print date and the user who last modified the document.

How to Create a Table Template in Word

How to Create a Table Template in Word

If you insert tables frequently in Word, you may want to create a table template to save time. Keep in mind that tables are affected by themes, styles and table styles so if the table template you insert seems to change formatting, the current document may contain different formatting from the original document when the table template was saved. A table template is saved as a building block and will appear in Quick Tables.

How to Delete a Page in Word (Remove Blank or Extra Pages)

How to Delete a Page in Word (Remove Blank or Extra Pages)

In Word, you can delete a page in the middle or at the end of a document using several strategies. You can delete blank pages or pages that contain text and other content. Blank pages can be caused by unnecessary hard returns (pressing Enter too many times), manual page breaks, section breaks, paragraph formatting and tables so you will need to determine what is causing a blank page to remove it.

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 2013 (Toronto course)
Location
Avantix Learning, 1 Yonge Street, Suite 1801 (Toronto Star Building),Toronto, Ontario, Canada,
Next course starts
October 16, 2017
Next course ends
October 16, 2017

Pin It on Pinterest