Formula Friday – View All Of Your Calculated Fields And Items Contained In Your Excel Pivot Table
Welcome, Excellers. Almost everyone who has used Excel has had to work with Pivot Tables at some stage. I will show you how to list all the calculated fields and items in your Pivot table in today's...
HAPPY FRIDAY. If you want to download the example from this blog post you can do so here to work along with. [wpdm_package id='9971'] Today let's look at a great at a couple of really...
Prevent Duplicate Entries In A Data Range Using Data Validation and The COUNTIF Formula
Sometimes is is not enough to just highlight duplicate values using conditional formatting in Excel, sometimes you just do not want to allow users to enter duplicates. For example if you are...
Friday Formula time..... Today let's look at a handy formula for transforming an email address into a name, without the email address junk that is associated with it. At work I get data...
Find All Cells With A Certain Type Of Formatting – With This Cool Find Trick!
This is a really cool Excel trick that can potentially save your a tonne of time. By the using the Find functionality in Excel we can find all the cells that meet your chosen formatting criteria,...
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...