
October 20, 2014
Excel GETPIVOTDATA Function
In its simplest form the Excel GETPIVOTDATA function enables you to extract values from a PivotTable report, but if you’re
Read MoreOctober 20, 2014
In its simplest form the Excel GETPIVOTDATA function enables you to extract values from a PivotTable report, but if you’re
Read MoreOctober 13, 2014
Getting the formatting in your chart right can make the difference between clear, concise information and just a pretty picture.
Read MoreOctober 6, 2014
Dynamic formulas are the cornerstone of interactive reports like dashboards. They enable our report recipients to interact with the data,
Read MoreSeptember 29, 2014
Excel PivotTable Named Sets enable you to pick and choose which columns or rows you want included in your PivotTable
Read MoreSeptember 15, 2014
In this tutorial we're going to look at how Santa is using Excel Custom Data Validation to limit the number
Read MoreSeptember 8, 2014
PivotTables are a treasure trove of features and one that has been brought out of the dungeons in more recent
Read MoreSeptember 1, 2014
We should all be using Go To Special to quickly remove rows containing blanks, but if those blanks are returned
Read MoreAugust 26, 2014
If you reformat data brought into Excel from an external source regularly then you’ve most likely come across Excel’s Text
Read MoreAugust 19, 2014
Excel Tables are one of my favourite features. They make working in Excel much more efficient in so many ways,
Read MoreAugust 12, 2014
Excel Slicers are a professional way to enable users to easily and intuitively interact with your reports, filtering data in
Read MoreAugust 5, 2014
WARNING: this tutorial contains some advanced formula concepts which may incur the following side effects: Negative side effects: Headache, urge
Read MoreJuly 22, 2014
Below is a set of Panel Charts. In this case they’re actually 4 separate charts aligned close together. Comparing one
Read MoreJuly 15, 2014
Bullet graphs were developed by data visualisation expert Stephen Few to address the need for visually rich displays of data
Read MoreJuly 8, 2014
Did you know you can set different passwords to protect specific ranges of your Excel worksheets? It’s called Allow Users
Read MoreJune 16, 2014
If you don’t have Excel 2013 then this post will be a bit like window shopping with an empty wallet.
Read MoreJune 9, 2014
Copying and Pasting are two of the most common tasks you’ll perform in Excel. This is especially true for me
Read MoreJune 5, 2014
My second Excel love is PivotTables (VLOOKUP is still my number 1). PivotTables make short work of summarising data and
Read MoreMay 27, 2014
Struggling with Excel formulas can turn simple tasks into time-consuming challenges, leaving you frustrated and behind on work. Fortunately, a
Read MoreMay 14, 2014
Warning: this is a long post. Get supplies so you don’t dehydrate or suffer from low blood sugar levels before
Read MoreMay 6, 2014
Charts are great at revealing trends, patterns and relationships in your data. We love how they enable us to glean
Read MoreApril 29, 2014
Conditional Formatting in PivotTables has its ups and downs. Unfortunately I find them mostly ‘downs’ but let’s not dwell on
Read MoreApril 22, 2014
If you find yourself repeatedly spending a few minutes customising your chart colours, formatting the title, legend, axis labels etc.
Read MoreApril 1, 2014
I’m sure most of us have experienced frustration at Excel’s refusal to allow us to unhide multiple worksheets. This is
Read MoreMarch 25, 2014
Q: How do you get the PivotTable to show the missing dates in your data? A: Not as easily as
Read MoreMarch 21, 2014
One of the most useful features in Excel are custom number formats yet they remain largely underused. In my Excel
Read MoreMarch 12, 2014
Last week I wrote about how I used Excel to design a Minecraft cake. The response to that post was
Read MoreMarch 5, 2014
Each year our sons choose a cake they want me to make for their birthday. Now, I am no baker
Read MoreFebruary 18, 2014
If you import data to Excel from another program chances are the dates will come in formatted as text, which
Read MoreFebruary 12, 2014
They say the true Excel fan has uninstalled Word from their PC, and removed the F1 key from their keyboard
Read MoreJanuary 30, 2014
The Scenario You need to change the range referenced by your chart/conditional formatting/named range so you merrily open the Edit
Read More