Tech Tool: Spreadsheet Software Software Videos: Spreadsheet Data Tables, Spreadsheet PivotTables and PivotCharts You have just been
Question:
Software Videos: Spreadsheet Data Tables, Spreadsheet PivotTables and PivotCharts
You have just been hired as the new accounting intern. Your first assignment is to reformat a spreadsheet that your predecessor created. Complete the following steps.
1. Download the file for this exercise.
2. Reformat the spreadsheet into a data table format.
3. Create a PivotTable to analyze the data.
4. Create a chart that best summarizes intelligence.
5. Develop a digital dashboard that can be used to monitor results in the future.
The data file contains products ID, names, and the unit price for products sold in each sales transaction. The PivotTable and PivotChart organize this data to show revenue from each product and the count of each product sold. When you create a PivotChart, MS Excel automatically creates corresponding PivotTable. Therefore the part 4 and 5 are shown in one sheet. By adding a data slicer tool (a MS Excel tool), we can see and compare sales amount for selected items in the slicer.
Fantastic news! We've Found the answer you've been seeking!
Step by Step Answer:
Related Book For
Accounting Information Systems The Crossroads of Accounting & IT
ISBN: 978-0132991322
2nd Edition
Authors: Donna Kay, Ali Ovlia
Question Posted: