Enable Power Pivot in Excel – Instructions

Enable PowerPivot in Excel - Instructions: A picture of a user enabling the Data Analysis add-ins within the “Excel Options” window in Excel for Office 365.
Enable Power Pivot in Excel: Overview             This lesson shows you how to enable Power Pivot in Excel. Power Pivot expands the abilities of the Excel data model to allow for robust data management and reporting for PivotTables and PivotCharts. Before you can start using Power Pivot, however, you must enable it in Excel. Power
Read more
No Comments

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

The Pv Function- Excel for Lawyers Tutorial and Video Lesson

The Pv Function- Excel for Lawyers Tutorial: A picture of a user creating a formula that uses the Pv function in Excel.
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. You can use these functions to help both the law firm as well as its clients.
Read more
No Comments

The Fv Function- Excel for Lawyers Tutorial

The Fv Function- Excel for Lawyers Tutorial: A picture of the Fv function being used in Excel.
The Fv Function: Overview             The Fv function assists you in determining the future value of an investment based on periodic but constant payments with a constant interest rate. The future value is the total amount that a series of payments will be worth at a specified future time. For example, if you saved $100
Read more
No Comments

Buy Excel 2019 and 365 Training for Lawyers

Buy Excel 2019 and 365 Training for Lawyers: A picture of the training interface for the DVD and digital download versions of the “Mastering Excel Made Easy for Lawyers v.2019 and 365” tutorial.
Buy Excel 2019 and 365 Training for Lawyers- Now Available from TeachUcomp, Inc.             TeachUcomp, Inc. is pleased to announce you can now buy Excel 2019 and 365 training for lawyers with the release of our “Mastering Excel Made Easy for Lawyers v.2019 and 365” tutorial. This tutorial provides training for legal professionals on using
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

Apply Password Protection to an Excel File – Instructions

Apply Password Protection to an Excel File - Instructions: A picture of a user adding a password for opening the Excel file to a workbook.
Apply Password Protection to an Excel File: Overview             When you apply password protection to an Excel file, you prevent people from opening it without knowing the required password. After password protection is enabled on a file, no one can open it without the password. Therefore, password-protecting files poses some risk. This is because if
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