What is the Offset Function? The offset function is a powerful Excel formula, the purpose of which is to return a single value or a range of values that is a given number of rows or columns from a specified reference (i.e. a specific cell – your
Read more →
Automatically Alternate Row Coloring in Excel Two Ways to Alternate Row Coloring in Excel If you’re using excel 2007 or 2010, probably the quickest and easiest way to get automatically alternate row coloring is by using Excel’s built-in table feature. However, there are several instances when the solution
Read more →
If you spend a lot of time on the keyboard, learning a few tricks will not only speed things up but simplify your life. All of the shortcut keys below are Excel focused. This is a free template for download, and you can easily modify it to
Read more →
Simple, easy to use, free Excel invoice templates that can be customized to fit your specific circumstance. Perfect for companies in the service, construction, consulting, or sales and service industries. These invoice templates can all be downloaded for free and modified to fit your billing needs. Excel
Read more →
Take useful Excel Add-in’s and add them to your Quick Access Toolbar. The Quick Access Toolbar is located at the top of the Ribbon as shown below. Add an Add-in to the Quick Access Toolbar and assign it it’s own unique icon in 4 easy steps. How
Read more →
How do I keep track of when to follow-up on open invoices? Or a more simple way to put it, ‘How do I manage accounts receivable’? This was a question from an accounts receivable manager who was trying to monitor contact with multiple customers. The time between when
Read more →
Need a European-style Black-Scholes calculator to compute the value of a Put Option or Call Option? Just interested in how the calculation works? Want something just to double check a calculation? Either way, this spreadsheet will help. All of the formulas can be read (and modified if you
Read more →
Download this bank reconciliation template and incorporate it into your month-end close process. A bank reconciliation is a check between your records (or your company’s) and the banks records. It is a necessary control for every cash account. Going through the bank reconciliation process can identify errors and
Read more →
Every business should leverage an accounts receivable aging to manage balances outstanding. However, not every business has the need for an expensive accounts receivable ledger or system. This accounts receivable aging is an excel template that makes it easy to age invoices. It’s also been designed to
Read more →
The percentage of completion schedule calculates the amount of revenue to be recognized for long-term construction-type contracts. There are other acceptable methods of revenue recognition, but the cost-to-cost method used in this template is one of the more popular. The cost-to-cost method provides for proportional recognition of revenue
Read more →