I was the “Lotus 1-2-3 guru” and self-taught myself Excel, XLM, and later VBA. I once wrote the VBA chapters in an “Excel Secrets” book. The most complex topic, which wasn’t my area, was user-defined arrays.
I was considered a Lotus 1 2 3 “guru” in the day. And then when we migrated to EXCEL, converted all the Lotus data in our office into EXCEL.
when I went back to college, my professors paid me to convert their data as well. I got pretty skookem at EXCEL, but as I moved up in management and had to teach my assistants how to create the spreadsheets that we used, my skills began to fade. It finally reached the point where I no longer created spreadsheets and had to go to my assistants to do it for.
I can still prepare basic ones but noyhing elaborate.
-PJ
At one company I was the only person who knew how Quattro Pro worked and so the person put in charge of a spreadsheet that was not even close to being in my department that no one else could use and no one knew how to update.
After about three months of doing it I asked why was this not switched over to Excel and updated with new product and the old product purged. They did not know that was even possible.
So I got authorization for some Saturday overtime and in two weekends had their new, updated spreadsheet running in Excel. I included a first page that told you, in detail, how to up date the sheet.
Somewhere there is some poor sap trying to use that thing and cursing my name no doubt.