Share this page

Events

Excel Training Asset and Portfolio Management

Excel Training – Asset and Portfolio Management 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 were implemented in 2020. All attendees will receive a suite of unlocked spreadsheets in Excel for their own professional use. Please Note: This session will NOT be recorded and users will only be able to participate in it during the scheduled time-slot. Intermediate level knowledge of Excel is suggested. Course Faculty: Joshua Kahr, Principal, Kahr Real Estate Live Training Date: Tuesday, May 18th, 5:30pm - 7:30pm ET Price: $100 Members / $200 Non-Members

Excel Training – Asset and Portfolio Management

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 in July 2020. 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 were implemented in 2020.

All attendees will receive a suite of unlocked spreadsheets in Excel for their own professional use.

Please Note: This session will NOT be recorded and users will only be able to participate in it during the scheduled time-slot.

Intermediate level knowledge of Excel is suggested.

Course Faculty: Joshua Kahr, Principal, Kahr Real Estate

Live Training Date: Tuesday, October 26th, 5:30pm - 7:30pm ET

Price: $100 Members / $200 Non-Members

Discounted pricing available for member companies purchasing 10+ registrations for this event. All names must be submitted to CREFC together and an invoice with the applied discount will be provided. For additional information contact Danielle Nathan.

When

10/26/2021 5:30 PM - 7:30 PM

Where

Webinar - Digital Event, Online

Questions?

View our Events Frequently Asked Questions page for additional information.

Please Note:

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.

By registering for this event, you agree to CREFC's Terms & Conditions and Code of Conduct.

Note:

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.