Tournament Analysis

Now that you've created a team stat sheet, we can compare the team from game to game. First  though, we'll need to add a line for rebounds. You'll need to add data for three columns, offensive Rebounds, Defensive Rebounds and Total Rebounds. Then add a line for the totals at the bottom of each column. Use the SUM function to create the totals. To get the percentages, you'll need to divide the "made" columns by the "attempts" column. Freel free to color or bold columns to make it more easy to read. Us this example:

https://docs.google.com/spreadsheets/d/1AGv8kVNCXdZe0mY4sk1B19kykykiYivQiAgkireBkSU/edit?usp=sharing

Now highlight and copy the data set and paste it twice on the sections below like to see in the example.  Next. you'll need to enter the data from the other two playoff games against CPA and Fulton. You can find the statistics on the TSSAA web site here:

http://tssaa.org/2015-bluecross-basketball-championship-scoreboard-division-i-class-aa-boys/

Simply click on Statistics next to the score for each game. Let me know if you have any questions.

Tony Robbins: How to Invest Your Way to a $70 Million Retirement Fund | ...

Analyzing Mutual Funds

Now that you have built the tools to analyze stcocks and mutual funds, lets put your knowledge to the test. Select 3 mutual funds from the Vanguard site to invest in. Create a diversified portfolio of stock mutual funds. Assuming you bought the funds one year ago, calculate how much money your portfolio would have made.

Here is the link to the list of funds you use.

https://investor.vanguard.com/mutual-funds/vanguard-mutual-funds-list

Analyzing Investments

Google Sheets makes analyzing your investments easy. To get the current price of any stock or mutual fund simply use this formula in any cell to get the number

=GoogleFinance(AA)

Simply replace AA with any stock or mutual fund ticker. Try it out on the following Stock and mutual fund tickers:

Stocks
APPL
C
GOOG
NKE

Mutual Funds
VFIAX
ARTIX
MLAIX

Now, try building a mutual fund analysis form to analyze your investment portfolio. Here is a sample:

https://docs.google.com/spreadsheets/d/1hIhFAqg2N6FAP362yWD3m8CmWfwyAqpCsnjYKFcG01I/pubhtml


If you need help, try watching this video on using Google Finance.

http://youtu.be/_uLp7DpuS_8

Spreadsheet Skills Needed

Check out this article from the Wall Street Journal. 

http://www.wsj.com/articles/BL-ATWORKB-2315