Excel Training – Asset and Portfolio Management

Excel Training – Asset and Portfolio Management
Join us for an advanced Excel training designed to take your spreadsheet skills to new heights. In this comprehensive program, we will delve into advanced tools and techniques that will revolutionize the way you analyze and manipulate data. 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 discuss dynamic array functions, including XLOOKUP, FILTER, SORT, and other "table-based" tools.  Through hands-on exercises, practical examples, and real-world applications, you'll develop the skills and confidence to tackle complex data analysis tasks efficiently and effectively.


Excel Training - Asset and Portfolio Management

Join us for an advanced Excel training designed to take your spreadsheet skills to new heights. In this comprehensive program, we will delve into advanced tools and techniques that will revolutionize the way you analyze and manipulate data. 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 discuss dynamic array functions, including XLOOKUP, FILTER, SORT, and other "table-based" tools.  Through hands-on exercises, practical examples, and real-world applications, you'll develop the skills and confidence to tackle complex data analysis tasks efficiently and effectively.

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 knowledge of Excel is suggested. 

Course Faculty: Joshua Kahr, Principal, Kahr Real Estate
Live Training Date: Wednesday, September 25th, 5:30pm - 7:30pm ET
Price: $100 Members / $200 Non-Members 

Discounted pricing available for member companies purchasing 10+ registrations. Discounts are based per session and cannot be combined with other sessions or trainings.

Names and registration information for each attendee must be provided on the approved template (and submitted together). An invoice with the applied discount will then be provided. To submit your group registration or for additional registration questions contact Janie Lam.  

 

When
9/25/2024 5:30 PM - 7:30 PM
Where
Webinar - Digital Event

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.

Sign In

Get Future Event Notices!