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

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

Freeze Panes in Excel – Instructions and Video Lesson

Freeze Panes in Excel - Instructions: A picture of a user selecting the Freeze Panes button in Excel.
Freeze Panes in Excel: Video Lesson             This video lesson, titled “Freeze Panes,” shows how to freeze panes in Excel. This video lesson is from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2019 and 365.” Freeze Panes in Excel: Overview             You can freeze panes in Excel to view data in two separate
Read more
No Comments

Sort a Table in Excel – Instructions and Video Lesson

Sort a Table in Excel - Instructions: A picture of the “Sort” dialog box within Excel for Office 365.
Sort a Table in Excel: Video Lesson             This video lesson, titled “Sorting Data,” shows you how to sort a table in Excel. This video is from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2019 and 365.” Sort a Table in Excel: Overview             You can sort a table in Excel using any
Read more
No Comments

Merge Changes in Copies of Shared Workbooks in Excel

Merge Changes in Copies of Shared Workbooks in Excel: A picture of a user clicking the “Compare and Merge Workbooks” button that has been added to the Quick Access toolbar in Excel.
Merge Changes in Copies of Shared Workbooks in Excel: Video             This video lesson, titled “Compare and Merge Workbooks,” shows how to merge changes in copies of shared workbooks in Excel. This lesson is from our complete Excel tutorial, titled “Mastering Excel Made Easy v.2016-2013.” Merge Changes in Copies of Shared Workbooks in Excel: Overview
Read more
No Comments