I've rather a lot of Excel experience (Excel 3 thru Excel 2010) within a fairly narrow area; I've used it it mostly in situations where the numbers were few (no statistics, no heaby economics) text manipluation was important, and I thought charts were clunky. I used VBA a lot; automation, automation, automation!
Then as I approached retirement the boss said why don't you run a masterclass as you know such a lot. I though there would be some people in our very large company who would use Excel and could do so better so I went ahead. In preparing, I learned about those less well-known techniques and found Excel to be FAR richer than I realised, and charts are really powerful if you have a little patience.
Then they gave me a new job only using Excel, I'm loving it and postponed the retirement. I'm producing automated management report production with charts, dashboards and ListObjects.
So I'm pretty busy and probably won't contribute frequently. But I've posted a couple of suggestions already, in gratitude for what I find here.
I gratefully acknowledge the 'shoulders of tall men' and women to which my learning owes much, including but not limited to... Jon Peltier, Chandoo, C Pearson, John Walkenberg and Debra Dalgleish. (I apologise if I typed any of those incorrectly).
Bookmarks