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...
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 – 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...
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...