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 a selected column 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

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: Overview             This lesson shows you how to merge changes in copies of shared workbooks in Excel. This is an older method of reviewing changes to a shared workbook in Excel, but it still works. You can merge changes in copies of shared workbooks in Excel
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

Create a Data Model from External Relational Data in Excel – Instructions

Create a Data Model from External Relational Data in Excel - Instructions: A picture of a user selecting the external relational data tables to add to the data model in an Excel workbook by using the “Select Table” dialog box.
Create a Data Model from External Relational Data in Excel: Overview             You can create a data model from external relational data in Excel. Data models in Excel let you store multiple tables of information. They can then be used a data source for PivotTables, PivotCharts, and Power View reports.             The choice to add
Read more
No Comments

Create a New Workbook in Excel- Instructions

Create a New Workbook in Excel - Instructions: A picture of the workbooks templates in Excel.
Create a New Workbook in Excel: Overview             You can easily create a new workbook in Excel. A workbook is the default file type in Excel, much like a document is the default file type in Word. A workbook can contain multiple worksheets where the data is stored and manipulated in the columns and rows.
Read more
No Comments

Add Excel Tables to a Data Model- Instructions

Add Excel Tables to a Data Model- Instructions: A picture of the “Workbook Connections” dialog box in Excel, showing references to Excel tables in the data model.
Add Excel Tables to a Data Model: Overview             You can manually add Excel tables to a data model within a workbook. You can then use them as the data source for PivotTables, PivotCharts and Power View reports. Before doing this, however, first create the necessary tables within Excel. Also, to add Excel tables to
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

Freeze Panes in Excel – Tutorial

Freeze Panes in Excel - Tutorial: A picture of a user selecting the Freeze Panes command in Excel.
Freeze Panes in Excel: Overview             You can freeze panes in Excel to view data in two separate sections of a long worksheet simultaneously. You can freeze panes in Excel to freeze one or two sections of a worksheet to prevent scrolling. This lets you scroll the unfrozen section of the worksheet to view two different worksheet
Read more
No Comments