1.

You will need to add a column and create a function that calculates

Cash Flow

based on criteria from

Type. Create an IF statement that returns a negative cash flow (looks like ($500.00) for example) if the type was a Withdrawal. For all other types, the cash flow should be positive.

2.

In running your pivot tables, some suggestions are to look at things like branch, account type, customer, etc. These are suggestions only. You will probably run more than just those types. Remember to run more than just SUMs in your pivot tables. You can also run MIN, MAX, COUNT, PERCENT and more. Run at least different 3 pivot tables, saving each as a separate sheet with each tab descriptively labeled (For example: Pivot 1, Pivot 2, etc.).

Include your pivot tables and

generate charts from each pivot table; include your pivots and/or charts

as images in your Word document report. (One final tip, don’t’ forget about time such as dates and days of the week and percentages in your analysis and data set.)

3.

4.

Include your observations, recommendations and analysis in your report.