Being able to analyse all the data in your worksheet can help you make better business decisions, but sometimes it’s hard to know where to start, especially when you have a lot of data. Microsoft® Excel® can help you by recommending and then automatically creating PivotTables, which are a great way to summarise, analyse, explore, and present your data. This course will get you up and running with PivotTables, then show you how to create a PivotChart from your PivotTable.
We’ll also show you how to draw attention to important items and trends in your data using Sparklines. These are tiny charts inside the background of single worksheet cells that can be used to visually represent and show a trend in your data. Showing trends in your worksheet data can be useful, especially when you’re sharing your data with other people.