I need help with #2, How would i do the pivot tables and the formulas, please show work so i can see it and understand it

People's Choice Bank - August Account History
Date	Day of Week	Account	Type	Amount	Transaction Type	Customer	Branch
1-Aug	Friday	Savings	New Account	$2,600.00	Inflow	New	Anderson Hills
1-Aug	Friday	Checking	New Account	$485.00	Inflow	New	Blue Ash
1-Aug	Friday	Checking	New Account	$3,075.00	Inflow	New	Anderson Hills
1-Aug	Friday	Checking	New Account	$3,565.00	Inflow	New	Blue Ash
1-Aug	Friday	Checking	New Account	$625.00	Inflow	New	Anderson Hills
1-Aug	Friday	Certificate of Deposit	New Account	$39,750.00	Inflow	New	Blue Ash
1-Aug	Friday	Certificate of Deposit	New Account	$49,300.00	Inflow	New	Delhi
1-Aug	Friday	Certificate of Deposit	New Account	$19,600.00	Inflow	New	Blue Ash
1-Aug	Friday	Savings	Deposit	$3,000.00	Inflow	Current	Delhi
1-Aug	Friday	Savings	Deposit	$1,100.00	Inflow	Current	Anderson Hills
1-Aug	Friday	Savings	Deposit	$1,500.00	Inflow	Current	Anderson Hills
1-Aug	Friday	IRA	Current Contribution	$1,105.00	Inflow	Current	Anderson Hills
1-Aug	Friday	Checking	Withdrawal	$3,825.00	Inflow	Current	Anderson Hills
1-Aug	Friday	Checking	Deposit	$3,550.00	Inflow	Current	Anderson Hills
1-Aug	Friday	Checking	Deposit	$940.00	Inflow	Current	Blue Ash
1-Aug	Friday	Checking	Deposit	$250.00	Inflow	Current	Delhi
1-Aug	Friday	Checking	Deposit	$3,095.00	Inflow	Current	Anderson Hills
1-Aug	Friday	Checking	Withdrawal	$890.00	Inflow	Current	Anderson Hills
1-Aug	Friday	Checking	Deposit	$760.00	Inflow	Current	Blue Ash
1-Aug	Friday	Checking	Deposit	$750.00	Inflow	Current	Anderson Hills
1-Aug	Friday	Checking	Withdrawal	$420.00	Inflow	Current	Anderson Hills
1-Aug	Friday	Checking	Deposit	$140.00	Inflow	Current	Anderson Hills
1-Aug	Friday	Checking	Withdrawal	$930.00	Inflow	Current	Blue Ash
1-Aug	Friday	Checking	Withdrawal	$330.00	Inflow	Current	Anderson Hills
1-Aug	Friday	Checking	Withdrawal	$130.00	Inflow	Current	Anderson Hills
1-Aug	Friday	Checking	Deposit	$170.00	Inflow	Current	Anderson Hills
1-Aug	Friday	Checking	Deposit	$987.00	Inflow	Current	Delhi
1-Aug	Friday	Certificate of Deposit	New	$58,800.00	Inflow	Current	Anderson Hills

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 transaction 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 summary of these transactions that would be clear and meaningful to the bank's president. Use PivotTables (that are well-designed and properly formatted) to provide a summary of the key information that the president and his direct reports would want to know. Justify and explain your reasoning