Cost: $700 per person

Get Excel training from the number one real estate training provider in the country. Learn key Excel functionality that will save you time the very next day you return to the office. This class uses commercial real estate examples and covers a wide array of topics including:

Using look-up formulas in Excel (VLOOKUP, HLOOKUP, MATCH, INDEX, SUMPRODUCT) - 30 minutes

·         Building an amortization table from scratch (covers design techniques, different ways to create date series, range names, Subtotal feature)

·         Using Excel data tables

·         Excel pivot tables and pivot charts

·         Using Excel's formula auditing tools

·         Using keyboard shortcuts in Excel

·         Customizing your Excel environment (discusses overlooked settings that can help the user be more efficient in Excel)

·         Conditional formatting

·         Creating custom lists in Excel (allows the user to store a list of buildings, portfolios, or anything else for easy reuse later)

·         Compare and contrast XIRR, XNPV, IRR, and NPV

·         Using the OFFSET function in Excel to create dynamic cash flows, NPVs, and IRRs

·         Using the Data Validation feature in Excel to create in-cell drop-down lists

·         Introduction to Macros (brief overview regarding macros and explains how to create simple macros)

·         Excel chart tricks and techniques

·         Concatenating and transforming text (combining words in different cells together, changing case, eliminating spaces)

·         Linking text files to Excel spreadsheets (helpful in automating links to Argus export files, such as cash flows or rent rolls)