Tag Archive for: Excel Tip

, , ,

Real Estate Financial Modeling Accelerator (Updated June 2025)

Before launching the Accelerator program, Michael and I received countless emails requesting a more structured, step-by-step real estate financial modeling training program. Over the years, we've covered hundreds of real estate modeling…
,

Microsoft has blocked the macros in my A.CRE model – What now?

When downloading and opening an Excel model from A.CRE, some users may get the ominous message: "Microsoft has blocked macros from running because the source of this file is untrusted." If you've received this message, you're probably asking,…
, , ,

Tutorial on How to Model Irregular Growth Rates in Real Estate

When building a real estate financial model, managing income and expense growth is rarely as simple as applying a fixed growth rate year over year. In real estate investment analysis, growth assumptions need to be flexible, dynamic, and reflective…
, , , , ,

Supercharge Excel with the ‘Excel 4 CRE’ Add-In – Now with AI (Updated Mar 2025)

Today, we're thrilled to share with the A.CRE community a new timesaving (and free) Excel tool: the 'Excel 4 CRE' Add-in! Over the past few years, we at A.CRE (together with our new favorite companion, ChatGPT!) have been developing and sharing…
SUMIF and Other Excel Functions for Real Estate Analysis
,

Using COUNTIFS, SUMIFS, and AVERAGEIFS Excel Functions in Real Estate Underwriting (Updated Dec 2024)

Why use COUNTIFS, SUMIFS, and AVERAGEIFS functions in real estate? When real estate analysts first start their careers, they're often required to work with large data sets and to transpose property and portfolio information from one format to…
, , , , , , ,

How to Run Monte Carlo Simulations in Excel (Updated Aug 2024)

So you want to run Monte Carlo simulations in Excel, but your project isn't large enough or you don't do this type of probabilistic analysis enough to warrant buying an expensive add-in. Well, you've come to the right place. Excel's built-in…
SUMPRODUCT Weighted Average
, ,

Using SUMPRODUCT to Calculate Weighted Average in Real Estate (Updated Aug 2024)

In my experience, using the SUMPRODUCT function in Excel to calculate weighted average is one of the most oft-used Excel techniques in real estate financial modeling. I learned this technique on day one of my first real estate internship and…
, , ,

A.CRE Geocoding Excel Add-in to Auto-Populate Latitude and Longitude in Excel (Updated Jun 2024)

The A.CRE Geocoding Excel Add-in uses the Google Geocoding API to automatically convert a given address to latitude and longitude coordinates, or to convert a given latitude and longitude coordinate to an address. The add-in makes auto-populating…
, , ,

Hide and Unhide Tabs using Drop-down Menus in Excel (Updated Apr 2024)

I'd like to share a handy little trick I learned this week for hiding and unhiding tabs in Excel using drop-down menus. Now this method requires you to use some basic VBA code and to save the Workbook as a Macro-Enabled file but don't be intimidated…
, , , , ,

The Definitive Guide to Microsoft Excel for Real Estate (Updated Apr 2024)

Microsoft Excel is the primary tool used by real estate financial modeling professionals. Even while numerous non-Excel alternatives have attempted to de-throne Excel, the 35+ year-old software has shown to be surprisingly resilient to competition.…
,

The Conditional Weighted Average – SUMPRODUCT with SUMIF (Updated Apr 2024)

Consider this scenario: you have a 50 tenant rent roll, consisting of various tenant types (i.e. small inline, large inline, junior anchor, anchor, etc.), and you want to calculate the weighted average rent for each tenant type. If I asked you,…
, , , ,

La Técnica del Cortocircuito – Cómo Corregir Errores de Referencia Circular en Excel

Cuando estás empezando a aprender sobre Excel y te enfrentas a libros de trabajo que utilizan cálculos iterativos para resolver fórmulas con lógica circular, es fácil cometer errores de referencia circular. Imagina que introduces un valor…
, , , , ,

Using ChatGPT as a Real Estate Analyst – Sales Comp Analysis (Updated Aug 2023)

In early 2023, we here at A.CRE began exploring use cases for AI in commercial real estate. Since that time, we have released nine such posts covering topics such as using AI in the real estate job search, using AI to expand on Excel's capabilities,…
, , , ,

The Circuit Breaker – How to Fix Circular Reference Errors in Excel

If you've spent much time working with elaborate Excel workbooks that rely on iterative calculations to solve formulas with circular logic, you've undoubtedly come across a problem where if you accidently put an erroneous value in an input…
, , , ,

Using ChatGPT to Create Excel Logic #2 – Annual to Monthly Growth

Another post in a growing series on how to use ChatGPT in commercial real estate. In our real estate financial modeling Accelerator program we have a Q&A. Members of the Accelerator ask the A.CRE team questions, and we provide answers. Depending…
, , , ,

Using OpenAI’s ChatGPT to Build the ‘Excel 4 CRE’ Add-In

This is another post in our growing series on how to use ChatGPT in commercial real estate. In this post, I show you how I used ChatGPT to build an Excel Add-in. For a bit of back story. A.CRE recently set out to create a free Excel add-in…