REFM Excel Bootcamp Interactive Webinar (Virtual Attendance)

In this 3-hour, interactive, online-only session from Real Estate Financial Modeling, you will learn the basics of operating in Excel as well as advanced techniques. You will follow along in Excel in real-time and perform exercises to ensure you are grasping the lesson and are mastering the technical skills being taught. You will be able to ask your questions in real-time to have them answered by the Instructor on a rolling basis.

Who Should Attend

Professionals and students who want to grasp and master basic and advanced Excel operation and techniques.

Attendees Include

Property owners and developers, real estate company employees, property managers, architects, landscape architects, land use and transaction attorneys, construction executives and project managers, consultants, planning and zoning agency officials, government and economic development officials, non-profit organization employees, engineers, residential realtors and marketers, university faculty and undergraduate and graduate students.

Topics Covered Include *

Arithmetic and Rounding
Statistics
Relative vs. Absolute Cell References
Inserting and Deleting Rows and Columns
Dates and Timelines
Conditional Statements
Function Wizard
Creating Summary Tables
Formatting Numbers
Conditional Cell Formatting
Data Table Lookup Functions
Custom Formatting
Format Painting
Paste Special
Transpose
Avoiding Error Messages
Financial Functions for Compounding and Discounting
Internal Rate of Return (IRR)
Mortgage Payment Calculation
Formula Auditing
Data Tables for Sensitivity Analysis
Circular References
Keyboard Shortcuts
Best Practices

* All Topics Include Exercises

Excel Formulas Taught Include

SUM
ROUND, ROUNDUP, ROUNDDOWN
MAX, MIN, AVERAGE, MEDIAN
Cell Anchoring using Dollar Signs
EOMONTH, EDATE, DATEVALUE
IF, AND, OR, and combinations thereof
SUMIF, SUMIFS
COUNTIF, COUNTIFS
VLOOKUP, HLOOKUP
IFERROR
RATE
PV, FV
NPV and XNPV
IRR and XIRR
PMT, PPMT, IPMT

Instructor: Kirsch

• < Previous Event
• Next Event >

Comment