Microsoft Excel

Excel���s Workbook Links pane can help you identify source workbooks, refresh linked values, locate cells that contain links, change the source when a file has been moved or renamed, and remove links that are no longer needed.

By adding a few formulas to an accounts payable export and using Excel’s FILTER function, users can create a reusable report that automatically displays only the transactions meeting one or more exception rules.

This column shows how to use Microsoft PowerToys to improve productivity in Windows 11.

This column explains how Excel’s Freeze Panes, Split, New Window, and Watch Window make navigating expansive spreadsheets more efficient.

Excel for Microsoft 365 includes REGEX functions that can dramatically simplify many common accounting data-cleaning tasks.

Excel’s SCAN function provides a dynamic alternative that calculates running totals without copying formulas.

Excel is a great tool for integrating various financial statement analyses and
presenting the results in a way that emphasizes unusual trends.

By organizing source data into Excel tables and using structured formulas, you can refresh the analysis simply by pasting new statements into the model, without rewriting formulas or rebuilding schedules.

This article shows how to use dynamic arrays in Excel to build a revenue-testing schedule that auto-refreshes.

This column takes a look at Microsoft Excel’s
Dark Mode.

You can use Excel for creating interactive dashboards using PivotCharts combined with slicers to transform traditional, static reports into dynamic tools.

This month’s column shows how to produce more accurate forecasts using exponential
smoothing in 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.