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
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.
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
Format Error Bars in Charts in Excel: Overview You can format error bars in charts in Excel if you add them to a chart. To format error bars in charts in Excel, first choose the set of error bars to format. To do this, click the “Format” tab within the “Chart Tools” contextual tab.