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: Video Lesson             This video lesson, titled “Creating a Data Model from Excel Tables,” shows how to add Excel tables to a data model in Excel for Microsoft 365 or Excel 2019. This video on how to add Excel tables to a data model is
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: Video Lesson             This video lesson, titled “Modifying Timelines,” shows how to apply timeline options in Excel. This video is from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2019 and 365.” Timeline Options in Excel: Overview             This lesson shows you how to set timeline options in Excel. After
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: Video Lesson             This video lesson, titled “Creating KPIs,” shows you how to create a KPI in Power Pivot for Excel. This video lesson is from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2019 and 365.” Create a KPI in Power Pivot for Excel: Overview
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: Video Lesson             This video lesson, titled “Creating a Data Model from Excel Tables,” shows how to add Excel tables to a data model in Excel 2016 or earlier. This video on how to add Excel tables to a data model in Excel 2016 or
Read more
No Comments

How to Create PivotTables and PivotCharts in Excel 2010

How to Create PivotTables and PivotCharts in Excel 2010: Video This video lesson shows you how to create PivotTables and PivotCharts in Excel 2010. Need more Excel training? Click here for the complete tutorial! Creating Pivot Tables and Pivot Charts in Excel 2010: Overview You can use the PivotTable feature of Excel to access some
Read more
No Comments