photo credit: terry
We all know Excel has tricks.
(don’t forgot the usual guide and homework!)
Sometimes we forget just how useful they are. Today we’re focusing on the Excel list function, a relatively simple tool with database-saving application. It’s part of Excel’s data validation functions, and here’s how it works:
The Excel list function creates a drop-down list of predetermined terms and restricts a cell’s input to only terms on that list. For example, a list can be as simple as ‘apartment’ or ‘commercial’. If you click the drop down list, you can select either of the commercial real estate class types.
Here are the practical applications:
1. congruence: If you’re thinking, wait a minute, it’s easy enough to just type either term, apartment or commercial, then you’ve overlooked the fact that excel will never let you type other than the term, for example ‘appartment’ or ‘comercial’ or any typos associated with the term once the list has been set. (more…)
Here at REsheets, we have a secret.
Every year, just around the start of March, we’re visited by a very well intentioned and thoroughly confused Leprechaun. Typically, faery tale creatures of similar types show up just before Christmas, and in well read Charles Dickens novels, but not the Leprechaun of CRE’s Past.
Yesterday, as I was sitting in the REsheets’ office pondering Own vs. Lease scenarios, I was visited by the Leprechaun of CRE’s Past. I howled with surprise, but I was only fooling myself, the fifth of March is very late for the first Leprechaun sighting.
“No,” I pleaded with the Leprechaun, “We feed our families with these spreadsheets, stop trying to give them away for free!”
Wise as always, the Leprechaun posed a question, “That Famous REsheets Toolbelt you’re so fond of, the one with all the gadgets, shouldn’t every real estate agent own one of those?”
“Yes,” I replied without hesitation, “of course they should. It’s thirteen scenario specific analysis options, it’s easy to use, it’s easy to report, and it’s impressive!” (more…)