Ready to Checkout?


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-

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

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

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

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

Insert Slicers and Delete Slicers in Excel: Overview             This tutorial shows how to insert slicers and delete slicers in Excel. Within Excel, slicers visually filter data within Tables, PivotTables, PivotCharts, data visualizations in Power View, and Power Pivot tables and charts. To insert a slicer into a worksheet, with the exception of a data

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,”

Add Excel Tables to a Data Model: Overview             You can manually add Excel tables to a data model within a workbook. You can then use them as the data source for PivotTables, PivotCharts and Power View reports. Before doing this, however, first create the necessary tables within Excel. Also, to add Excel tables to