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

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

The Drop Function in Excel

The DROP function is one of 14 functions added to Excel in the spring of 2022. It displays the contents of specified range but excludes the first or last X number of rows or columns. In columns A:H in the screenshot below are the current standings in the English...

The Take Function in Excel

The TAKE function is one of 14 functions added to Excel in the spring of 2022. It displays the contents of the first or last X number of rows or columns from a range. In columns A:H in the screenshot below are the current standings in the English Premier League table....