Loading...

Course Description

Summarize and organize raw data in a way that can be meaningfully presented to others. Gain a solid understanding of Pivot Tables to maximize effectiveness when analyzing data. Use Power Pivot along with Excel to analyze data from a variety of sources. To ensure success in this course, you should have experience working with Excel and PivotTables, understand spreadsheet concepts, and be comfortable creating basic PivotTables.

Course Outline

  • Lesson 1: Preparing Data and Creating PivotTables
    • Prepare Data
    • Create a PivotTable from a Local Data Source
    • Create a PivotTable from Multiple Local Data Sources
    • Create a PivotTable from an External Data Source
  • Lesson 2: Analyzing Data by Using PivotTables
    •  Summarize PivotTable Data
    • Organize PivotTable Data
    • Filter PivotTable Data
    • Format a PivotTable
    • Refresh and Change PivotTable Data
  • Lesson 3: Working with PivotCharts
    • Create a PivotChart
    • Manipulate PivotChart Data
    • Format a PivotChart

Learner Outcomes

  • Prepare data for PivotTable reporting and create PivotTables from various data sources.
  • Analyze data by using PivotTables.
  • Work with PivotCharts.

Applies Towards the Following Digital Badges

Loading...
Enroll Now - Select a section to enroll in
Section Title
Excel 2019 PivotTables
Type
Prospect Heights (LCC)
Days
T
Time
1:30PM to 4:30PM
Dates
Apr 30, 2024
Schedule and Location
Contact Hours
3.0
Location
  • Harper Learning & Career Center, Prospect Heights
Section Title
Excel 2019 PivotTables
Type
Prospect Heights (LCC)
Days
M
Time
5:30PM to 8:30PM
Dates
May 06, 2024
Schedule and Location
Contact Hours
3.0
Location
  • Harper Learning & Career Center, Prospect Heights
Section Title
Excel 2019 PivotTables
Type
Prospect Heights (LCC)
Days
T, Th
Time
1:30PM to 4:30PM
Dates
Jul 23, 2024 to Jul 25, 2024
Schedule and Location
Contact Hours
6.0
Location
  • Harper Learning & Career Center, Prospect Heights
Required fields are indicated by .