Jump To the Last Row Or Column In Your Data With A Double Click Of Your Mouse
I love keyboard shortcuts in Excel, being able to work really quickly can increase your productivity hugely and of course makes you look awesome at Excel. So here is a tip that is really useful if...
Formula Friday- Always Add The Last 3 Values In Your Data Set Using The Offset Function
Happy Friday...More #FormulaFriday Fun for you. Today let's look at how to always add the last 3 values in your data set. This formua is one that I have used for always returning the sum of the...
Excel Pivot Table Tip – Show Only The Top 10 Items In A Pivot Table
This tip is really useful if you have a Pivot Table with a large number of Row Items such a product ID's and you only want to show your top selling products. You may have hundreds or even thousands...
In a previous Formula Friday Blog Post last week, which you can see here I went through 3 methods to enter formulas into Excel, some quicker than others, and I challenged readers to try methods 1 or...
Now I have been an Excel enthisiast and user for around 20 years now, but one of the most talked about features in Excel I have experienced is the VLOOKUP table. I recently changed over offices...
Excel VBA Tip -How To Reset All Pivot Table Slicers At The Click Of A Button
I have recently been working on a spreadsheet solution based very much on Pivot Tables and a good deal of Slicers to enable an easy of drilll down into the data. If you have been using any...