Record a Macro in Excel – Instructions and Video Lesson

A picture that shows how to record a macro in Excel using the “Record Macro” dialog box.
Overview of How to Record a Macro in Excel:              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,
Read more
No Comments

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: Overview             You can hide columns or rows in Excel that contain sensitive data. You can do this to hide data you need for formulas but don’t want to show in a worksheet, like salary information, for example. Hiding a column or row conceals its display, but still uses
Read more
No Comments

Resize Columns and Rows in Excel – Instructions and Video Lesson

Resize Columns and Rows in Excel - Instructions and Video Lesson: A picture of a user resizing selected columns in an Excel workbook.
Resize Columns and Rows in Excel: Overview             There are many ways to resize columns and rows in Excel. You can adjust the width of columns to correct the display of longer cell entries. You can also adjust row height to accommodate larger fonts. To resize columns and rows in Excel, you must first select
Read more
No Comments

Print a Chart in Excel – Instructions and Video Lesson

Print a Chart in Excel - Instructions and Video Lesson: A picture of a user printing a selected chart in Excel.
Print a Chart in Excel: Overview             To print a chart in Excel that appears embedded in a worksheet without printing the rest of the worksheet, select the chart or one of the chart’s elements, first. Alternatively, to print a chart in Excel that appears embedded in a worksheet along with its accompanying worksheet data, click into
Read more
No Comments

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

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