The University of North Carolina at Chapel Hill

 

Excel: PowerPivot

An introduction to PowerPivot to connect multiple data sets to create a data model.

What is the Excel PivotTable training?

This training is a very basic introduction to PivotTables and VLOOKUP functions in Excel. In addition, you will learn some tips and tricks that can save you time on the job.

What will you cover in this training?

We will cover the following topics:

  • How to format data for a pivot table
  • How to create a pivot table
  • Additional PivotTable Features
    • Value Field setting options
    • Formatting subtotals/grand totals
    • Calculated fields
    • Filters
  • How to use VLOOKUP (very basic intro)

 

Who should attend this training?

You should attend this training if you have never created a PivotTable or have very limited experience with PivotTables. In addition, you should have some foundational knowledge of Excel, including how to write basic formulas (such as SUM).

Date:  4/11/2023, 1:00 PM – 3:00 PM
Location: Zoom Video

Register Now - Individual Registration