Search Results

Time Value of Money is an important concept for making good decisions when it come to money. The good news: We can easily calculate it in Excel with the NPV function.

Quickly create a data linked organizational chart in Excel with this new free tool available in Excel for Office 365. This free Visio add-in can take data from an Excel table and visualize it as an Org chart.

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.

Find out how you can generate UPC barcodes in Excel that work! I tested it with a scanner and the Excel barcodes could be scanned. The solution uses a combination of Excel VBA, formulas and conditional formatting.

Properly referencing a cell is THE most important rule you need to master in Excel. Should the reference be relative, absolute or mixed? I explain it all in this quick article.

Sometimes the data you copy or import into Excel has stubborn spaces that can’t be removed with the TRIM function. You need a different function to remove these nonbreaking spaces. Something that acts like a TRIM ALL function in Excel.

The cash flow statement shows how effective a business is in managing its cash. It can be tricky to understand. I’ve got you covered! Follow this explanation and you’ll understand the basics of cash flow in no time.

With Excel 3D formulas you get to combine data from multiple worksheets into one summary sheet. This article includes a bonus Excel hack which shows you how to use wildcards in 3D reference formulas.

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.

Quickly learn how to use Excel’s DGET Function to lookup one or more criteria. DGET can also do a left lookup (unlike VLOOKUP). It’s a forgotten Excel database function. Can you apply DGET to a range of cells? Find out in this article.

Excel’s new FILTER Function will save you a ton of time! It’s like doing a VLOOKUP but returning all matches instead of the first match. You can even match for multiple criteria AND return all match results in Excel.

If you’re printing large tables in Excel, you need to make sure you repeat the row headers on top and the column labels on the left. This way every printed Excel sheet includes the table headings.