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

Custom Font Schemes in Publisher- Instructions

Custom Font Schemes in Publisher- Instructions: A picture of the “Create New Font Scheme” dialog box in Publisher.
Custom Font Schemes in Publisher: Overview             You can create custom font schemes in Publisher to use in your publications. To create custom font schemes in Publisher, click the “Page Design” tab in the Ribbon. Then click the “Fonts” drop-down button in the “Schemes” button group. Then select the “Create New Font Scheme…” command from
Read more
No Comments

Format a PivotTable in Excel – Instructions and Video

Format a PivotTable in Excel: A picture showing the “Design” tab of the “PivotTable Tools” contextual tab in the Ribbon of Excel.
Format a PivotTable in Excel: Overview             You can apply preset styles to format a PivotTable in Excel. To format a PivotTable in Excel, click into any cell in the PivotTable. Then click the “Design” tab of the “PivotTable Tools” contextual tab within the Ribbon. Then click the desired style to apply from the listing
Read more
No Comments

Make Columns in Publisher – Instructions

Make Columns in Publisher - Instructions: A picture of the “Grid Guides” tab in the “Layout Guides” dialog box in Publisher.
Make Columns in Publisher: Overview             You can make columns in Publisher to aid in the layout of a publication page. You can then add text boxes over the column guides you create in the page to produce newsletter-style layouts. When you make columns in Publisher, you can also add rows to a publication page.
Read more
No Comments

Create a PivotChart in Excel- Instructions and Tutorial

Create a PivotChart in Excel: A picture of a user adding fields to the “PivotChart Fields” task pane in Excel.
Create a PivotChart in Excel: Overview             You can create a PivotChart in Excel to show the data from an associated PivotTable in a graphic format. You can create a PivotChart in Excel either independently from or along with an associated PivotTable in Excel. Alternatively, you can also add a PivotChart to an existing PivotTable
Read more
No Comments