Using the data in the GOOG Financials.xlsx workbook that was used in the chapter:
a. Convert the balance sheet into a format that is suitable for a pivot table by transposing the data. Don't forget to enter the word "date" above the dates.
b. Build a pivot table from the data and group the dates by months, quarters, and years.
c. Create a calculated field that shows the current ratio in the pivot table, and format the numbers with two decimal places
d. Create a pivot chart that shows the current ratio over time. Has Google's short-term liquidity position deteriorated or improved over this five-year period?
e. Now, use the Timeline to filter the pivot table so that it only shows 2009 to 2010. Now show only 2012 to 2013. Is there a difference in the trend of the current ratio in the two time periods?