Tech Tool: Spreadsheet Software Software Videos: Spreadsheet Data Tables, Spreadsheet PivotTables and PivotCharts Now that you have

Question:

Tech Tool: Spreadsheet Software
Software Videos: Spreadsheet Data Tables, Spreadsheet PivotTables and PivotCharts
Now that you have a full-time position, you have decided to start investing. You have invested in three different companies. You are using a spreadsheet to track stock prices for the three different companies for a 12-month period.
Download the spreadsheet data file for this exercise.
Create a PivotTable to analyze the data.
Create a line chart to contrast the stock performance of the three companies.
Develop a digital dashboard that can be used to monitor stock performance.

The data file contains weekly stock price for GE, IBM, and Expedia for year 2010.


Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Question Posted: