The free PowerPivot add-in for Excel takes PivotTable analysis to a new level. PowerPivot is more than a simple replacement for the Excel PivotTable. It is a business intelligence tool that will provide you with additional features to build complex relationships between sets of data. With PowerPivot you can: analyze data beyond the limits of the Excel PivotTable; organize tables in a relational way; define complex calculation expressions; integrate different data sources into your analysis; provide enhanced interactive graphs; and discover analysis solutions that the Excel PivotTable is not able to provide. PowerView, PowerQuery, and the 2016 Power BI Desktop application to create dashboards will also be covered. Attendees will receive practical information and tips. This course applies to Excel 2013 and 2016.