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

The Vancouver Island Works Project acknowledges that our members, live, play and do business on the Traditional Territory of the Lək̓ʷəŋən speaking peoples. It recognizes the First Nations governments across this region — Lək̓ʷəŋən (Songhees) and Xwsepsum (Esquimalt) Nations in the core area, the W̱SÁNEĆ Nations {W̱JOȽEȽP (Tsartlip), BOḰEĆEN (Pauquachin), SȾÁUTW̱,(Tsawout) W̱SIKEM (Tseycum)} out on the Saanich Peninsula and Gulf Islands, to the west Sc’ianew (Beecher Bay), T’Sou-ke, and Pacheedaht, and MÁLEXEȽ (Malahat) and Pune’laxutth’ (Penelekut) Nations.