On-Demand Event
Course Summary:
This course is designed to introduce participants to financial modeling and to provide participants with the skills necessary to create professional spreadsheets. The course will begin with an overview of how to use formulas and overview common built-in math, statistical, date, conditional and financial functions used in financial modeling. The course will acquaint students with multiple Excel shortcuts to allow students to learn or enhance Excel skills necessary to save time in building financial models. The course will next guide students through a construction of a basic pro-forma, focusing on the use of formulas, functions, shortcuts, and formatting. The purpose of the last session is to acquaint students with advanced Excel functions needed to build more complex Excel models. The course is taught using multiple real estate finance and investment examples, such as time value of money, loans, amortization table, and pro-forma.

Course Summary:This course is designed to introduce participants to financial modeling and to provide participants with the skills necessary to create professional spreadsheets. The course will begin with an overview of how to use formulas and overview common built-in math, statistical, date, conditional and financial functions used in financial modeling. The course will acquaint students with multiple Excel shortcuts to allow students to learn or enhance Excel skills necessary to save time in building financial models. The course will next guide students through a construction of a basic pro-forma, focusing on the use of formulas, functions, shortcuts, and formatting. The purpose of the last session is to acquaint students with advanced Excel functions needed to build more complex Excel models. The course is taught using multiple real estate finance and investment examples, such as time value of money, loans, amortization table, and pro-forma.

Details
Format

The course is eight hours long, delivered in four two-hour modules. It is available in a convenient on-demand format.

Type

On-Demand Course

Experience Level

Foundational

Career Stage

Beginning Professional

RELATED
Event Session

The EDC Presents: 2024: An Entertainment Development Odyssey: How Innovation Drives ROI

Rather than replicating tried, but tired, concepts, hear from industry leaders who embrace innovative strategies, technologies, and concepts to deliver unique, meaningful entertainment experiences across generations from boomers to gen Z. Moreover, t...
Reading List

2023 Spring Issue of Urban Land

The Spring 2023 issue of Urban Land is now available for ULI members. The cover topic is "Urban Suburbs: Innovative strategies to solve the global housing shortage."
Reading List

2023 Winter Issue of Urban Land

The 2022 Winter issue of Urban Land is now available for ULI members. The cover topic is "Exacting Standards: Outlook for property and development in 2023 ." Other topics include "Best Practices: Global Awards for Excellence," "Fall Meeting: Dallas D...
Topics
Finance & Investment

Introduction to Excel for Real Estate Professionals

Register