Hello Again and OOOH My, it's August, I have been enjoying summer in the Colorado Rockies and hope your summer has been good as well. So following the laid back attitude, I thought I would discuss a feature that is so "laid back" you don't really have to do anything except look.
I am always suprised as to what people don't see in the application window, usually due to their focus being on a specific area of the screen/window and not really "looking around" to just see what's happening in the window as they are working with the application. When I point out specific things that are happening or things that are just there to see (if you look at it) to someone during a training/consulting session, commonly they remark "has that always been there?!" And of course they are suprised to hear YES and as a matter of fact in some cases "this feature has been in many prior versions."
A classic example of this is the Autocalculate feature of Excel; this is not new and has been a feature of Excel for quite a while.
In a workbook for example select a range of cells containing values. Look at the right section of the Status Bar (the bar at the bottom of the Excel window), you should see Sum= and the sum of the values in the Range. In Excel 2007/2010 (as well as earlier vesions) right click the Status Bar and you will be presented a shortcut menu with many options as what to show in the Status Bar. Notice the second segment from the bottom is a list of 6 functions which can be turned on/off. Which ever of the 6 functions you turn on, the results will be in the Status Bar upon selecting a range of data. Notice there is a Count function that will apply to Text data. As per above, I find many people even after working for years in Excel never knew about this feature and never saw it because they just never looked to see.
So now I guess we can call this a 'quick look' feature now that we know to look. "I see said the blind man..."
Have fun in the meantime until next time! Joel