Class Schedule General Information Continuing Education Credits Contact Us


Course:	Advanced Spreadsheet Modeling for Valuation Applications
SAP Course Number:	78TECH400663

Require fiscal data at the course level?

Course can be found when searching
"By Topic" under these categories:

Right-of-Way/Acquisition/Appraisal

Class Schedule

No Offerings Are Currently Scheduled

General Information

Summary:	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.
Learning Outcomes:	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
Teaching Method:	Instructor lead computer lab.
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.
Target Audience:	Real estate appraisers, reviewers, real estate brokers, and underwriters

Special Materials:	Attendees should have basic level of knowledge of spreadsheets.
Final Exam:	No

Continuing Education Credits

PA Board Approved	CEHs	Classes After		CEUs	Classes After		PDHs	Classes After

Continuing Real Estate Appraisal:	14.00	07/24/13

Awarding continuing education credits (PDH/CEU/CEH) to a training course or other training event does not imply or guarantee that the training course/event is approved by the Pennsylvania State Registration Board of Professional Engineers, Geologists and Land Surveyors. According to Pennsylvania Act 25, “Credit determination for activities…shall be the responsibility of the licensee. Continuing professional competency obtained by a licensee should maintain, improve or expand skills or knowledge obtained prior to initial licensure, including law and ethics applicable to the profession, or develop new and relevant skills and knowledge.”
For informational purposes only:	1 CEU is equal to 10 hours of instruction
	1 CEH is equal to 1 hour of instruction

Course Contact Information

For technical questions regarding this course, contact the following...
Name:	Kimberly Rice
Phone:	(717) 783-4722
Email:	ririce@pa.gov
For general questions about the Training Calendar (such as those regarding schedules, locations, instructors or registrations), see Contact Information in specific classes.

Created	Last Modified
By Peggy A Trevenen/PennDOT On 07/24/13 At 09:07 AM	By Randall Shull/PennDOT On 12/15/16 At 11:00 AM