Copy and Paste List Data from Excel into QuickBooks Pro- Instructions

A picture of the “Add/Edit Multiple List Entries” window that lets you copy and paste list data from Excel into QuickBooks Pro.
Overview of How to Copy and Paste List Data from Excel into QuickBooks Pro:             A feature that improves the speed of company file creation is the ability to copy and paste list data from Excel into QuickBooks Pro. You can copy and paste list data from Excel into QuickBooks Pro to add it into
Read more
No Comments

Record a Macro in Excel – Instructions and Video Lesson

A picture that shows how to record a macro in Excel using the “Record Macro” dialog box.
Overview of How to Record a Macro in Excel:              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,
Read more
No Comments

Accept or Reject Changes to a Shared Workbook in Excel – Instructions

A picture showing how to accept or reject changes to a shared workbook in Excel if using the traditional “Shared Workbooks” feature.
Overview of How to Accept or Reject Changes to a Shared Workbook in Excel             If using the traditional “Shared Workbooks” feature in Excel, you can then either accept or reject changes to a shared workbook in Excel after highlighting the changes made. To accept or reject changes to a shared workbook in Excel, click
Read more
No Comments

Create Headers and Footers in Excel – Instructions

Create Headers and Footers in Excel - Instructions: A picture of the “Header” dialog box you can open from the “Page Setup” dialog box in Excel.
Create Headers and Footers in Excel: Overview How to Create Headers and Footers in Excel             To create headers and footers in Excel, open the “Page Setup” dialog box. To do this, click the “Page Layout” tab in the Ribbon. Then click the “Page Setup” dialog box button in the lower-right corner of the “Page
Read more
No Comments

Insert an Excel Worksheet into a Word Document – Instructions

Insert an Excel Worksheet into a Word Document - Instructions: A picture of a user inserting an Excel spreadsheet into a Word document.
Insert an Excel Worksheet into a Word Document: Overview How to Insert an Excel Worksheet into a Word Document             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
Read more
No Comments

Hide Columns or Rows in Excel – Instructions and Video Lesson

Hide Columns or Rows in Excel - Instructions: A picture of a user hiding selected columns in an Excel workbook.
Hide Columns or Rows in Excel: Overview             You can hide columns or rows in Excel that contain sensitive data. You can do this to hide data you need for formulas but don’t want to show in a worksheet, like salary information, for example. Hiding a column or row conceals its display, but still uses
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 selected columns 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

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