Create Headers and Footers in Excel – Instructions

Create Headers and Footers in Excel - Instructions: A picture of the “Header” dialog box you can open from the “Page Setup” dialog box in Excel.
Create Headers and Footers in Excel: Video Lesson             This video lesson, titled “Creating Headers and Footers,” shows how to create headers and footers in Excel. This video lesson is from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2019 and 365.” Create Headers and Footers in Excel: Overview How to Create Headers and
Read more
No Comments

Hide Columns or Rows in Excel – Instructions and Video Lesson

Hide Columns or Rows in Excel - Instructions: A picture of a user hiding selected columns in an Excel workbook.
Hide Columns or Rows in Excel: Video Lesson             This video lesson, titled “Hiding and Unhiding Columns and Rows,” shows you how to hide columns or rows in Excel. This video lesson is from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2019 and 365.” Hide Columns or Rows in Excel: Overview             You
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

Outline Excel Data in Microsoft Excel – Instructions

Outline Excel Data in Microsoft Excel - Instructions: A picture of an Excel worksheet with an outline applied.
Outline Excel Data in Microsoft Excel: Video Lesson             The video lesson above, titled “Applying and Removing Outlines,” shows how to outline Excel data. The following video, titled “Using Outlines,” shows you how to use outlines in Excel. These video lessons are from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2019 and 365.”
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

Remove Cell Formatting in Excel – Instructions

Remove Cell Formatting in Excel - Instructions: A picture of a user clearing cell formatting from selected cells in an Excel workbook.
Remove Cell Formatting in Excel: Video Lesson             This video lesson, titled “Clearing All Formatting from Cells,” shows how to remove cell formatting in Excel. This video lesson on how to clear cell formatting in Excel is from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2019 and 365.” Remove Cell Formatting in Excel:
Read more
No Comments

Insert Slicers and Delete Slicers in Excel- Instructions

Insert Slicers and Delete Slicers in Excel: A picture of a slicer applied to a PivotTable in Excel.
Insert Slicers and Delete Slicers in Excel: Video Lesson             This video lesson, titled “Inserting and Deleting Slicers,” shows how to insert slicers and delete slicers in Excel. This video lesson is from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2019 and 365.” Insert Slicers and Delete Slicers in Excel: Overview             You
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