How to Create 3D Formulas in Microsoft Excel 2010

How to Create 3D Formulas in Microsoft Excel 2010: Video This video shows you how to create 3D formulas in Microsoft Excel 2010 and the additional punctuation marks and syntax you need to write them. Get the complete Excel tutorial here 3D Formulas in Microsoft Excel 2010: Overview It is helpful to be able to
Read more
No Comments

Cell Formatting in Microsoft Excel 2010

Cell Formatting in Microsoft Excel 2010: Video This video shows you how to apply cell formatting in Microsoft Excel 2010. Formatting Cells in Excel 2010: Overview Note that in the “Home” tab of the Ribbon, you have the “Font” group, the “Alignment” group, and the “Number” group. These groups contain buttons that allow you to
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

Writing Formulas in Microsoft Excel 2010

Writing Formulas in Microsoft Excel 2010 Using Ranged Syntax: Video This video shows writing formulas in Microsoft Excel by using a ranged formula syntax. Writing Formulas in Excel 2010: 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

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