Buzz
This article provides a detailed guide for practical exercises on creating and analyzing production statistics tables in Excel 2013.
Consider the following data table as an example:
Create a production statistics table, starting by calculating the total value of each item. Utilize visual data charts for a comparative analysis across quarters.
Step 1: Calculate the total quantity of items sold in the year. In the cell for calculation, enter the formula: =SUM(D5:G5) -> press Enter -> the result returned is:
Step 2: Similarly, copy for the remaining values to get the result:
Step 3: Select the data range for creating a statistical chart -> Insert -> go to the Columns -> choose the type of chart to create:
Step 4: After selecting the chart type, it should look like the illustration:
Step 5: You can customize the title directly on the chart:
Step 6: In case you want to change the position of the legends, for example, move the item legends to the right, follow these steps: Click on the chart -> click on the Chart Element -> Legend -> Right:
Step 7: After editing, the chart looks like the illustration:
Look at the chart for an instant comparison and data analysis between quarters and items per quarter. It's not just aggregated numbers; the chart helps you quickly analyze data, provides a visual perspective, and identifies trends as well as remedies for limited items.
Here is a detailed guide on how to track production items in Excel 2013.
Wishing you all the best!
