Practical exercise on production statistics table in Excel
The following article guides you in detail practical exercises on production statistics in Excel 2013.
The example has the following data table:
Practical exercise on production statistics table in Excel Picture 1
Production statistics table. First calculate the total value of the items. Use visual data charts to compare between quarters of items.
Step 1: Calculate the total number of items sold in the year. In the cell to calculate enter the formula: = SUM (D5: G5) -> press Enter -> the result is:
Practical exercise on production statistics table in Excel Picture 2
Step 2: Similarly copy the remaining values to result:
Practical exercise on production statistics table in Excel Picture 3
Step 3: Select the data area to create statistical chart -> Insert -> go to Columns -> select the type of chart to create:
Practical exercise on production statistics table in Excel Picture 4
Step 4: After selecting the chart type is as shown:
Practical exercise on production statistics table in Excel Picture 5
Step 5: You can edit the title right on the chart:
Practical exercise on production statistics table in Excel Picture 6
Step 6: In case you want to change the position of notes, for example, change the notes of items to the right, do the following: Click on the chart -> click on the Chart Element icon -> Legend -> Right:
Practical exercise on production statistics table in Excel Picture 7
Step 7: After editing, there is a chart as shown:
Practical exercise on production statistics table in Excel Picture 8
Looking at the chart, you can immediately compare and statistic data between the quarter and quarterly items. Not just the numbers are aggregated anymore, charts help you to statistic data quickly, have a visual look and provide trends and remedies for limited items.
The above is a detailed guide on how to produce manufactured statistics in Excel 2013.
Good luck!
You should read it
- Practical exercise on computer rental list in Excel
- How to view Workbook Statistics in Excel
- Create descriptive statistics table for dataset in Excel
- Practical exercises on Notebook price list in Excel
- How to color the background, table color in Word, Excel
- How to use Excel Online online for free
- How to create a table, insert a table in Excel 2016
- How to repeat titles in Excel 2007, 2010 and 2013 when printing
- How to draw a table in Excel
- Complete guide to Excel 2016 (Part 1): Get familiar with Microsoft Excel
- How to insert an Excel table into Word
- Instructions to delete 0, hide 0 in Excel