Create a PivotChart in Excel- Instructions and Video

A picture showing a PivotChart in Excel and its PivotChart Fields task pane, which appear after you create a PivotChart in Excel.
Create a PivotChart in Excel: Video Lesson             This video lesson, titled “Excel for Microsoft 365 Tutorial: How to Create a PivotChart in Excel,” shows how to create a PivotChart in Excel. This video lesson is from our complete Excel tutorial, titled Mastering Excel Made Easy™. Overview of How to Create a PivotChart in Excel:
Read more
No Comments

Change Worksheet Tab Color in Excel – Instructions

Change Worksheet Tab Color in Excel - Instructions: A picture of a user changing the worksheet tab color in Excel.
Change Worksheet Tab Color in Excel: Video Lesson             This video lesson, titled “Excel for Microsoft 365 Tutorial: How to Change the Color of Worksheet Tabs in Excel,” shows you how to change worksheet tab color in Excel. This video lesson is from our complete Excel tutorial, titled Mastering Excel Made Easy™. Overview:             You
Read more
No Comments

Create a New Workbook in Excel- Instructions

A picture of the workbook templates that appear after you select “File” and then “New” in the Ribbon to create a new workbook in Excel.
Create a New Workbook in Excel: Video Lesson             This video lesson, titled “Excel for Microsoft 365 Tutorial: How to Create New Workbooks in Excel,” shows how to create a new workbook in Excel. This video lesson is from our complete Excel tutorial, titled Mastering Excel Made Easy™. Create a New Workbook in Excel: Overview
Read more
No Comments

Record a Macro in Excel – Instructions and Video Lesson

A picture that shows how to record a macro in Excel using the “Record Macro” dialog box.
How to Record a Macro in Excel: Video             This video lesson, titled “Recording Macros,” shows how to record a macro in Excel. This video lesson is from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2019 and 365.” Overview of How to Record a Macro in Excel:              You can easily record a
Read more
No Comments

Accept or Reject Changes to a Shared Workbook in Excel – Instructions

A picture showing how to accept or reject changes to a shared workbook in Excel if using the traditional “Shared Workbooks” feature.
Accept or Reject Changes to a Shared Workbook in Excel: Video             This video lesson, titled “Reviewing Changes,” shows you how to accept or reject changes to a shared workbook in Excel after highlighting the changes made if you are using the traditional “Shared Workbooks” feature. This video lesson is from our complete Excel tutorial,
Read more
No Comments

Apply Password Protection to an Excel File – Instructions

Apply Password Protection to an Excel File - Instructions: A picture of a user adding a password for opening the Excel file to a workbook.
Apply Password Protection to an Excel File: Video Lesson             This video lesson, titled “Password Protecting Excel Files,” shows you how to apply password protection to an Excel file. This video lesson is from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2019 and 365.” Apply Password Protection to an Excel File: Overview            
Read more
No Comments

Split Panes in Excel – Instructions and Video Lesson

Split Panes in Excel - Instructions and Video Lesson: A picture of a large Excel workbook that is horizontally split into two separate panes.
Split Panes in Excel: Video Lesson             This video lesson, titled “Split Panes,” shows how to split panes in Excel. This video lesson is from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2019 and 365.” Split Panes in Excel: Overview             To split panes in Excel when viewing a large worksheet, use the
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