Microsoft® Excel: Data Tables & PivotTables Featuring PowerPivot

Course Description:

This hands-on course is ideal for professionals with a working knowledge of Excel who are ready to take their data analysis skills to the next level.

In the first half, participants will reinforce foundational skills in working with Excel data lists and tables, including sorting, filtering, and subtotaling. Building on these essentials, the course introduces PivotTables—starting with basic, one-dimensional designs and progressing to multi-dimensional PivotTables enhanced by filters, slicers, and Pivot Charts.

The second half focuses on PowerPivot, a powerful Excel Add-In that extends the capabilities of traditional PivotTables. Participants will learn to perform advanced calculations, group and manage large data sets efficiently, and connect to external data sources to create robust, scalable reports.

Course Highlights:

• Identify and structure Excel data lists

• Perform basic and complex sorting techniques

• Apply filters and subtotal functions to analyze data

• Convert standard data lists into Excel Tables

• Create and customize one-dimensional and multi-dimensional PivotTables

• Reorganize PivotTable data for dynamic views

• Use filters and slicers to enhance interactivity

• Develop visually engaging Pivot Charts

• Utilize PowerPivot for:

  • Advanced calculations

  • Grouping and summarizing large data sets

  • Connecting to external data sources

  • Designing and distributing professional-level reports