I have seen a few posts recently suggesting that the new TRIMRANGE feature may reduce the use of the OFFSET function when creating flexible ranges. I thought that maybe the OFFSET function will be used more with the TRIMRANGE functionality.
(more…)
A recent update has introduced a new way to refer to ranges in Excel. This update makes it much easier to refer to flexible ranges in Excel.
(more…)
If you need to use numbers in a text string you typically need to use either the TEXT function, the DOLLAR or the FIXED function. To make it easier we can create our own function.
(more…)Learn about the built-in features that allow you to perform What If analysis in Excel. This is a recording of a live free webinar I ran in April 2025. Over 100 people attended. The average feedback score from more than 70 people was over 90%. You can download the materials at the link below the video. Excel What If Techniques10/10I always find your webinars and materials easy to follow and informative. Thank you for continuing to provide the suite of…
A recent update to Excel includes a new TRANSLATE function. This function enables you to translate words from one language to another.
(more…)
I have been going through Mike Girvin’s recent book Microsoft 365 Excel: The Only App That Matters, and found an elegant technique of comparing lists using FILTER and XMATCH. It inspired me to create a custom function to show missing or matching entries.
(more…)