If you’re looking to harness the power of Copilot for data insights, starting with Excel Tables is your best bet. Tables make data management a breeze by automatically expanding as you add new information, and they come with built-in features like sorting, filtering, and easy calculations. This structured format not only keeps your data organised but also enhances Copilot’s ability to analyse and provide meaningful insights.

Lists are so versatile - add images, hyperlinks, conditional formatting, send alerts and trigger workflows - and they work inside Teams! Get in touch and we'll show you how in our live webinars.

To do this, 'Ctrl + Click' each sheet at the bottom of your worksheet. While you have these selected, your formatting changes and formulas will happen across all the selected sheets. What a great time saver!