The Office Scripts action recorder can generate code snippets for Excel changes, but some actions still require manual ...

If you use Microsoft Excel, you probably know the popular spreadsheet tool automatically numbers each row in a spreadsheet outside the columns of the sheet itself. But often you want to have a column ...

Locating missing sequential numbers can be an arduous task when working with long lists of data. For example, you might want to locate business check numbers that haven't been logged into a balance ...

TLDR: The pair of courses go deep into Excel training for numbers-centric professionals, including how to customize and automate Excel to do statistical gruntwork all on its own. No true professional ...

These four overlooked Excel features completely changed how I design spreadsheets.