Information Technology

Excel 2013/2016 Pivot Tables

Course Code: 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.