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
Microsoft Excel
The Death Of The Desktop Is A Tragedy
Something you often notice in modern workplaces is that a lot of people are working from laptops, even when they have a desk and never move it. This isn’t necessarily a bad thing, portability is inherently useful and more easily allows remote working after all. Remote working is the way to go! But when you have Read More
Let’s Get Fuzzy-cal
Dismayed is how I felt a few hours ago, when I looked at the 9000 rows of data that I would possibly have to match up manually. Each row contains words that I need to match, but not in always the same format, and certainly not identical to what I needed to match it to! I’d Read More
This Excel Guy Is An Analyst
It is not uncommon for me to compare my last job with this one and feel grateful for what I’m doing now. Today I found myself there again. Recently I’ve been tracking my working time on Toggl, not everything but close enough. Today, all my time spent working on the report came to less than an Read More
Linear Algebra And Excel Spreadsheets
Although I am just beginning with Linear Algebra, one thing occurred to me about matrices and vectors. I worried that in my ignorance, I was simply misunderstanding, but maybe not. I stumbled across the following quote and my little thought made sense: Linear algebra gives you mini-spreadsheets for your math equations https://betterexplained.com/articles/linear-algebra-guide/ Now THAT is something Read More
Giving Up To Win: A Story Of Goal Seek
For the last couple of weeks, I have been intermittently working on a fiendishly challenging Excel problem. This was something I’d not encountered before, there was no simple formula or method for it. Searching online yielded results that worked in specific circumstances, but not mine. And the only reason I finally succeeded, was because I knew Read More
Failing At A Paid Course And Enjoying It
Today I took the plunge on the Business Statistics Specialization I’ve been enjoying for the past few weeks. I fully enrolled with the 7 day free trial then £37 a month until I complete the course. Why? Because I finally started working on the final capstone course and saw that there are peer-reviewed assessments. Having got Read More
The Secret Powers Of Excel
As I’ve progressed through the Business Statistics Specialization on Coursera, one of the things that I’ve noted, and been grateful for, is that you don’t need to fully understand the maths of statistical methods to use them. The main thing you need to know and be able to us, are Excel functions. There are Excel functions Read More
Learning Teaches Us How Little We Really Know
The more you learn, the more you realise how much there is left to learn. I was reminded of this important lesson today when I was trying to use a smarter way to populate an Excel report and came up against some challenges. Even though the way I was preparing the report was much better than Read More
Master Excel Reporting With PowerPivot And CUBE Formulas
Here’s a post for the Excel nerds out there, because this was so helpful to me over the past couple of days that it is worth talking about. For non-Excel nerds, if you work in analysis or reporting, give this post a quick glance at least, you might pick up something useful!