Using a Formula Instead of VBA

excel dynamic arrays

December 6, 2018

Excel Dynamic Arrays

If you’re familiar with array formulas, then the simplicity of Excel Dynamic Arrays will be a breath of fresh air.

Read More
Excel Functions Translator

July 19, 2018

Excel Functions Translator

It’s often difficult enough to figure out the correct Excel functions to use, but it’s significantly harder if you also

Read More

April 4, 2018

Relative Named Ranges

Excel Named Ranges is a vast topic that includes some simple techniques that we all can and should use to

Read More

March 22, 2018

Excel ADDRESS Function

The Excel ADDRESS Function returns a cell address for specified row and column coordinates.  Optional arguments allow you to specify

Read More

October 25, 2017

Excel DATE Function

The Excel DATE function combines separate year, month and day values and converts them into a date serial number formatted

Read More

March 22, 2017

Excel TEXTJOIN Function

New in Excel 2019* is the TEXTJOIN Function. It's the grown-up sibling of CONCATENATE. Both TEXTJOIN and CONCATENATE join text

Read More

October 18, 2016

Excel IFS Function

This tutorial is applicable to Excel 2019 onward and with a Microsoft 365 license. In Excel 2019 there are a

Read More

October 18, 2016

Excel SWITCH Function

This tutorial is applicable to Excel 2019 onward. New in Excel 2019 is the SWITCH function. It looks up a

Read More
Excel MROUND Function

April 19, 2016

Excel MROUND Function

Excel MROUND function is perfect for rounding numbers to the nearest multiple. For example, last week Brenda said she was

Read More
Transpose data in Excel

January 27, 2016

Transpose Data in Excel

There are 3 ways you can transpose data in Excel (not including VBA). Download the workbook and follow along Enter

Read More