Help and ideas for busy numbers people
I don’t offer a standard Intermediate Excel course (or indeed, a standard Beginners course or a standard Advanced course).
There are a couple of reasons for this.
Firstly, I tailor all Excel training that I deliver to the needs of the course participants.
Continue reading “Why I don’t have a standard Intermediate Excel course”If your pivot table defaults to Count instead of Sum, then you have inconsistent numerical data.
I found this out on a webinar about five years ago, and it still seems to be a mostly unknown feature.
And yes, I call it a feature, not a bug, because it is ultimately helping you.
What it is doing is giving you an immediate message that your numerical data has gaps, or perhaps has numbers formatted as text, or other errors. If you ignore this, you might produce inaccurate analysis.
So – if your pivot table defaults to Count, don’t do what I used to do, which was to tut and manually change it to Sum.
Investigate your data carefully until you’ve found the inconsistencies and then try it again until it defaults to Sum. Here’s a link to some suggestions for converting text to numbers.
I love training finance teams in Excel and Power Query – have a look here at what I can do for you.
I offer bespoke Excel training (and tailored Power Query training), particularly to finance teams. But what do I mean by “bespoke”?
Continue reading “What do I mean by bespoke Excel training?”
Why isn’t Power Query better known amongst finance teams?
Continue reading “Why isn’t Power Query better known amongst finance teams?”
On the face of it, processing timesheets with Power Query ought to be fairly straightforward. By “processing timesheets” I am primarily thinking about records of hours worked that feed into payroll or job costing calculations.
Continue reading “Processing timesheets with Power Query – what about the human factor?”
Last week I “went” to the Global Excel Summit. This is a three day event featuring many of the superstars of Excel, eg Leila Gharani, Chandoo, Wyn Hopkins, Oz du Soleil etc etc. It was virtual this year, but as I’d never been before I didn’t know what to expect anyway.
I learned way more than five things, of course, but here are my biggest takeaways.
Continue reading “Five things I learned at the Global Excel Summit 2022”
This post sets out the five most useful new Excel functions for finance teams, based on my experience. By “new” I mean available in 2019 or later versions of Excel (including Office 365).
Note – this post was written in January 2022 and reflects what was available at that time.
Many of us are self-taught in Excel, and it can be hard to keep up with the changes. In the past few years there have been loads of new Excel functions that replace and add to existing ones that you might be familiar with.
Continue reading “The five most useful new Excel functions for finance teams”Here are the five most useful power query functions for accountants, in my personal opinion:
It is, of course, impossible to pick just five. However, the point of this post is to illustrate that the power query functions I use the most are actually the simple ones. They are still enormous timesavers. Let’s have a look.
Continue reading “The most useful power query functions for accountants”
I attended an excellent livestream last week about Excel dashboards, presented by the legendary Chandoo. In his tutorial, he built a KPI dashboard in Excel in around an hour. As well as learning lots of useful tips, it also made me think about the key skills (Excel and otherwise) that you need to build a great dashboard.
Continue reading “Creating dashboards in Excel – key skills”Power Query has been out for over a decade and yet the majority of accountants I meet still seem unaware of what it can do for them.
A possible issue is that it is usually presented in the context of Power BI, and analysing Big Data. And the type of people who like to talk about that also like to talk about other scary things such as VBA and SQL. There aren’t many training resources or articles focussing on Power Query for accountants more generally.
