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

Add Text to Shapes in Publisher – Instructions

Add Text to Shapes in Publisher - Instructions: A picture of a shape containing too much text in Publisher. Note the red resizing handles and the ellipsis mark on the shape. This indicates there is more text in the shape than it can display.
Add Text to Shapes in Publisher: Overview             You can add text to shapes in Publisher within a page. When you do this, Publisher converts the selected shape into a text box. However, because there are many shapes in Publisher, a text box does not have to be a literal box shape. Using this technique
Read more
No Comments

Format Data Labels in Excel- Instructions

Format Data Labels in Excel- Instructions: A picture of the “Format Data Labels” task pane in Excel.
Format Data Labels in Excel: Overview             You can format data labels in Excel if you choose to add data labels to a chart. To format data labels in Excel, choose the set of data labels to format. To do this, click the “Format” tab within the “Chart Tools” contextual tab in the Ribbon. Then
Read more
No Comments

Insert a Picture Placeholder in Publisher – Instructions

Insert a Picture Placeholder in Publisher - Instructions: A picture of a user adding a picture from the scratch area to a picture placeholder in Publisher.
Insert a Picture Placeholder in Publisher: Overview             You can insert a picture placeholder in Publisher into a publication page. When you insert a picture placeholder in Publisher, you allocate space in a page for a picture you can insert later. To insert a picture placeholder in Publisher, click the “Insert” tab in the Ribbon.
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

Use Find and Replace in Publisher- Instructions

Use Find and Replace in Publisher - Instructions: A picture of a user replacing text in the “Find and Replace” task pane in Publisher.
Use Find and Replace in Publisher: Overview             You use Find and Replace in Publisher to replace text for which you search with replacement text. To use Find and Replace in Publisher, click the “Home” tab in the Ribbon. Then click the “Replace” button in the “Editing” button group. Doing this then opens the “Find
Read more
No Comments

Navigating Worksheets in Excel – Instructions

Navigating Worksheets in Excel - Instructions: A picture of a user navigating worksheets in Excel by using the “Activate” dialog box.
Navigating Worksheets in Excel: Overview             Navigating worksheets in Excel lets you view different worksheets in a workbook. To move from one worksheet to another, click the worksheet name tab of the worksheet to view. The worksheet name tabs appear in the lower-left corner of the workbook.             You can also use keyboard shortcuts to
Read more
No Comments

Use the Rulers in Publisher- Instructions

Use the Rulers in Publisher- Instructions: A picture of a person using the rulers in Publisher.
Use the Rulers in Publisher: Overview             This lesson shows you how to use the rulers in Publisher. You can use the rulers in Publisher to help you make precise measurements. They can also help you place objects into the publication pages in the desired positions. The rulers in a Publisher publication appear at both
Read more
No Comments