Excel is really a “swiss army knife” type tool. I have used it for all kinds of odd things including HTML for long lists, creating a checkerboard, analyzing server log files, projecting cell phone usage and analysis whether people preferred live or telecast music at a church overflow room. Excel has so many hidden little features that it is easy to overlook some of the capabilities that let you do a complicated task quickly.
This video demonstrates three capabilities of Excel that the average user does not know about.
(If you have trouble seeing the video, turn on HD. You’ll have to go to Vimeo, but you can watch it in high resolution that way.)
The three items covered are:
- Transpose copy function
- Validate entries to a list
- Named regions
None of these things are very earth shattering, but knowing these tools can turn 20 minutes of boring Excel work into a two minute simple job.
Please let me know what you think of these videos and if you’d like to see more of them in the future.