Move a Chart in Excel- Instructions

Move a Chart in Excel- Instructions: A picture of the “Move Chart” dialog box in Excel.
Move a Chart in Excel: Overview             You can easily move a chart in Excel. When you insert a new chart into a worksheet, it appears as an embedded chart object in the worksheet. When you embed a chart in a worksheet, you can move it and also resize it in the worksheet. Before you
Read more
No Comments

Set Margins in Excel – Instructions

Set Margins in Excel - Instructions: A picture of the “Margins” tab within the “Page Setup” dialog box in Excel.
Set Margins in Excel: Overview             To set margins in Excel worksheets before printing, open the “Page Setup” dialog box. To open the “Page Setup” dialog box, click the “Page Layout” tab in the Ribbon. Then click the “Page Setup” dialog box button in the lower-right corner of the “Page Setup” button group. Then click
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

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

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

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

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

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