May 23, 2022
Have you ever clicked on a cell within a Pivot Table whilst building a formula and instead of the cell reference appearing in said formula, you get some strange looking GETPIVOTDATA function? In this video I explain what GETPIVOTDATA is, when you need to use it, when...
May 15, 2022
Recording of a training session that was delivered live on YouTube on 16th May 7PM UK time Power BI turns raw data (from a variety of sources) into stunning interactive visual reports. Gone are the days of submitting a request to the IT Department and waiting for them...
May 15, 2022
Excel’s OFFSET function is used to retrieve values from a cell or range that is a specified number of rows and/or columns from another cell. Why would you ever need to do this? The OFFSET function is often used in conjunction with other functions however this...
May 14, 2022
Have you ever needed to replace part of a string (i.e. text entry) with something else, across multiple cells? For example: You need to replace every occurrence of a space with an underscore. You need to replace the second occurrence of ABC with DEFG. You need to...
May 10, 2022
If you’ve ever needed to manually search through a list of items for a specific value, you’ll know how time-consuming it can be, not to mention the risk of returning the wrong value because your search term wasn’t quite right or the time wasted if...
