Format a PivotTable in Excel – Instructions and Video

A picture showing how to format a PivotTable in Excel by applying a PivotTable style.
Format a PivotTable in Excel: Video Lesson             This video lesson, titled “Excel for Microsoft 365 Tutorial: How to Format PivotTables in Excel,” shows you how to format a PivotTable in Excel. This video lesson is from our complete Excel tutorial, titled Mastering Excel Made Easy™. Overview             To format a PivotTable in Excel, click
Read more
No Comments

Excel Tables, PivotTables, and Charts Cheat Sheet

Excel Tables, PivotTables, & Charts Cheat Sheet Now Available             TeachUcomp, Inc. is pleased to announce our Excel Tables, PivotTables, & Charts cheat sheet is now available. This quick reference card is a great tool for anyone who uses Excel. It provides step-by-step instructions for common tasks when using tables, charts, and PivotTables in Excel.
Read more
No Comments

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

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

Starting PowerPivot in Microsoft Excel 2013

Starting PowerPivot in Microsoft Excel 2013: Video This video shows starting PowerPivot in Excel 2013. For the complete course click here. Starting PowerPivot in Excel 2013: Overview 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
Read more
No Comments