• Conduct research to determine which 10 stocks you will be analyzing in your portfolio and how many shares you will purchase. The amount invested can be anything over $1,000, and since this is all imaginary, the amount invested can be set very high.
• Determine which data sources you will use in your portfolio workbook.
• Think about the format your workbook will use for upcoming analysis.

1. Your column headings should include a minimum of the following information.
2. Stock Name
3. Ticker Symbol
4. Purchase Date
5. # of Shares Purchased
6. Purchase Price
7. Total Paid
8. Add the following column headings. These columns will be used in later assignments.
9. Current Stock Price
10. Current Stock Value
11. Money Made/Lost
12. Add a title row to your worksheet and center it at the top of the table
13. Use 11 pt. font for all other data.
14. Add data to the name, ticker symbol, date of purchase (today's date), number of stocks purchased, purchase price, and total price paid for each stock (use a formula when appropriate).
15. Wrap the headers so that the columns do not become too wide.
16. Resize the columns so that the width of columns fit the contents.
17. Format the cell types to match their contents (e.g. date, text, currency).
18. Rename this worksheet to "Summary".
19. Use the proofing tools to check for spelling and grammar errors.

In a separate worksheet (within the same workbook), list the data sources (websites) you have selected.

• list of web data sources that you either plan to use or are considering for use for this project.
• Be sure to include the website title, the ticker symbol, and URL for each source, and include at least five or more different sources.
• Rename this worksheet to Web Sources