Hi, I can complete your job for $155. You will see the transactions on "user form" ("Screen layout"), and by one click on one of them, Excel will show the transactions on "dashboard for one Customers" (seems to me that you have some transactions for each customer). Over that, Excel will show you a statistic information by numbers and charts.
I can do all kind of screen layout's, reports, and dynamic dashboards on excel by formulas, pivot tables, charts, and VBA.
I am a specialist in financial reports, budget, costing reports, inventories, bill of materials together with extensive knowledge and expertise in Microsoft Excel, Pivot Tables, and Visual Basic Application including preparation of screen layout's, generator reports showing the relevant information in dynamic dashboard and graphs.
Throughout my career, I have created dozens of financial modules, business plans, and modules for accounting, budgeting, financial reports, financial plans, and inventories reports for a range of products and services.
Areas of expertise:
• Developing of consolidated financial statements, financial plans (fitted to due diligence), feasibility studies, and measurement reporting tools for global companies
• Business valuation and ratios (NPV, IRR, DCF, MCDA, CPI, SPI, EVM, KPI, SPE (SPV FVC).
• Implementation of information systems in organizations and businesses