Case Study. 2 pages + Excel. 26 Hour deadline

The People’s Choice Bank is a small community bank that has three local branches, in Blue Ash, 

Delhi, and Anderson Hills. The Excel file Peoples Choice Bank is a database of major account transactions for the month of August.

1.  Note that it is difficult to determine whether each trans-action in the Amount column represents a positive cash inflow or a negative cash outflow without information in other columns. Modify the database as appropriate to more easily analyze the data.

2.  Suppose that you have been asked to prepare a sum-mary of these transactions that would be clear and meaningful to the bank’s president. Use PivotTables (that are well-designed and properly formatted) to pro-vide a summary of the key information that the presi-dent and his direct reports would want to know. Justify and explain your reasoning