Copilot - Consolidate and Analyse Data in Excel

Manually consolidating data from multiple sheets and preparing it for analysis in Excel can be time-consuming and error-prone, especially when working with inconsistent or unstructured data. In this lesson, you'll learn how to use Copilot to streamline the entire workflow using a single prompt. You'll see how Copilot can split raw data into structured columns, combine datasets from multiple sheets while excluding duplicate headers, and automatically build a summary table. Finally, you'll generate a clustered column chart to visualise revenue by region, turning messy multi-sheet data into a clean, insightful report in seconds.