Add Excel Tables to a Data Model in Excel 2019- Instructions

Add Excel Tables to a Data Model in Excel 2019- Instructions: A picture of the “Import Data” dialog box in Excel, which lets users add tables to a workbook’s data model.
Add Excel Tables to a Data Model in Excel 2019: Overview             You can manually add Excel tables to a data model in Excel 2019 or Excel for Office 365 workbooks. You can then use them as the data source for PivotTables and PivotCharts. However, note that this process changed from earlier versions of Excel.
Read more
No Comments

Timeline Options in Excel – Instructions

Timeline Options in Excel - Instructions: A picture of a user modifying the appearance of a timeline in Excel.
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 in the Ribbon any time you select the timeline within the worksheet. You use the buttons
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 in Excel 2016- Instructions

Add Excel Tables to a Data Model in Excel 2016- 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 in Excel 2016: Overview             You can manually add Excel tables to a data model in Excel 2016 or earlier workbooks. You can then use them as the data source for PivotTables and PivotCharts. Note that this process has changed in Excel 2019 and Excel for Office 365.
Read more
No Comments

Microsoft Excel 2010 Training: How to Create PivotTables and PivotCharts

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
Read more
No Comments