Starting PowerPivot in Microsoft Excel 2013

Starting PowerPivot in Microsoft Excel 2013: Video This video shows starting PowerPivot in Excel 2013. For the complete course click here. Starting PowerPivot in Excel 2013: Overview PowerPivot is an add-in that is included in Microsoft Excel Professional Plus 2013. It was also available in Excel 2010, but has seen many improvements to its functionality
Read more
No Comments

IOLTA Basics- Excel 2013 for Lawyers

IOLTA Basics: Video This video shows the IOLTA basics, including what an IOLTA account is and when to use an IOLTA account. IOLTA Basics: Overview An IOLTA, or Interest on Lawyer’s Trust Account, is used to hold client funds separately from the funds of a law firm or individual lawyer. An IOLTA account is an
Read more
No Comments

Microsoft Excel for Lawyers: Using the Law Firm Financial Analysis Worksheet

Microsoft Excel contains law firm templates that can be used by law firms, attorneys, lawyers, and anyone who practices law. In this post, we will cover the usage of the Law Firm Financial Analysis Worksheet.             Using the Law Firm Financial Analysis Worksheet Let’s examine the structure and usage of
Read more
No Comments

Writing Basic Formulas in Excel 2013

Writing Basic Formulas in Excel 2013: Video This video shows writing basic formulas in Excel 2013. Writing Basic Formulas in Excel 2013: Overview You use formulas to perform mathematical functions on cells. There are two basic ways of writing formulas available: “ranged syntax” or “simple syntax.” A “syntax” is simply a way of expressing or
Read more
No Comments

How to Write and Use Formulas in Microsoft Excel 2013

How to Write and Use Formulas in Microsoft Excel 2013: Video This video shows how to write and use formulas in Microsoft Excel 2013. Formulas in Microsoft Excel 2013: Overview You use formulas to perform mathematical functions on cells. There are two basic ways of writing formulas available: “ranged syntax” or “simple syntax.” A “syntax”
Read more
No Comments

Pasting Links between Cells in Excel 2013

You can paste links between cells within Excel, so that the value of a cell within a workbook will simply be the value of another selected cell. For example, if you had a cell that added the cells above it within one worksheet and you wanted to paste a link to that cell into a
Read more
No Comments

How to Insert Bullets in Excel 2013- Microsoft Office Training

Unlike Microsoft Word, Excel does not contain a button to insert bullets into a cell. However, there are a few ways you can add bullets in Excel.   1. Click into the cell where you want to add a bullet. 2. Press Alt+7 on your numeric keyboard to enter a generic bullet. 3. To quickly
Read more
No Comments

Creating Charts in Microsoft Excel 2013

Excel 2013 allows you to create charts from the data stored in a worksheet more easily than in previous versions. Charts are useful for times when you wish to create visual representations of the worksheet data for meetings, presentations, or reports. To insert a chart, first select the cell range that contains the data that
Read more
No Comments