So another Formula Friday is upon us. Here is a formula trick for not creating a formula, but pausing whilst you are in the middle of creating your formula and not losing your place or...
Posts by Barbara
Formula Friday- How To Use LEN in Excel To Highlight Issues With My Data Import
Yes Friday again more Formula Fun time. Today it's exploring the LEN function. It really is one of the core text formulas to have in your Excel Toolbox. It is used to return the...
Hey Excellers Happy Friday. You can download the sample file for this Excel tip here [ddownload id="7101"] Today let's look at some formula fun. Lets use Excel to pick a winner from a list...
Once you have created your Pivot in Excel, you may decide to move it to an entirely new work sheet, or to a different location within the same work book to enable you to rearrange a dashboard or add...
Formula Friday- Find The k-th Largest Value In Your Excel Data Set Using The LARGE Function
Download The Example Workbook Here [ddownload id="7095"] It's Friday YAY. time for more Formula Fun.... Today let's look at the LARGE function in Excel. It is a really handy one that will...
Excel Tip-How To Quickly Select All Or Just Parts Of Your Pivot Table
If you use Pivot Tables regularly and you either move them around, select parts of them or indeed all of them, then here is a really quick method for selecting areas of your Pivot with ease...with...