The Basics of Big Data in Excel: PowerQuery and PowerPivot
Duration: 39m | Video: .MP4, 1280x720, 30 fps | Audio: AAC, 48 kHz, 2ch | Size: 219 MB
Genre: eLearning | Language: English

PowerQuery and PowerPivot are, for many people, unknown and hidden functions in Excel. Demystifying these features is going to give you endless possibilities if you work with big loads of data. Therefore, this class is not specific for certain fields or positions within a company, but rather for people using large datasets.

The class is useful because it will save you an enormous amount of loading time, formulas crunching, and importing/exporting files. This class will help you automate importing, cleaning, and processing data.

For this class we recommend Excel 2016. The two features discussed: PowerPivot and PowerQuery can be downloaded separately for people using older Excel (2010 and 2013):

Download