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

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

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

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

Data Visualizations in Power View in Excel – Instructions

Data Visualizations in Power View in Excel - Instructions: A picture of the “Design” tab within Power View in Excel.
Data Visualizations in Power View in Excel: Overview             You can visualize report data in a Power View worksheet by adding data visualizations in Power View in Excel. To add data visualizations in Power View in Excel, drag a data field from the “Power View Field” task pane into the “Fields” section of the task
Read more
No Comments

Add Excel Tables to a Data Model in Excel 2016- Instructions

Add Excel Tables to a Data Model in Excel 2016- Instructions: A picture of the “Workbook Connections” dialog box in Excel, showing references to Excel tables in the data model.
Add Excel Tables to a Data Model in Excel 2016: Overview             You can manually add Excel tables to a data model in Excel 2016 or earlier workbooks. You can then use them as the data source for PivotTables and PivotCharts. Note that this process has changed in Excel 2019 and Excel for Office 365.
Read more
No Comments