Teaching fellow EHS people automation?

Hey y’all,

I have been in the HSQE field for 8ish years now, been a participant in this sub for the past three years or so.

I started at a new company recently and was stunned at how little the old HSQE manager (early 50;s) knew about the M365 ecosystem and the world of wonders it opens with a bit of googling.

To set the scene, everything was either done in Excel or PowerPoint. By PowerPoint I mean he created tables in PowerPoint that was then copied over into excel. He had one excel sheet that had 33 different sheets.

He had no concept of filtering, data layouts or just general good excel practice. He then had to 5 weekly reports (private equity backed company, they love them some reporting), and 5 monthly reports, plus quarterly reports and ad-hoc shareholder reports.

This was on-top of looking at trends etc. To be fair the reporting can be horrific, but PE backed companies seem to do a lot of this. In addition to this he was openly honest about being burnt out by the amount of reporting, the hassle and the fact that if he was not in, there was no back-up. He resorted to spending his holiday time creating reports.

I am a big advocate of working smarter not harder and thanks to a previous job and attempted career change I spent a great deal of time learning to code and learning about PowerApps, PowerAutomate, Power BI, data models etc etc.

Since taking over following his retirement, I automated probably 90% of this work and thanks to PowerBI reporting and basic sharepoint list set-ups reporting takes me less than 5 minutes to produce almost any HSE report asked for.

This has also allowed me to spend more time on-site and building relationships with others (which is honestly what I prefer).

All said and done, I have automated a rake of stuff and this seems to have impressed a good few people, even more so the fact that the data is so accurate and easy to read.

After speaking with a few adjacent HSE managers in the client companies we deal with, they have all expressed interest in understanding how it was done. When I tell them I just learnt myself and its actually incredibly easy they just kind of laugh and say they couldnt do it, not smart enough (?).

This brings me to my final point of, a question. Would you be interest in a class, 1-1 session or consultation whereby I could happily explain & show easy(ish) it can be to automate a bunch of repetitive monotonous stuff but with a emphasis on HSE use cases?

Interested to get your guys thoughts on this as fellow EHS professionals or are most of us now using off-the-shelf software.