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 Fee: Custom training rates apply.
Note: Public scheduled dates for this course are delivered as live instructor-led classroom training.
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.
On-site training
Register now for a public scheduled course or contact us to discuss custom on-site or off-sit training options.
Related courses
Microsoft Excel: Data Analysis with Functions, Dashboards and What-If Analysis Tools
Microsoft Excel: Introduction to VBA (Visual Basic for Applications) Macros
Microsoft Project: Introduction
You may like
How to Combine First and Last Name in Excel (5 Ways)
You can combine first and last name in Excel in several ways – using the CONCATENATE operator, the CONCATENATE function, the CONCAT function, the TEXTJOIN function or Flash Fill. These functions are often used to combine text in cells but you can also combine text with spaces, commas, dashes or another character. It's common to combine first and last names that appear in two columns into one new column. Some functions are only available in newer versions of Excel but the CONCATENATE operator and function are available in all versions.
How to Insert Multiple Columns in Excel (4 Fast Ways with Shortcuts)
You can quickly insert multiple columns in Excel using a drop-down menu, keyboard shortcuts or the Home tab in the Ribbon. The key to inserting multiple columns at once, rather than one by one, is to select the number of columns you want to insert first and then insert columns. Excel will insert the same number of columns you selected.
Excel XLOOKUP Function (Overview, Syntax + Formula Examples)
The XLOOKUP function is a replacement for Excel's traditional VLOOKUP function (as well as HLOOKUP and INDEX / MATCH functions). It has a new set of arguments and is available in Excel 2021 and 365. It allows you to look up a value from an array in a range or table and return one or more results. One of the primary benefits of XLOOKUP is that it can look up from columns to the left in a data set and return a range.
You may also like
How to Fade a Picture or Part of a Picture in PowerPoint (Using a Gradient)
You can fade a picture in PowerPoint by drawing a rectangle shape on top of the picture and then filling the rectangle with a gradient from opaque to transparent. This technique is often used to fade an image into the background of a slide. Since the rectangle is placed on top of the image and then text may be placed on top of the rectangle, you may need to reorder the objects.
How to Lock an Image, Shape or Other Object in PowerPoint
You can now lock an image, shape or other object in PowerPoint. Objects can be locked in Normal View or Slide Master View. Only PowerPoint 365 users can lock objects to prevent moving and resizing. This is helpful if you want to select and move other objects on the slide or prevent others from moving or resizing an object. You can lock items using the context menu or the Selection Pane.
PowerPoint vs Google Slides (Full Feature Comparison + Benefits)
When comparing PowerPoint vs Google Slides (and trying to decide which is the better choice for your needs), you will need to consider versions when you compare the two applications. In this article, we'll compare the desktop or downloadable version of PowerPoint vs Google Slides, an online program that works in a browser. The key difference then if you are comparing PowerPoint vs Google Slides is that PowerPoint must be downloaded and runs on your desktop and Google Slides runs online. The desktop version of PowerPoint is a robust, full-featured program with many advanced features. You can buy PowerPoint as a stand-alone version or as part of a Microsoft 365 subscription. If you are a 365 subscriber, new features roll out on a regular basis.
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