Microsoft Excel: Tables and Pivot Tables

Microsoft Excel Training Series | Level 2

Course Details

Duration: 1/2 day (3 hours)

Microsoft® Excel® Versions: 2013 | 2016 | 2019 | 2021 | 365 (Windows)

Delivery Methods (Instructor-led): In-person (Live classroom) | Virtual classroom

Course Dates: Contact us to arrange a date (this course is offered only as custom training) | View schedule for public courses Course schedule

Course Fee: Contact us for custom training rates

Timing: 9 am – 12 pm or 1 pm – 4 pm

Virtual classroom courses: Our instructor-led virtual classroom courses are delivered in a virtual classroom environment. Students will be sent a virtual classroom invitation prior to the course.

In-person classroom courses: Our instructor-led, live classroom (in-person) courses may be arranged at your location or ours.

Custom training: This course may be delivered at your site or ours as an instructor-led virtual classroom or in-person solution. Contact us at info@avantixlearning.ca for more information including savings for custom group training.

Register for this training course.

Course Overview

This instructor-led Microsoft Excel course is designed for users who want to manipulate list or database data using tables and pivot tables. Data will be converted to tables and then calculations will be created within the tables. Students will also create pivot tables to summarize list or database data. During this hands-on course, students will practice their skills and have the opportunity to ask questions and interact with the instructor. Each student will also receive a full course manual with tips, tricks and shortcuts as well as sample and exercise files.

Prerequisite: Microsoft Excel: Core Functions (Part 1) or equivalent knowledge and skills.

Next course in this series: Microsoft Excel: Core Functions (Part 2)

Related training: View all Microsoft Excel courses >

INCLUDED IN THIS COURSE

  • Comprehensive course manual
  • Keyboard shortcuts quick reference
  • Sample and exercise files (new samples added frequently)
  • Refreshments (for classes conducted in Avantix Learning classrooms)
  • Certificate of completion
  • Follow-up email support

Course Topics

Converting Data Sets to Tables

  • Why you should be using Excel tables
  • Converting data sets or lists to tables in 3 different ways
  • Naming tables
  • Formatting tables
  • Converting tables back to normal ranges

Calculating in Tables

  • Displaying totals for filtered records
  • Creating formulas in tables
  • Creating formulas outside of tables

Summarizing Data using Pivot Tables and Pivot Charts

  • Creating pivot tables to summarize Excel list or database data
  • Rearranging fields in a pivot table
  • Applying formatting to pivot tables and fields
  • Filtering a pivot table
  • Creating a pivot chart
  • Updating or refreshing a pivot table
  • Applying filtering using Excel's slicers
  • Adding a pivot table button to the Quick Access Toolbar

*Prices subject to change.

Our instructor-led courses are delivered in virtual classroom format or at our downtown Toronto location at 18 King Street East, Suite 1400, Toronto, Ontario, Canada (some in-person classroom courses may also be delivered at an alternate downtown Toronto location). Contact us at info@avantixlearning.ca if you'd like to arrange custom instructor-led virtual classroom or onsite training on a date that's convenient for you.

Copyright 2024 Avantix® Learning

Microsoft Excel training course Toronto represented by man pointing to icons on screen.

You may like

What is Power Query in Excel?

What is Power Query in Excel?

What is Power Query in Excel and Why is It So Useful? by Avantix Learning Team | Updated October 18, 2024 Applies to: Microsoft® Excel® 2016, 2019, 2021 and 365 (Windows) Power Query in Excel is a powerful data transformation tool that allows you to import data from...

How to Stop or Control Green Error Checking Markers in Excel

How to Stop or Control Green Error Checking Markers in Excel

Turn Off or Customize Error Checking Options (and Markers) in Excel by Avantix Learning Team | Updated September 15, 2023 Applies to: Microsoft® Excel® 2010, 2013, 2016, 2019, 2021 and 365 (Windows) In Microsoft Excel, errors are flagged by default with a small green...

You may also like

How to Freeze Rows in Excel (One or Multiple Rows)

How to Freeze Rows in Excel (One or Multiple Rows)

Freeze One or More Rows in an Excel Worksheet by Avantix Learning Team | Updated October 25, 2023 Applies to: Microsoft® Excel® 2010, 2013, 2016, 2019, 2021 and 365 (Windows) You can freeze one or more rows in an Excel worksheet using the Freeze Panes command. If you...

How to Show or Hide Gridlines in Excel

How to Show or Hide Gridlines in Excel

Show or Hide Gridlines in Excel Worksheets (+ Shortcuts) by Avantix Learning Team | Updated October 15, 2023 Applies to: Microsoft® Excel® 2013, 2016, 2019, 2021 and 365 (Windows) You can remove or hide gridlines in Excel worksheets to simplify worksheet design. By...

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 |18 King Street East, Suite 1400, Toronto, Ontario, Canada M5C 1C4 | Contact us at info@avantixlearning.ca

Upcoming Training
Course
Microsoft Excel: Tables and Pivot Tables - Online in virtual classroom format or in-person in Toronto, Ontario, Canada
Location
Avantix Learning, 18 King Street East, Suite 1400,Toronto, Ontario, Canada,
Next course starts
July 1, 2023
Next course ends
July 1, 2024
Description
Instructor-led Microsoft Excel Tables and Pivot Tables training course online in virtual classroom format or in-person in Toronto, Ontario, Canada. Arrange custom virtual or onsite training. In this hands-on course, learn to create and format tables and pivot tables. Create pivot tables to summarize data and add calculations and pivot charts. Each student will also receive a full course manual with tips, tricks and shortcuts as well as sample and exercise files. Virtual classroom courses are available to our clients in Toronto, Mississauga, Scarborough, Hamilton, St. Catharines, Ottawa, London, Calgary, Edmonton, Montreal, Vancouver, Victoria, Surrey, Burnaby, Richmond, Winnipeg, Halifax and across Canada and the United States.

Pin It on Pinterest