Hi, I already done the excel file. Can send to you anytime. In this file I already add in Pivot table and chart and make the bank balance page more tidy. I'm sure bank balance page and Pivot table page is what you want, but my chart page still not enough professional.
I have skill work with excel program,i can build system with excel for make simply report with nice view, please check my portfolio, and I am graduated in accounting courses.
In Microsoft Excel formulas I am confident in using Vlookup, If, And, Or, Sumif(s), Countif(s), and how to combine multiple formulas and use Sort, Filters, Data Validation, Conditional Formatting, Pivot tables.