I bought books. Self taught. They did not have Excel or spreadsheets in college when I went.
Absolutely. Like subroutines, subprograms or nested Do loops.
Excel VBA works for single task jobs - like doing a specific appraisal report. But if you want to expand out to a network capable of:
1. Supporting multiple appraisers,
2. Supporting the creation of an extensive database covering the past 20 years of MLS listings for a large market area (or even a complete state) via batch downloading of data from external RETS servers to your database on a daily basis, with integration of GIS, Census and other data, with filtering and cleaning of data,
3. Building models of multiple market areas every week or month,
4. Provide websites for CRM,
and so on,
- then you will need to learn a language like C# or Python plus a range of related tools.
At companies like CBRE, they do spend a good deal of money on software developers to develop applications that SUPPORT appraiser tasks, yet it seems appraisers continually need to improvise with Excel.
In the ideal situation, independent residential appraisers would team together with a developer and analyst to improve their competitiveness. This sort of development is a trend in at least commercial appraisal. There was a recent article on this in Valuation, I believe. An example is ValBridge
https://www.valbridge.com/, where many older smaller companies were having difficulty competing with the likes of CBRE, and combined resources. The fact that some top MAIs have left CBRE to work for them is an indication that they have been successful, so far.