Formula Friday- Automating Cell Updates With VLookUp Formula And A Drop Down List
Friday again Excellers...Formula Friday time. Today let's look at how to save time entering data into workbook, by using both a VLOOKUP formula and a data validation drop down list. I want to...
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,...
Formula Friday – Permanently Remove A Calculated Field From Your Pivot Table.
Friday again Excellers........Lets look at removing a calculated field from your Pivot Table....Permanently. Sometimes when you create a calculated field in a Pivot Table you may not want to keep...
Formula Friday – Easily Spot Excel Formula Errors In A Large Excel Worksheet
It's Friday yet again, time for some Formula Fun.....Let's take a look at finding formula errors today. If you have a really large worksheet you may not be able to look at it all at once...
Formula Friday- Using The Convert Function To Calculate How Long My Task Will Take.
Hello Formula Friday Excellers, today let's look at a really handy formula to help us calculate how many hours a total task from start to finish will take. The whole task is made of a lot of mini...
Formula Friday – How Excel Calculates – The Order Of Excel Calculations
If you plan on writing formulas in your Excel spreadsheet- I am assuming you do want to use Excel for calculations at this stage :-) then knowing the order of precedence or that Excel performs the...