GETPIVOTDATA: All You Need to Know

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

Power BI For Beginners

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

Use OFFSET to Retrieve Rows from an Excel List

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

Replace Part of a String in Excel

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

The ULTIMATE Guide to Lookups in Excel: Live

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