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

Create Headers and Footers in Excel – Instructions

Create Headers and Footers in Excel - Instructions: A picture of the “Header” dialog box appearing in front of the “Page Setup” dialog box in Excel.
Create Headers and Footers in Excel: Overview             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 Setup” button group. Then click the “Header/Footer” tab
Read more
No Comments

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