Excel - Pivot tables Short-Shot

Price: $150.00

Days: 0.5

Course Dates:

October 14 , December 16 , February 17

Learn Excel - Pivot tables Short-Shot

Manage your information all in one

Excel – Pivot tables Short-Shot

Course EXPT: 0.5 Days; Instructor-led by Michael Ouchi (Master Office Instructor)

PivotTables allow you to analyze huge amounts of data very quickly and easily. This short shot will give you the skillsets to create a PivotTable, PivotChart, use a Slicer to allow for easier user interaction. You will also explore the potential of the DataModel to work with multiple datasources.

  • Singular datasource
    • create/edit a pivot table
    • use multiple fields
  • Create a Pivot Chart
  • Work with Slicer object
  • Multiple datasources (Excel 2013 or newer)
    • Intro to the Data Model
    • link multiple datasource
    • use DAX to create custom column or measure
    • create a KPI