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...
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...
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...
Friday again Excellers, and today we are going use the COUNTIF function and get Excel to automatically to check how many classes students have signed up for ...or....simply ..count how many times a...
I download a lot of data form various sources, so the quality and formatting of it can vary significantly. One issue that occurs a lot of the time is a date field being formatted as text. It...
Until you know this setting in Excel, it is difficult to see how you can have great looking static images on your Excel sheets. Being able to lock down your images on a dashboarrd for example to...