Format a PivotTable in Excel – Instructions and Video

Format a PivotTable in Excel: A picture showing the “Design” tab of the “PivotTable Tools” contextual tab in the Ribbon of Excel.
Format a PivotTable in Excel: Overview             You can apply preset styles to format a PivotTable in Excel. To format a PivotTable in Excel, click into any cell in the PivotTable. Then click the “Design” tab of the “PivotTable Tools” contextual tab within the Ribbon. Then click the desired style to apply from the listing
Read more
No Comments

Create a KPI in Power Pivot for Excel – Instructions

Create a KPI in Power Pivot for Excel - Instructions: A picture of the “Key Performance Indicator (KPI)” dialog box in Power Pivot for Excel.
Create a KPI in Power Pivot for Excel: Overview             Creating measures within the data model in Power Pivot then lets you create a KPI in Power Pivot for Excel. KPI stands for Key Performance Indicator. A KPI is a value, and often associated symbol, that gauges the performance of a base field in attaining
Read more
No Comments

Add Excel Tables to a Data Model- Instructions

Add Excel Tables to a Data Model- Instructions: A picture of the “Workbook Connections” dialog box in Excel, showing references to Excel tables in the data model.
Add Excel Tables to a Data Model: Overview             You can manually add Excel tables to a data model within a workbook. You can then use them as the data source for PivotTables, PivotCharts and Power View reports. Before doing this, however, first create the necessary tables within Excel. Also, to add Excel tables to
Read more
No Comments

Using PowerPivot in Microsoft Excel 2013

For the complete course click here.             Starting PowerPivot PowerPivot is an add-in that is included in Microsoft Excel Professional Plus 2013. It was also available in Excel 2010, but has seen many improvements to its functionality in the 2013 version. PowerPivot is not available in Excel 2007. PowerPivot essentially
Read more
No Comments