Excel SCAN Function

Learn how to use the new Excel SCAN function! This function is a Lambda helper function. You can use it to "scan" a range and apply a calculation to each cell. In this example you'll learn how to use SCAN to get to-date values and how you can tweak it to return YTD values.

Calculating Returns for a Rental Property

Properly calculate returns on your rental property investment. This free Excel ROI calculator, makes it easy for you. In fact, you can use it to calculate the returns on any type of investment.

Cash vs Accrual Accounting

There are 2 different accounting methods: Cash Accounting and Accrual Accounting. Check out this article which explains the difference with a story. This makes it really easy to understand the difference between cash basis and accrual method of accounting.

Balance Sheet Secrets REVEALED with a Fun Demo

Balance Sheet Secrets REVEALED with a Fun Demo In this post, we're going to cover the basics of the balance sheet.  It's also called the statement of financial position. This is where many people get confused. I'm going to be honest with

PROPERLY Record Debits and Credits with Examples

PROPERLY Record Debits and Credits with Examples (EASIEST Method) Today we're going to apply our knowledge of debits and credits.  I'll show you how this translates into recording actual example transactions. We're going to use T-accounts in the beginning and move on

Debits and Credits MADE EASY with ADEx LER

Debits and Credits MADE EASY with ADEx LER If you want to learn accounting, the concept of debits and credits is one of the most important to understand. But, many struggle with it and for me, it was the same in the

Accounting Basics Explained Through a Story

Accounting Basics Explained Through a Story In this post, I'll give you an introduction to accounting by telling you a story. It's a story about Claudio, and how he runs his business in Italy. Before we start, let's just get clear on