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

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

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

AutoSave in Excel for Microsoft 365 – Instructions

AutoSave in Excel for Office 365 - Instructions: A picture of the “Version History” panel you can use to revert changes made to a file with AutoSave enabled in Excel for Office 365.
AutoSave in Excel for Microsoft 365: Video Lesson             This video lesson, titled “AutoSave Online Workbooks,” shows you how to use AutoSave in Excel for Microsoft 365. This video lesson is from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2019 and 365.” AutoSave in Excel for Microsoft 365: Overview How to Enable AutoSave
Read more
No Comments