Class / Schedule

PC End User

Excel 2010/2013 Pivot Tables (1 Day)

01-04-D712
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
          Lacey SPSCC - LACEY
          4220 6th Ave SE Bldg. 1
          Lacey, WA 98503
          • Apr 25 2017 8:00am-4:30pm
          $159.00 Thu, 04/06/2017 - 17:00 Debbie Lonborg
          Lacey SPSCC - LACEY
          4220 6th Ave SE Bldg. 1
          Lacey, WA 98503
          • Jun 5 2017 8:00am-4:30pm
          $159.00 Wed, 05/17/2017 - 17:00 Debbie Lonborg