Download our sample data set [https://itgtechnologiesltd.sharepoint.com/:x:/s/SalesandMarketing/ERblaB0V2LFGloc4DnOurxcBCqRjjE108eESQ4H_1Ec1DA?e=rSyAHG](https://itgtechnologiesltd.sharepoint.com/:x:/s/SalesandMarketing/ERblaB0V2LFGloc4DnOurxcBCqRjjE108eESQ4H_1Ec1DA?e=rSyAHG)
1
Select the table including all the data, along with the headers, for 'UK region, sales 2022, and 2023'.
Zoom Saved
2
Click "Analyze Data"
Zoom Saved
Tables
3
Excel will make some suggestions. We will make a start by inserting a 'Pivot Table'.
Zoom Saved
A pivot table is a tool in Excel that summarises and analyses data from another table by grouping, sorting, and filtering it.
4
In our example we will remove the 'North West' figures and you will see the totals update in the table.
Zoom Saved
5
Click "Filter applied, Sorted Largest to Smallest"
Zoom Saved
Charts
6
Click "Insert Chart" - this shows sales compared year by year based on value as a bar chart.
Zoom Saved
7
Example of sales analysis bar chart
Zoom Saved
8
Next try the line graph by selecting the preview and clicking on "Insert Chart". This graph shows sales between the two years we can clearly see the average was £150,000.
Zoom Saved
9
Example of line graph
Zoom Saved
Ask questions about your data
10
Click "Ask a question about your data"
Zoom Saved
11
Type "which year had the most sales" then press on [[enter]]
Zoom Saved
12
Click "Insert". You will see the result is that the 'south west' had the most sales in '2022'.
Zoom Saved
Feedback
This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe