Print Сite this

Computer Applications for Managers: Using PivotTables

Pivot Table is a tool that allows a user to present data in a form that is convenient for analysis. The view of the pivot table can be quickly changed with just one click, placing data in rows or columns, choosing grouping levels, filtering, and dragging columns from one place to another. One can also apply control tools and add charts in pivot tables for creating visual reports. Examples of such reports are gross profit reports using pivot tables and budget analysis charts (“Overview of PivotTables and PivotCharts,” 2020). A business scenario can be presented as a case where a manager of an online shop needs a brief analytical report for decision making from a table with a number of inputs that contain diverse information. He or she may have data showing information on the customer portfolio of the business, where there is recorded and detailed information for each client. Therefore, to analyze the clientele base portfolio, a pivot table is unloaded from the database into Excel.

Our experts can deliver a customized essay
tailored to your instructions
for only $13.00 $11.05/page
308 qualified specialists online
Learn more

The main goal is to identify the most frequent and impactful customers and group them in order to derive a specific target market. The PivotTable will need data on the products each customer purchased, the amount of money spent, and the frequency of monthly purchases. The customer base can be immensely large, especially in online shops, where small convenient purchases can be easily made. The analysis type needs to involve creating a table where each product line is indicated with the corresponding amount of money spent. In other words, the PivotTable must show which products were sold the most to which customers as well as the total sum of revenue. This will help to identify the most sold products alongside the target market. The only drawback of pivot tables is the lack of automatic updating or recalculation when changing data in the source list.

Reference

Overview of PivotTables and PivotCharts. (2020).

Cite this paper

Select style

Reference

StudyCorgi. (2022, April 14). Computer Applications for Managers: Using PivotTables. Retrieved from https://studycorgi.com/pivottables-for-managers/

Reference

StudyCorgi. (2022, April 14). Computer Applications for Managers: Using PivotTables. https://studycorgi.com/pivottables-for-managers/

Work Cited

"Computer Applications for Managers: Using PivotTables." StudyCorgi, 14 Apr. 2022, studycorgi.com/pivottables-for-managers/.

* Hyperlink the URL after pasting it to your document

1. StudyCorgi. "Computer Applications for Managers: Using PivotTables." April 14, 2022. https://studycorgi.com/pivottables-for-managers/.


Bibliography


StudyCorgi. "Computer Applications for Managers: Using PivotTables." April 14, 2022. https://studycorgi.com/pivottables-for-managers/.

References

StudyCorgi. 2022. "Computer Applications for Managers: Using PivotTables." April 14, 2022. https://studycorgi.com/pivottables-for-managers/.

References

StudyCorgi. (2022) 'Computer Applications for Managers: Using PivotTables'. 14 April.

This paper was written and submitted to our database by a student to assist your with your own studies. You are free to use it to write your own assignment, however you must reference it properly.

If you are the original creator of this paper and no longer wish to have it published on StudyCorgi, request the removal.