Basic Excel PowerPivot | CLEARIFY

Excel PowerPivot takes Business Analytics to the next level.  Available as a free download for Excel 2010 users, and part of the 2013/365 Microsoft Office Professional Plus Suite, it gives the user complete control to not only create simple analysis, but provides the ability to add information from multiple sources, create your own Key Performance Indicators (KPI), devise multiple graphical representations of your data, and calculations that are not even possible with the regular pivot table feature.

For those of you who have been wrestling with VLOOKUPS, spreadsheet nightmares that compromise multiple pieces of disparate information, and ‘slow to a crawl speed’ when dealing with larger data sets, you finally have better tools at your disposal, as Microsoft finally got this one right.   Users of this technology will find themselves well ahead of the curve – with tools that heretofore required you to purchase separately from third party vendors – without this full functionality.

What you will learn:

• Difference between PowerPivot and the old style pivot table models
• Creating a simple data model
• Pre-formatting your raw data
• Using PowerPivot to create your analysis
• Subtotals and Totals
• Sorting and filtering
• Drill Down Functions
• Using Slicers
• Creating your own KPI’s