Ready to Checkout?


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

Timeline Options in Excel: Overview             This lesson shows you how to set timeline options in Excel. After inserting a timeline, an “Options” tab within a new “Timeline Tools” contextual tab then appears in the Ribbon. This tab appears within the Ribbon any time you have the timeline selected within the worksheet. You use the

Create a KPI in Power Pivot for Excel: Overview             Another useful feature of creating measures within the data model in Power Pivot is the ability to then extend these fields to create a KPI in Power Pivot for Excel. KPI stands for Key Performance Indicator. A KPI is a value, and often associated symbol,

Need more Excel training? Click here for the complete tutorial!                 Creating Pivot Tables and Pivot Charts You can use the PivotTable feature of Excel to access some of the most powerful data-analysis that Excel can provide. PivotTables allow you to organize massive amounts of data in more