As Microsoft ramps up Copilot’s capabilities in Excel, the AI tool is becoming genuinely useful for spreadsheet work.

Build a fast Excel money tracker with SUMIFS totals, color coding, and charts, so you see monthly savings and trends without manual work.

Sync your drop-down menus with table headers using this robust, auto-expanding Named Range trick.

David Kindness is a Certified Public Accountant (CPA) and an expert in the fields of financial accounting, corporate and individual tax planning and preparation, and investing and retirement planning.