http://theexcelclub.com/excel-power-tools-the-future-of-excel/
In this demonstration we will look at creating standard pivot tables. When creating a standard pivot table, it is often necessary to preform several VLOOKUPs to pull data from other tables into the one table. This can be rather heavy on resources, especially if you have a large set of data. This is a limitation of standard pivot tables. Another limitation is once you create a standard pivot table, you do not have the option to move the data from the pivot table into different places on your workbook.
With Power Pivot both limitations have been removed. You no longer need to carry out multiple VLOOKUPs to add the data into one table as PowerPivot will allow you pivot data from multiple tables. With PowerPivot you can also removed the limitation of formatting the data.
This demonstration shows how you can overcome some simple problems with Power Pivot. With Power Pivot you can do a lot lot more than what we shown. This is an amazing tool that will allow you carry out complex calculations and modeling using DAX (Data Analysis Expressions). DAX functions are based on Excel formula with a few more functions thrown in for extra power.
The Excel Club Blog has been powered with #STEEM. That means we are a tokenized website and you can earn while you learn Excel, PowerBI and DAX. All you have to do is engage with the post on The Excel Club Blog, so if you have any questions or comments I would encourage you to post them on the blog and not here on the video
Sign up to our newsletter
http://theexcelclub.com/newsletter/
Watch more Power BI videos
https://www.youtube.com/playlist?list=PLJ35EHVzCuiEsQ-68y0tdnaU9hCqjJ5Dh
Watch more Excel Videos
https://www.youtube.com/playlist?list=PLJ35EHVzCuiFFpjWeK7CE3AEXy_IRZp4y
#share2steem #excel #powertools #steem #exceltips #tutorial
