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

Navigating Worksheets in Excel – Instructions

Navigating Worksheets in Excel - Instructions: A picture of a user navigating worksheets in Excel by using the “Activate” dialog box.
Navigating Worksheets in Excel: Video Lesson             This video lesson, titled “Navigating Worksheets,” shows you different ways of navigating worksheets in Excel. This video lesson is from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2019 and 365.” Navigating Worksheets in Excel: Overview             Navigating worksheets in Excel lets you view different worksheets in
Read more
No Comments

Recover Unsaved Workbooks in Excel – Instructions

Recover Unsaved Workbooks in Excel - Instructions: A picture of an unsaved workbook recovered by Microsoft Excel.
Recover Unsaved Workbooks in Excel: Video Lesson             This video lesson, titled “Recovering Unsaved Workbooks,” shows how to recover unsaved workbooks in Excel. This video lesson is from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2019 and 365.” Recover Unsaved Workbooks in Excel: Overview             You can try to recover unsaved workbooks in
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

Create a KPI in Power Pivot for Excel – Instructions

Create a KPI in Power Pivot for Excel - Instructions: A picture of the “Key Performance Indicator (KPI)” dialog box in Power Pivot for Excel.
Create a KPI in Power Pivot for Excel: Video Lesson             This video lesson, titled “Creating KPIs,” shows you how to create a KPI in Power Pivot for Excel. This video lesson is from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2019 and 365.” Create a KPI in Power Pivot for Excel: Overview
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

Workbook Protection in Excel- Instructions

Workbook Protection in Excel- Instructions: A picture of the “Protect Structure and Windows” dialog box that is used to apply workbook protection in Excel.
Workbook Protection in Excel: Video Lesson             This video lesson, titled “Workbook Protection,” shows you how to apply and remove workbook protection in Excel. This video lesson is from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2019 and 365.” Workbook Protection in Excel: Overview             When you apply workbook protection in Excel, users
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