Information management and technology assurance

This article shows how to apply Benford’s Law to a dataset in Excel and how to interpret the results.

TEXTSPLIT is a very useful function for breaking down text cells that contain different lengths of text and delimiters.

Excel’s TEXTBEFORE and TEXTAFTER functions allow users to quickly split up text in ways that used to require combinations of functions like LEFT, RIGHT, MID, and FIND, leading to some confusing formulas.

This month’s column shows how you can use Microsoft Excel’s View features to more easily
navigate big datasets.