Gitgud At Excel, Fast

Anyone who has read my blog for any length of time should know that I am a whiz at Excel. I have graduated from the Excel guy to analyst now, but for a good few years I was the Excel guy and becoming an analyst has only expanded my Excel skills further. So one thing that Read More

The Paradox Of Automation

Followers of this blog will probably recall how big a fan I am of automating work. VBA is most often my tool of choice, and I would use it to fetch various files, dump them into templates, copy the converted outputs and post them into a central file to then automatically output reports from that can Read More

Coursera Specialization Experiment: Results

Mission complete and a success! Make no mistake, the exams are far from easy, I have spent many hours over the last few days downloading Excel workbooks, following the assessment instructions and answering questions. And I didn’t always get them right the first time, or even the second time!

The Spreadsheet Guru Lives Up To His Name

As someone who does 95% of his work in Excel, I rely pretty heavily on all the available online resources that demonstrate methods. techniques, formulas and ideas for working with Excel. My career was basically launched on Excel skills and the first two real leaps in terms of job role were based very heavily on those Read More

Mouse Over Information In Excel

One feature in web design and data tools that I find really helpful is the when you hover your mouse cursor over something and after a brief pause a little with additional information comes up. This could be a description of a button, an extended snippet of the text we are viewing or the full link Read More

Random Ideas With Notepad And VBA: Part 2

In my last post about notepad and VBA, I talked about a little macro I put together (and how I did it). At work today I had an opportunity to share it with my colleagues, and to be honest I wasn’t feeling as confident about its usefulness after all. I discussed it with one colleague over Read More

Random Ideas With Notepad And VBA: Part 1

Today while I was basically doing nothing but day dreaming, I hit upon a novel idea for an Excel macro that could be incredibly useful. We have a bunch of ID numbers at work and use them in multiple files. In one file it might have one set of information and in another it has slightly Read More

Reframing Obstacles As Challenges

Recently my team and I discovered that a piece of work we had hoped to take a shortcut on would not work the way we had hoped. The shortcut we had taken meant that we were dealing with incomplete data. This wouldn’t have been a problem, except that we were right up against the deadline and Read More

Let Your Computer Work For You

Now that I’ve built up a few posts on other tools, processes, techniques and strategies for becoming more efficient and productive at work, I think it’s time to move onto my favourite tool: Microsoft Excel. Excel is something that many of us used in school or college at some point, and some of us did better Read More