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
Reading List

Urban Land's Best of 2020 Reading List

In a year that brought many challenges, these articles were among the most popular with ULI members for all of 2020. Presented by Owen Thomas, ULI Global Chairman.
Report

Emerging Trends in Real Estate®: Asia Pacific 2021

Throughout 2020, the success of government efforts across Asia Pacific to contain the spread of COVID-19 has helped limit its impact on local real estate markets. At the same time, however, there is a sense that asset values have been propped up by a...
Article

The Coming of the Climigrants

As climate change puts coastal areas at risk from rising seas and subjects Sun Belt and Southeast cities to hotter temperatures, some of their residents may go elsewhere. Experts say it is time to start preparing.
Topics
Finance & Investment

Introduction to Excel for Real Estate Professionals

Register

Featured Content Pillars

  • Housing and Communites
  • Real Estate Finance and Investment
  • Sustainability and Economic Performance
  • Innovation in Development Practice
  • Shaping Successful Cities and Regions