Format Trendlines in Excel Charts – Instructions

Format Trendlines in Excel Charts - Instructions: A picture of a user formatting a trendline in an Excel chart using the “Trendline Options” section of the “Format Trendline” task pane.
Format Trendlines in Excel Charts: Overview             You can easily format trendlines in Excel charts if you applied them to one or more chart series. To format trendlines in Excel, click the “Format” tab within the “Chart Tools” contextual tab in the Ribbon. Then select a trendline to format from the “Chart Elements” drop-down in
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

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

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

Outline Excel Data in Microsoft Excel – Instructions

Outline Excel Data in Microsoft Excel - Instructions: A picture of an Excel worksheet with an auto outline applied.
Outline Excel Data in Microsoft Excel: Overview             You can outline Excel data to add an organizational quality to a long or wide worksheet. When you outline Excel data, you group worksheet data into different levels based on column and row headings. Lower level data is associated with the headings in the rows or columns.
Read more
No Comments

Split Panes in Excel – Instructions and Video Lesson

Split Panes in Excel - Instructions and Video Lesson: A picture of a user splitting a large Excel workbook into separate panes.
Split Panes in Excel: Overview             To split panes in Excel when viewing a large worksheet, use the “Split” command in Excel. This command lets you split the Excel worksheet into different panes. Each pane contains its own horizontal and vertical scroll bars. Therefore, you can scroll each pane separately to view information from different
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

Insert an Excel Worksheet into a Word Document – Tutorial

Insert an Excel Worksheet into a Word Document – Tutorial: A picture of a user inserting an Excel spreadsheet into a Word document.
Insert an Excel Worksheet into a Word Document: Overview             You can easily insert an Excel worksheet into a Word document to harness the power of Excel within Word. This helps Word users who like creating worksheets and performing calculations in Microsoft Excel. To insert an Excel worksheet into a Word document, you must have
Read more
No Comments