Microsoft Excel: Upgrading to Excel 2013
Microsoft Excel Training Series | Level 3
Duration: 1 day
Microsoft® Excel® Version: 2013
Delivery Methods: Instructor-led classroom (ILC) | Virtual classroom (VC) on request
Course Fee: Custom training rates apply.
Note: Public scheduled dates for this course are delivered as live instructor-led classroom training.
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 firstname.lastname@example.org 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
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
- 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
- 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!
Copyright 2017 Avantix Learning Inc.
To request this page in an alternate format, contact our staff.
*Prices subject to change.
You may like
You can use 3D references in Excel formulas to calculate across multiple worksheets that are structured in the same way. A 3D reference refers to the same cell or range of cells on multiple worksheets.
As many Excel worksheets can become quite large, it can be useful to freeze row and column headings so that they are locked in place when you scroll through your worksheet. In Excel, you can freeze both row headings and column headings or just one.
It’s a common issue for Microsoft Excel users to attempt to use AutoFill to fill data in a filtered list and it doesn’t work as expected. The fill data is entered into all cells, including the hidden or invisible cells. The solution is to enter data into visible cells only …
You may also like
You can achieve some interesting effects by cropping images to shapes in PowerPoint. However, if you want to crop an image to a circle, you’ll need to combine cropping options.
There are a few ways to keep a Microsoft Word row or table together on one page. The method you use depends on several factors including the size of the table …
If you want to extract all images (or even just one or two) from a Microsoft PowerPoint deck to use in another presentation, there are a couple of ways to extract images …
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 | email@example.com