651-905-3729 Microsoft Silver Learning Partner EC Counsel Reseller compTIA Authorized Partner

Excel 2016 Session 5: Pivot Table Basics

1/2 Day

Description

NOTE: This course is availible by customer request only. If you are interested in taking this course, please call 651-905-3729 or submit a request for a date below. 

More and more, there is a need to analyze data in more complex and sophisticated ways.  MS Excel’s pivot table tools enable the user to re-represent existing data in a separate environment, making it easier to experiment, summarize and stack data elements without fear of harming already existing raw data. Learn the very basics of this topic and explore for yourself how useful pivot tables and pivot charts could be to your current project(s).

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a Excel 2016 Session 5: Pivot Table Basics class.

Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Course Overview

  • Lesson 1: Using PivotTables and PivotCharts
    • Topic A: Creating a Pivot Table
    • Topic B: Analyzing Pivot Table Data
    • Topic C: Presenting Data with Pivot Charts
    • Topic D:  Filtering Data by Using Timelines and Slicers
  • Lesson 2: What's New in Excel 2016
    • Topic A: Streamline Workflow in Excel Using Templates
    • Topic B: Accelerate Data Entry with Flash Fill
    • Topic C: Incorporate Charts
    • Topic D: Analyze Data
  • Appendix 1: Microsoft Office Excel 2016 Expert Exam 77-728
  • Appendix 2: Microsoft Excel 2016 Common Keyboard Shortcuts
  • Appendix 3: Financial Functions
  • Appendix 4: Working with Graphical Objects
  • Appendix 5: Using Array Formulas
  • Appendix 6: Microsoft Office Excel 2016 Exam 77-727

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a Excel 2016 Session 5: Pivot Table Basics class.

Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date

Prerequisites

Must have a good working understanding of MS Excel, either through experience, or completion of Excel 2016 Session 1: Getting Started with the Basics.

No Upcoming Public Classes

There are currently no public events available for this course. However, you can submit a request for a new date and we will try our best to get you into a Excel 2016 Session 5: Pivot Table Basics class.

Private Training Available
No date scheduled, don’t see a date that works for you or looking for a private training event, please call 651-905-3729 or submit a request for further information here.
request a private session or new date