Hi, I have experience with preparation of financial modules (in Microsoft Excel) for hospitals based on beds and health services. In this module, you will have entries user form to update the financial activities per bed, and any profit center that you need (by staff, equipment, lab, and even by product), there is a possibility to upload transactions from the central databases (like QB) and to download as well. After updating, you will get financial reports + dashboard with the significant results for any period. The application information is secured, and the access done by username and password.
I am a specialist in financial reports, budget, costing reports, inventories, bill of materials construction models together with extensive knowledge and expertise in Microsoft Excel, Pivot Tables, and Visual Basic Application including preparation of screen layout's, generator reports, 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. And have bullied all kind of Excel Applications by VBA, formulas, pivot tables, including screen layout's, reports, charts, and dynamic dashboards.