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

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