Loading...

Course Description

This course has been revised. Starting August 2024 the title is Excel Part 4 (Microsoft 365).

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.

Note: Summer 2024 is the last time Community Education will be offering Excel 2019. Starting in August, we will be moving to Microsoft 365

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.

Notes

This course has been revised. Starting August 2024 the title is Excel Part 4 (Microsoft 365).
Loading...
Thank you for your interest in this course. While we currently do not have a section open for enrollment, we invite you to join us the next time the class is offered. To ensure you don’t miss out, please complete a Course Inquiry and we’ll be sure to notify you as soon as the next enrollment opens.
Required fields are indicated by .