pennysaver said:
I think you'll find that "most" people think of it as digital graph paper and will never fully understand what it can do without some prodding. Few will get past =SUM(). Very few take the time to think out of the box conceptually as it is, let alone with PC applicaitons, and try to see how an application can streamline their work.
A very few of the people I work with understand that Excel can be a powerful tool, and will spend the time to delve into it's more advanced features. I showed someone here a SUMPRODUCT formula that counted by two criteria for a sheet they were working on, and he was literally spechless.
![Eek! :eek: :eek:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)
I'd called that an advanced feature if 95% of the users I see don't even know of it's existence. And even then, most of them just continue to use exactly what I give them, without figuring out the "why " of it, and when it "breaks," they call me. If they would just try to figure things out a little bit.... *Sigh*
I've created macros for people that do in seconds what used to take them hours, because they get a report from someone, and basically rearrange it to display the data in a different way, and maybe create a pivot table or a chart. That's about as advanced as most people here want to get. Someone said to me, "If people know you're really good at something, they'll figure out a way to add more to your job description and not pay you any less." I've seen that a lot, here.
pennysaver said:
If people don't have a desire or need to get better at work, then no application will get the acknowledgement that it deserves. Those who do will.
My 2 cents.
Smitty
Well, this post is about a dime, then, huh? Most people I work with are more than happy to learn just as much as they need to to do they're jobs satisfactorily, and that's it. The few people I've shown other features to always say, "I never knew Excel could do that." Just about verbatim every time.
Well, I didn't know it could do that, either, but I found out
for myself how to make it do what I want. Amen, Smitty. If you don't want to figure out what Excel can do, you'll be sitting there working on a spreadsheet at 8:00 P.M. on a Friday night, and I'll be home with my family.
![Laugh :LOL: :LOL:](data:image/gif;base64,R0lGODlhAQABAIAAAAAAAP///yH5BAEAAAAALAAAAAABAAEAAAIBRAA7)