Excel LAMBDA functions
How to create and use Excel Lambda functions in Excel 365
Function
FORMULATEXT function in Excel – display formulas
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.
Excel’s CHOOSE function with array
How to return an array of non-adjacent cells in Excel.
Generate RANDOM numbers with Excel’s RANDBETWEEN function
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.
Excel IF function
To test IF a value matches a condition, and return one result if TRUE, and another if FALSE.
Insert current DATE and TIME in Excel
How to display today’s date and time in Microsoft Excel
Insert current DATE in Excel
How to display today’s date in Microsoft Excel
CHOOSE function with LINEST in Excel
Use functions CHOOSE and RIGHT to create an array of values which includes mixed data types, to feed a LINEST calculation