Excel Power Pivot Introduction - How to Use Power Pivot

This video is an introduction to Power Pivot in Excel. It will explain what Power Pivot is, why and when to use it and walk through a complete example.

Download the files used in the video - http://bit.ly/35e1FaQ

Below are the timings for the video;
00:00 - Introduction
00:23 - Why use Power Pivot?
04:32 - Installing Power Pivot
06:00 - Importing Data into Power Pivot
11:39 - Modeling the Data
20:40 - Why use DAX?
23:06 - Writing DAX Measures
35:07 - Creating PivotTables and Slicers from our Model

This only serves as an introduction to Power Pivot to get started. There is plenty more to explore with Power Query, modelling and writing DAX. There are further videos in the related playlists on this channel to learn more.

Find more great free tutorials at;
https://www.computergaga.com

*** Online Excel Courses ***

The Ultimate Excel Course – Learn Everything ► https://bit.ly/2Ag5AKH
Excel VBA for Beginners ► http://bit.ly/2JvnnRv
Advanced Excel Tricks ► https://bit.ly/2UlTfvB
Excel Formulas Made Easy ► http://bit.ly/2t3netw
Creating Sports League Tables and Tournaments in Excel ► http://bit.ly/2viGg3J

Connect with us!

LinkedIn ► https://www.linkedin.com/company/18737946/
Facebook ► http://www.facebook.com/computergaga
Twitter ► http://www.twitter.com/computergaga1

Видео Excel Power Pivot Introduction - How to Use Power Pivot канала Computergaga