Microsoft Excel

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.

Checkboxes can help you create interactive to-do lists and other types of lists that track progress.

The TRIMRANGE function eliminates blank rows or columns from the boundaries of a specified range. This can be helpful when importing data from external sources, which can result in inconsistent formatting.

This column introduces PIVOTBY, a new Excel function that may let you say bye-bye to PivotTables.

This month’s column introduces Excel’s GROUPBY function as a PivotTable alternative.

This month’s column shows how to use the remarkably versatile AGGREGATE function in Excel.

This article provides an example of building a dynamic AR aging schedule in Excel.

Excel’s UNIQUE function allows users to extract unique values from a dataset, making it easier to identify and remove duplicates.

This column shows how to use the Data Table option in Excel’s What-If Analysis tool.

This month’s column shows how to use Excel’s Goal Seek for data analysis.

This column shows how to quickly project financial possibilities with Excel Scenario Manager.