Healthcare

Financial

Management

Association


Excel Series 3 - Power Pivot Basics (Advanced)

  • 06 Feb 2019
  • 12:00 PM - 1:30 PM
  • Webinar
WEBINAR
SAVE THE DATE
Excel Series 3
Power Pivot Basics (Advanced)


Do you love PivotTables? Of course, we all do! Traditional PivotTables are incredible…but, they do have limitations. If you have ever encountered one of these limitations, you’ll be excited to learn that by using Power Pivot, you’ll be able to bypass many of the restrictions that exist with traditional PivotTables. Power Pivot provides a new data source for PivotTables, and essentially combines the flexibility of formula-based reports with the PivotTable engine. Microsoft provides Power Pivot free for most editions of Excel for Windows 2010 and forward (currently, it is unavailable in Excel for Mac). In this session, we’ll explore Power Pivot and the data model, build PivotTables from multiple tables, create calculated columns, and write measures. If you frequently build PivotTables and would like to do more with them, you’ll want to understand how Power Pivot can enhance your reports and workflow. Learning objectives: (1) recall the steps to access the Power Pivot window; (2) identify the process to create table relationships; and (3) state the procedure for building named sets.
Powered by Wild Apricot Membership Software