Name: Excel Pivot Tables for Real Estate Appraisers
Overall Rating: 5.0 out of 5 (1 rating)
Category: All Learners
Duration: 1.00 hour(s)
Individual Fee: $20.00

The technological advances of the last 10 years have caused a significant change in the real estate appraisal profession. Nearly all databases are computerized and import/export data through Excel. Therefore, it is imperative that appraisers easily be able to retrieve, list, and analyze large quantities of data using Excel.  

You will use the MLS to learn how to:

  • Sort and filter data
  • Highlight duplicate data
  • Calculate mean and median values
  • Statically analyze data using data regression
  • Conditional formatting and how to create a scatter chart
  • Accomplish tasks with more confidence and effectiveness
This Development Activity has not been scheduled.
College of Lake County
19351 West Washington Street
Building E, Suite E186
Grayslake, IL 60030
United States
Do and Show: Important tasks or skills you will be able to perform and demonstrate to others.


You will use the MLS to learn how to:

  • Sort and filter data
  • Highlight duplicate data
  • Calculate mean and median values
  • Statically analyze data using data regression
  • Conditional formatting and how to create a scatter chart
  • Accomplish tasks with more confidence and effectiveness
SkillPrerequisiteExpected Outcome
Excel2 - Basic4 - Advanced
Excel Advanced2 - Basic4 - Advanced
Excel Intermediate2 - Basic4 - Advanced
Class Costs
Class ValueNo Charge
Individual Fee$20.00
Private Class Fee$0.00
5.0 out of 5 (1 rating)

Great Tips Tue, Feb 1, 2022
Highly Recommended
[See all User Reviews…]