So, what’s new with Excel, every accountant’s best friend? This course brings you up to date with some of Excel’s most important recent developments, from the latest Copilot capabilities to smarter formulas, improved data tools and practical usability upgrades that can make everyday work faster and more effective.

You’ll explore how Copilot is evolving beyond simple chat, with new Chat, Edit and Plan modes, personalisation options, a choice of AI models including Anthropic’s Claude, and greater control over the changes it makes. The course also covers new formula features such as TRIMRANGE, Formula Completion, Formula by Example and PIVOTBY, alongside improvements to error handling. You’ll look at Excel’s enhanced data import capabilities too, including the Power Query experience in Excel for the web and new ways to work with text and CSV files.

Finally, you’ll work through a range of quality-of-life improvements designed to remove familiar frustrations and make Excel easier to use. These include checkboxes, Focus Cell, the Navigation pane, PivotTable improvements and Centre Across Selection, helping you get more from the tools you already use every day.