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

Copy and Paste List Data from Excel into QuickBooks Pro- Instructions: A picture of the “Add/Edit Multiple List Entries” window in QuickBooks Pro.
Copy and Paste List Data from Excel into QuickBooks Pro: Overview             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 the “Customers,” “Vendors,”
Read more
No Comments

Export a PDF to Excel- Instructions and Video Lesson

Export a PDF to Excel- Instructions: A picture of a user exporting a table in a PDF to Excel by using the “Export Selection As…” command.
Export a PDF to Excel: Overview             Acrobat provides you with options when you want to export a PDF to Excel. Acrobat can export an entire PDF, or only a selected table within a PDF, as Excel worksheets.             To export a selected table as an Excel worksheet, choose the Selection Tool within the Page
Read more
No Comments

The Pv Function- Excel for Lawyers Tutorial and Video Lesson

The Pv Function- Excel for Lawyers Tutorial: A picture of the Pv function being used within an Excel worksheet to calculate the present value of an insurance annuity.
The Pv Function: Overview             This lesson shows you how to use the Pv function in Excel. Most of the functions that a lawyer needs to know assist them in business and financial computations. These functions can be used both for the law firm as well as for its clients-
Read more
No Comments

Remove Cell Formatting in Excel – Instructions

Remove Cell Formatting in Excel - Instructions: A picture of a user clearing cell formatting from selected cells in an Excel workbook.
Remove Cell Formatting in Excel: Overview             You can remove cell formatting in Excel to clear all the currently applied cell formatting. Removing cell formatting is also called clearing cell formatting. Doing this lets you remove cell formatting that causes problems from selected cells. The contents of the cell are not affected by removing the
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

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