Excel 2016 has given us a plethora of useful – and long overdue – chart types for us to work with. One of these, is the Waterfall Chart I‘ve written before about how to create a Waterfall Chart in Excel – it has long been one of the more challenging chart types to re-create, so Read More
I originally posted this to my LinkedIn Profile, which you can find here, but thought I’d share it on here as well!
Plenty has been said before about whether or not you should use Pie Charts to present your data.
A good article covering their main pitfalls can be found here;
and a slightly lighter take on them can be found here;
Yet, it was my own father who reminded me that Pie Charts can be put to good use, as was the case with Florence Nightingale. (Though, they were of the somewhat more useful Rose Diagram type than bog standard Pie chart, but I take the point!)
Having said that, I came across this little gem, on the BBC news website of all places, which really must be the single worst usage of Pie Charts I’ve ever come across
Managing the file size of Excel files can seem a challenge, but there are some fairly simple steps you can take to make it a bit easier.
This post will take you through file management through File Formats, File Formatting and File Content, before finishing with some file sharing tips. Read More
When you first upgrade to Windows 10, your Task Bar will include two new components – the search box (or Cortana if you’ve enabled this) and the Task View button next to it. If, like me, you find it a little obtrusive, the good news is that it’s very easy to remove or minimise these Read More
If you’re borrowing or saving money, and want to compare rates, perhaps perform some What If analysis, there are built in function in Excel which can quickly help you PMT() The main one is PMT() This function takes a value, a rate and a ‘number of periods’ value and gives you the repayment. There are also Read More
Nice quick one.
If you want to use a shape on a chart, in place of columns and bars, it’s possible to do this in Excel.
It’s not obvious how to do it, but is very simple and very quick.
Create your chart as normal. Once you’re happy, elsewhere on your screen, create the shape you want to use. Read More
One of the most common questions I hear, is around how to manage duplicate values in Excel.
I’ve already covered off how to remove duplicate values in this post.
I personally feel the ability to remove and highlight duplicates should grouped together, but whilst removing duplicates forms part its own ‘feature’, highlighting duplicates forms part of the wider Conditional Formatting functionality.
Since Excel 2007, highlighting duplicates has been very straightforward, with a pre-defined option to enabling it. So it’s this approach I will cover in this post. It can still be achieved in 2003 using a simple formula, but hopefully by now everyone is using 2007+ Read More
Anyone who’s used Excel in earnest for any length of time – ie 2003 and earlier – probably remembers having to create a VBA add-in to tackle the removal of duplicate values – or sometimes a COUNTIF() function would suffice for smaller jobs.
I always used the superb ‘The Duplicate Master’ add-in
(Which can still be found here – though the availability of the link seems to come & go)
Whilst such add-ins still have a place, offering rich features, for basic day-to-day removal of duplicates, Excel now includes this functionality built-in – and has done since Office 2007.
It’s this built-in functionality that we’ll cover in this post. Read More