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

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

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

Trace Error in Excel – Instructions and Video Lesson

Trace Error in Excel - Instructions: A picture of formula auditing arrows shown in a worksheet after using the Trace Error tool in Excel.
Trace Error in Excel: Video Lesson             This video lesson, titled “Tracing Errors,” shows you how to use Trace Error in Excel. This video lesson is from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2019 and 365.” Trace Error in Excel: Overview             Trace Error in Excel lets you trace arrows back to
Read more
No Comments

Function Compatibility in Excel – Instructions

Function Compatibility in Excel - Instructions: A picture of the “Compatibility” functions in Excel.
Function Compatibility in Excel: Video Lesson             This video lesson, titled “Function Compatibility,” shows how to use function compatibility in Excel. This video on function compatibility in Excel is from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2019 and 365.” Function Compatibility in Excel: Overview             Function compatibility in Excel supports older functions
Read more
No Comments

Conditional Formatting in Excel – Instructions

Conditional Formatting in Excel - Instructions: A picture of a user selecting a custom conditional formatting choice from the “Conditional Formatting” button’s drop-down menu.
Conditional Formatting in Excel: Video Lesson             This video lesson, titled “Conditional Formatting,” shows you how to apply conditional formatting in Excel. This video lesson is from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2019 and 365.” Conditional Formatting in Excel: Overview             Conditional formatting in Excel lets you define criteria for cells
Read more
No Comments

Inserting and Deleting Worksheets in Excel- Instructions

Inserting and Deleting Worksheets in Excel- Instructions: A picture of a user inserting a new worksheet into an Excel workbook.
Inserting and Deleting Worksheets in Excel: Video Lesson             This video, titled “Inserting and Deleting Worksheets,” shows different ways of inserting and deleting worksheets in Excel. This video is from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2019 and 365.” Inserting and Deleting Worksheets in Excel: Overview            
Read more
No Comments