Not long ago we were working with a client, their Microsoft 365 environment felt like a mystery with growing Teams activity, sprawling SharePoint sites, and a Copilot rollout on the horizon. There was no clear way to see what was required to get ready for Copilot, what was risky or what needed attention.

Go to the Insert Ribbon and select the Sparkline you wish to use - Microcharts contained in one cell can help give you a quick visual to analyse data.

It's a simple trick and takes less than 20 seconds inside Power Query.