• Recognize best practices and what to consider in financial model development
• Demonstrate how and when to use defined names in cells and ranges
• Identify key inputs in maximum building-size calculations
• Describe how to use key features of a spreadsheet program to easily make complex calculations
• Identify key inputs in land residual analysis
• Identify key inputs in feasibility rent analysis
• Recognize complex highest and best use analysis
• Recognize the basic concepts in sorting
• Analyze the outlining function in Excel
• Demonstrate skills in filtering data
• Identify the basic concepts and filtering skills within pivot tables

Who Should Enroll
Real estate appraisers, reviewers, real estate brokers, and underwriters

Prerequisites
This seminar is for participants with a basic level of knowledge of spreadsheets, especially Excel, such as those obtained from the Using Spreadsheet Programs in Real Estate Appraisals seminar. Participants should have experience in market analysis, highest and best use, and inferred market analysis.

Note. This seminar will be taught from Windows using Excel 2007. If you are taking the seminar and plan to use an Apple laptop, you will need to have the latest version of Excel (2011) in order to perform some of the exercises. 

Note. This seminar is hands-on! When participants receive their registration e-mail confirmation, a secure link will be available where they will be instructed to download Excel files to use for in-class exercises. Be sure you download these files prior to coming to class.

Note. This seminar will be taught from Windows using Excel 2007. If you are taking the seminar and plan to use an Apple laptop, you will need to have the latest version of Excel (2011) in order to perform some of the exercises.