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
Have something to say?Create an account to leave messages for the author to see!Create an account
Feedback
This Scribe is in tip-top shape!Leave feedback if there are any issues with this Scribe