Learn how to create interactive Excel dashboards that transform raw data into actionable insights with this step-by-step ...

Here is where Excel pivot tables step in to extract data, which can help you avoid getting lost in endless rows and columns.

Rather than repeating the same steps above to make three new pivot tables from scratch, you can simply hold CTRL (or option on Mac) and drag the new worksheet to the right to copy it.

A great place to start learning about pivot tables is with The Ultimate 2022 Pivot Tables & Dashboard in Excel Bundle, which covers all the above concepts and more. It’s available now for a further 15 ...