Creating Waterfall Charts in Excel 2016
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
Using Ranking Functions in Excel
Master the available options in Excel for ranking you data, including the updated Rank.Eq functions.
Pie Charts – how not to use them!
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
Removing the Search / Cortana box on the Task Bar in Windows 10
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
Using Excel to Calculate Repayments & Interest using PMT, IPMT & PPMT Functions
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
Using arrows and other shapes as columns / bars in Charts in Excel
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.
Highlighting Duplicate Values in Excel – [Excel 2007, 2010, 2013]
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+
Removing Duplicate Rows / Find Unique Values in Excel
[Excel 2007, 2010, 2013]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.
Adding shortcuts to your Teradata SQL Assistant Query Tabs
Move between tabs in Teradata’s SQL Assistant by assigning Short-Cuts to them
Most Read Articles
