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

Set Margins in Excel – Instructions

Set Margins in Excel - Instructions: A picture of the “Margins” tab within the “Page Setup” dialog box in Excel.
Set Margins in Excel: Video Lesson             This video lesson, titled “Setting Margins,” shows how to set margins in Excel worksheets. This video lesson is from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2019 and 365.” Set Margins in Excel: Overview             To set margins in Excel worksheets before printing, open the “Page
Read more
No Comments

Compare Workbooks in Excel – Instructions

Compare Workbooks in Excel - Instructions: A picture of a user comparing two workbooks in Excel side by side.
Compare Workbooks in Excel: Video Lesson             This video lesson, titled “Comparing Open Workbooks,” shows you how to compare workbooks in Excel. This video lesson is from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2019 and 365.” Compare Workbooks in Excel: Overview             This lesson shows you how to compare workbooks in Excel.
Read more
No Comments