Help and ideas for busy numbers people
Last year, I attended my first Global Excel Summit in person. The experience was so good I immediately booked for 2026 as soon as tickets were available.
As is now tradition, here’s my annual blog on what I learned. And yes, I’ve booked for 2027 already!
Continue reading “What I learned at the 2026 Global Excel Summit”In the video above (which is silent), I’ve used Excel’s camera tool to toggle between different versions of the same chart.
This post was inspired by Juliana Smith and I had enormous help from this article by Chandeep Chhabra to get to the solution.
Continue reading “Using the camera tool to toggle charts”
You can’t conditionally format a bar chart in Excel – or can you? In this post I set out a couple of options for how to do this.
Continue reading “How to conditionally format a bar chart in Excel”
Structuring data in spreadsheets is really important for producing good financial models and reports.
However, data designed for humans to read should look different from data designed for computers to read.
Continue reading “Structuring data in spreadsheets – for humans and computers”
There’s no particular reason why you should listen to my views on how to keep to New Year’s resolutions. This quick blogpost is just to share a few thoughts. Excel is involved, obviously.
Continue reading “Tracking resolutions throughout the year (with Excel, obviously)”I have the visual sense of a blind goat, but over the years I have picked up a number of Excel design tips which I apply to any spreadsheet that someone else has to look at.
This post sets out ten areas which you can look at to make your spreadsheets cleaner and more professional.
I’ve written this post on the assumption that you are reading spreadsheets online, but most of these Excel design tips also work for printed documents.
The first tip is the easiest – turn off gridlines. Gridlines are the lines marking the rows and columns.
Have Key Performance Indicators (KPIs) ever featured so much in our news bulletins? As a nation we are suddenly poring over death and testing rates and graphs as never before.
Our new-found love of stats highlights six lessons I’ve learned over the years from producing board reports and analysis.
Continue reading “Coronavirus and Key Performance Indicators”