All about alteryx these days anyway
My Mumās bugbear as well.
Genuinely though, Iād have found that enormously useful growing up. Whether Iād have taken heed is another question entirely, though.
I love Excel. I love describing my Excel skills as āGoodā (which they are) and then blowing self-professed āAdvancedā users out of the water with a fairly simple or common piece of āwizardryā.
Itās all self-taught, or picked up from Google, but spending ten minutes reviewing formulae and then applying them to what Iām trying to do has saved me months and months of laborious shit.
Finding pretty easy VBA codes to automate loads of this has been even more of a godsend.
Although Iām far from brilliant, Iām good enough for many to talk of me as some kind of āguruā just for knowing the shortcut for āFind & Replaceā.
1 Like
Iām not an accountant but yeah I am in excel less and less. OLAP and mother fucking cubes innit.
You one of the Cognos pricks? (autocorrect tried to turn that into the cognoscenti but I think that reference would have been too oblique).
I have all three qualities.
1 Like
Nah but something similar that is pretty big worldwide but not so much over here.
sticking up for the statisticians/economistsā¦ I never learned any data analysis/econometrics on Excel, it was all on Stata etc. There are still times that Iāll use Stata or R over Excel, even for things that are within Excelās capabilities (simple descriptive stats and graphs). So when I became a āprofessional economistā I had to learn Excel from a very basic level.
At some stage of every meeting I ever have someone asks if we can do whatever weāre discussing in Cognos yet, and the answer is always, always no.
Opposite here, my boss says yes to whatever the request might be.
Iām the power BI person now and itās fun
Donāt mind excel but it gets so slow if you try to build big stuff in it and vba is such a pain, still wish there was some kind of big data cluster version of it
1 Like
When I left school I donāt think I had any real understanding of credit cards, interest, loans, current accounts, any of it. I may not have paid total attention but it may have saved me from asking some dumb questions in banks years later.
1 Like
Also Iām sure school IT classes had course elements than included things like how cheques were processed and ATM security? What was that about?
Through essbase?
Yeah we write them in software then publish straight to the web where they can be accessed by anyone who needs them and can choose their own variables.
1 Like
Weāre currently in the process of binning Cognos too 