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.

  • CreatedFebruary 20, 2015
  • Files Included
Post your question