This class is targeted for anyone who is looking to take their spreadsheet skills to the next level. We will cover advanced tools in Excel including the "What If" tools, the use of INDEX(MATCH()), conditional SUMPRODUCT, OFFSET, and how to build better data tables for sensitivity analysis. This course will also review the new XLOOKUP which is a beta feature that was rolled out this past July. Specific real estate finance problems will be discussed and how best to use the toolkit in Excel to solve them. There will also be coverage of the "new" dynamic array functions that are being implemented in 2020. All attendees will receive a suite of unlocked spreadsheets in Excel for their own professional use.
Course Faculty: Joshua Kahr, Principal, Kahr Real Estate
Live Training Date: Wednesday, October 21st, 5:30pm - 7:30pm ET
Price: $100 Members / $200 Non-Members
View our Events Frequently Asked Questions page for additional information.
Please verify your contact and name badge information before checking out.
REGISTRATIONS ARE NON-REFUNDABLE. If a registrant is unable to attend a substitute will be accepted at no additional charge.
In order to register for an event or purchase a product, you must be logged into the CREFC site. If you have not visited our site before, please create a new account.