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
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...
May 7, 2022
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...
May 6, 2022
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....
