Microsoft Excel Introduction to PowerPivot
With Power Pivot, you can mash up large volumes of data from various sources, perform information analysis rapidly, and share insights easily.
Stream this recording multiple times at your convenience.
- $200.00 incl. GST
- PD hours: 1.25
If you are a fan of PivotTables you will love PowerPivot!
PowerPivot enables you to import millions of rows of data from multiple data sources into a single Excel workbook, create relationships between heterogeneous data, create calculated columns and measures using formulas, build PivotTables and PivotCharts, and then further analyze the data so that you can make timely business decisions without requiring IT assistance.
Join us in this webinar and learn what PowerPivot is, how to activate and how to conduct powerful business intelligence (BI) in an environment that is familiar.
Webinar Learning Outcomes:
What is PowerPivot?
Activating the PowerPivot add-in
The PowerPivot Managed Window
Add Data to the data model from various sources
Add Data by Using a Custom Query
Add Data by Using Copy and Paste
Create Relationships between Tables
Create a PivotTable from PowerPivot Data
Add Slicers to PivotTables
Business professionals, Business owners, Finance and Administration support staff.
Attendees should be familiar with Excel and pivot tables.
PowerPivot is a free add-in with Excel 2010 and is built in to Excel 2013 and 2016.
We will be demonstrating using Excel 2016 but the content will be relevant to users of earlier versions.
|Microsoft Excel Lookup Functions||Webinar Recording|
|The Best of Microsoft PowerPoint 2016||Webinar Recording|
|The Best of Microsoft OneNote 2016||Webinar Recording|
|Data Analytics and Dashboards (4 of 5)||Webinar Recording|