The technological advances of the last ten years have caused a significant change in the real estate appraisal profession. For example, today nearly all databases are computerized; it is imperative that appraisers easily retrieve, list, and analyze large quantities of data. During this hands-on seminar, participants will use Microsoft Excel to develop a spreadsheet skill set that includes the use of thousands of the program’s applications. By developing spreadsheet skills that report statistical analysis and provide graphic illustrations, residential appraisers will have additional professional skills to meet the needs of a more diversified client base.
At the end of this seminar participants should be able to:
- Recognize the many advantages of using spreadsheet programs
- Illustrate the many uses of spreadsheet programs
- Copy, cut, and paste data from one location to another
- Identify common applications in spreadsheet programs that apply to real estate appraisal
- Identify basic statistical tools that can be used in appraisal development
- Recognize the applications of spreadsheet programs in the sales comparison approach
- Illustrate the use of spreadsheets to support units of comparison analysis
- Demonstrate the use of spreadsheets in a cost approach summary
- Identify various editing tools available for use in spreadsheets
- Illustrate use of basic spreadsheet procedures to perform basic mathematical functions
- Estimate the depreciation rates in a market utilizing spreadsheet tools
Prerequisites
Ability to perform basic mathematical calculations, cell formatting navigation, and file management in MICROSOFT® EXCEL