Home | Site Map | Contact Us
  View Cart              View Cart             
0 Registrations in Cart
 
 
Welcome. If you are a returning student or previously created an AI website account, please log in.
Back to Schedule  |  Select an Offering  |  Forgot Password?  |  Create Login
 
   


Advanced Spreadsheet Modeling for Valuation Applications

CALL   Date: May 16 - 17, 2013   Location: Pittsburgh, PA
 
  Seminar    
Category  General/Residential [G/R]  
Attendance Hours  14.0  
Current Price  $ 255.00
 
  Instructor    
Mark V. Smeltzer, SRA  
    
 
  Location    
Name  Doubletree by Hilton Pittsburgh/ Greentree  
Address  500 Mansfield Avenue  
City  Pittsburgh  
State  PA  
Zip  15205  
 
Click Here to check state approvals
     
 
  Sponsor / Contact    
Chapter  Pittsburgh Metropolitan
Website  www.pghai.org  
Contact Name  Mary Ann Hertzig  
Email  maryannh@realtorspgh.com  
Phone  (412) 563-1900  
 
  Description    
This two-day seminar will teach appraisers to prepare advanced analyses in a simpler manner and with less error. It will appeal to participants with experience in market analysis and highest and best use and also those with experience in applying inferred market analysis. The focus is on problem solving and efficiency while uncovering some of the tools of the spreadsheet program that will make an analysis stronger and increase productivity. Participants will find the applications especially helpful in the areas of market analysis, feasibility analysis, and highest and best use. Instruction on property modeling and pivot tables is also included. Each part of the Seminar Handbook includes techniques to solve real world problems and assist appraisers in developing best practices in modeling that can be applied in other situations.

At the end of this seminar participants should be able to:
  • 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. 

 
  Equipment    
All students MUST HAVE a laptop computer with MICROSOFT Excel 2007 loaded and operational. Be sure that Solver Add-in and Analysis Tool Pak Add-in are installed prior to class. If you do not currently own MICROSOFT EXCEL, you can download a free copy for 60 days at http://office.microsoft.com/en-us/try/.

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.
 
  For Further Reading    
•  Visual Valuation: Implementing Valuation Modeling and Geographic Information Solutions  
 
  Disclaimer    
Cancellation Policy
  • Up To 15 days prior to program start date, refund in full.
  • 7 - 14 days prior to program start date, $50.00 cancellation fee.
  • Less than 7 days prior to program start date, forfeit of payment.
   Transfer Policy
  • Up To 15 days prior to program start date, no transfer fee.
  • 7 - 14 days prior to program start date, $25.00 transfer fee.
  • Less than 7 days prior to program start date, no transfer allowed.
    


Program materials can be downloaded by the student or can be picked up at the site.
 
  Additional Information    
The Advanced Spreadsheet Modeling for Valuation Applications will be held at DoubleTree by Hilton Pittsburgh/Greentree (pittsburghgreentree.doubletree.com). Student must have a laptop with MICROSOFT Excel 2007. Be sure that Solver add-in and Analysis Tool Pak Add-in are installed prior to class. If you do not currently own MICROSOFT Excel, you can download a free copy of 60days at http://office.microsoft.com/en-us/try/. Check in anytime between 8-8:30am class begins at 8:30am. Tuition includes material and coffee breaks..no other food included..student on their own for lunch.

DoubleTree Pittsburgh/Greentree is located at 500 Mansfield Ave., Pittsburgh PA 15205. Contact Frank Colega for room rate at 412-920-8073 or frank.colega@camhosp.com.
OR TRY PRICELINE.COM A NUMBER OF STUDENTS WERE ABLE TO GET BETTER RATES AT SOME OF THE OTHER HOTELS IN THE AREA BY USING PRICE LINE.COM.

Any questions contact Mary Ann Hertzig at 412-563-1900 or maryannh@realtorspgh.com.