“Moving away from VBA” does not mean throwing it away—How to inventory Excel tasks and what to migrate to in the era of macro blocking and the deprecation of VBScript

A practical guide for DX personnel, internal IT staff, and accounting staff at small and medium-sized enterprises (as of September 2026)Introduction“The Excel macro I received from a business partner ...

The Invoice Copy-Paste Hell Beginners Should Abandon First

"I made a mistake on the invoice again..." "How long is this copy-pasting going to last?" Are you fed up with the hell of ...
Geeky Gadgets

Stop Manual Excel Updates with Microsoft 365 Dynamic Arrays

Self-updating tables in Excel streamline data management by automatically adjusting to changes in your dataset. Features like dynamic arrays, spilled formulas, and structured tables make this possible ...
Windows Report

Microsoft Excel Canvas Turns Spreadsheet Data Into Interactive Dashboards

Excel Canvas is a new Microsoft Excel feature designed to turn workbook data into an interactive visual surface with charts, metrics, and insights. According to Microsoft 365 Roadmap entry 569424, ...
JournalofAccountancy

4 Excel features that make reviewing large spreadsheets easier

Q. I frequently work with large Excel workbooks containing thousands of rows, multiple worksheets, and complex supporting schedules. Navigating these workbooks and reviewing information can be ...