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

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

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

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

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