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: Overview             When you apply password protection to an Excel file, you prevent people from opening it without knowing the required password. After password protection is enabled on a file, no one can open it without the password. Therefore, password-protecting files poses some risk. This is because if
Read more
No Comments

Record a Macro in Excel – Instructions and Video Lesson

Record a Macro in Excel - Instructions and Video Lesson: A picture of the “Record Macro” dialog box in Excel.
Record a Macro in Excel: Overview              You can easily record a macro in Excel. Macros are small programs that record your actions as you perform a task in Excel. The actions are then saved as a Visual Basic Module, which is a type of program. When you run the macro later, it repeats your
Read more
No Comments

Change the Chart Type in Excel – Instructions

Change the Chart Type in Excel - Instructions: A picture of a user changing the chart type of a selected chart in Excel.
Change the Chart Type in Excel: Overview             After creating a chart, you can change the chart type in Excel. Alternatively, you can also choose a different sub-type of the same general chart type you first selected. Either way, note that if you change the chart type, you may lose custom formatting you have applied
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: Overview             You can manually add Excel tables to a data model in Excel 2019 or Excel for Office 365 workbooks. You can then use them as the data source for PivotTables and PivotCharts. However, note that this process changed from earlier versions of Excel.
Read more
No Comments

AutoSave in Excel for Office 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 Office 365: Overview AutoSave in Excel for Office 365: How to Enable AutoSave in Excel for Office 365             This tutorial shows you how to use AutoSave in Excel for Office 365. AutoSave in Excel for Office 365 is automatically enabled when you save a workbook using the newest file formats
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: Overview             This lesson shows you how to compare workbooks in Excel. To compare workbooks in Excel, first open the workbooks to compare to each other. To then compare them side by side, with each workbook taking an equal portion of the screen, click the “View” tab in the Ribbon. Then
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: Overview             Trace Error in Excel lets you trace arrows back to cells referenced by a formula if it displays an error. The Trace Error tool is available when auditing a worksheet within a workbook. Note that the formula cell that you select must contain an error to use the Trace Error
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: Overview             You can try to recover unsaved workbooks in Excel. To see if Excel has automatically saved a copy of an unsaved workbook, click the “File” tab in the Ribbon. Then click the “Open” command at the left side of the backstage view. In the area to the right
Read more
No Comments