The Basics of Big Data in Excel: PowerQuery and PowerPivot

Platform Skillshare

Go to Skillshare

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):