Here is a really great way of displaying a micro (or easily resizeable) chart in Excel. It makes use of the Camera Tool. Sometimes hidden, Camera is a tool that is really useful but not that many...
Tag: Excel Tips
Formula Friday – Create A Dynamic Pivot Table Data Source Using OFFSET and COUNTA Functions
Happy Friday Excellers..... Pivot Tables are great for taking hundreds or even thousands of rows of data and be able to summarise and analyse your data set with a few clicks of your mouse, if...
Friday Formula Fun Time..... Do you find that your VLOOKUPS are sluggish sometimes when you are dealing with larger data sets?. Here is a way to speed them up....use 2 VLOOKUPS at a...
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...