Class / Schedule


PC End User

Excel 2013/2016 Pivot Tables (1 Day) - Virtual or In-person

Do you work with Excel documents involving large, cumbersome amounts of data? You can use the Microsoft Excel Pivot Tables feature to quickly extract meaningful, concise information from this data and look at the data in many different ways. Pivot Tables are interactive and dynamic, enabling you to make comparisons and answer specific questions without having to write new formulas, copy and paste cells, or reorganize rows and columns.

The class will also include an overview of creating standard tables and charts from an Excel worksheet; however, participants need to have a good understanding of and experience with Excel prior to this class.

    Performance Objectives: Upon completion of this course you should be able to:

      • Creating and customizing Pivot Tables
      • Nesting fields
      • Grouping data
      • Calculating and customizing statistics
      • Filtering data
      • Utilizing Slicers
      • Creating and customizing Pivot Charts

      Competencies covered in this course: Manage large amounts of data to extract meaningful information.

        Intended Audience: Anyone who works with large amounts of data in Excel.

          Recommended Pre-requisites: Users with a good understanding of Excel and familiarity with tables, charts and formulas.

          Scheduled Class Location and Dates
          City / Facility Date and Time Course Cost Cancel Date Instructor
          1 Virtual

          Virtual Training
          • Sep 17 2020 8:00am-4:30pm
          $159.00 Mon, 08/31/2020 - 17:00 Debbie Lonborg
          2 Virtual

          Virtual Training
          • Nov 3 2020 8:00am-4:30pm
          $159.00 Thu, 10/15/2020 - 17:00 Debbie Lonborg