How to create and use Excel Lambda functions in Excel 365
It can be useful to inspect a cell’s formula visually without having to click in it to display the formula in the formula bar. Excel’s FORMULATEXT function enables you to see the formula in another cell.
How to return an array of non-adjacent cells in Excel.
How to use Excel’s RANDBETWEEN function to generate random numbers between two values. A short video shows how to turn the values from dynamic to static.
To test IF a value matches a condition, and return one result if TRUE, and another if FALSE.
How to display today’s date and time in Microsoft Excel
How to display today’s date in Microsoft Excel
Use functions CHOOSE and RIGHT to create an array of values which includes mixed data types, to feed a LINEST calculation