Excel’s power stems from its ability to perform calculations on the values you’ve stored in a workbook—something you do with formulas and functions. This section describes how to construct formulas; use Excel’s predefined formulas, called functions; and use range names in formulas. It also shows how … [Read more...] about Quick Primer on Excel: Using Formulas and Functions
Using Excel
Quick Primer on Using Excel: Workbook Basics
If you’re new to Excel, you’ll benefit most from a quick tour of Excel, including how you start Excel, work with its windows, and create and save a workbook. That’s what we’ll do here. This discussion assumes you’re comfortable working with Microsoft Windows. You should know, for example, how to … [Read more...] about Quick Primer on Using Excel: Workbook Basics
Analyzing Multifamily Real Estate Investments
Analyzing multifamily real estate investments is challenging because such analysis requires both complicated tax and financial calculations. To show clients and others how this analysis is supposed to work, our firm created a simple starter Excel workbook. You can download the multifamily real … [Read more...] about Analyzing Multifamily Real Estate Investments
Real Estate Tax Traps: The Three Biggest Mistakes
New and potential real estate investors, unfortunately, often fall into one or more serious tax traps. Accordingly, the discussion that follows identifies these traps, or mistakes, and then ways to side-step the trouble. Some of the material covered in the paragraphs that follow is a little, … [Read more...] about Real Estate Tax Traps: The Three Biggest Mistakes
Refreshing, Rearranging, and Modifying Imported Data
Refreshing Imported Data Over time, of course, your accounting database changes as it’s updated to reflect new activity.To refresh the imported data for these changes, simply click the Update button,which appears on the Startup Screen of the Small Business Financial Manager workbook. The Small … [Read more...] about Refreshing, Rearranging, and Modifying Imported Data