I want to suggest to you an Excel application, which enables you to manage databases of records in a spreadsheet. The app allows you to open, edit and delete resources and organise a central database by information, such as schedule (start/end date), status, priority type, rates and more (the idea is to merge your tables into a central database). Based on this, you will be able to get reports and charts, like status indicators and rates. Also, I can add a search engine with high search capability to enable finding specific records. During the reporting process, Excel validates the information and prepares documents based on the required parameters and criteria. There is also a report generator, which enables to develop templates independently.
About me:
I am a financial guru and expert in Excel/VBA/Macro. I have over 30 years of experience and in-depth knowledge of advanced formulas, pivot tables and Visual Basic Application, including dynamic dashboards, screen layouts (UserForms), drop-down boxes, generator reports and charts. Furthermore, I have expertise in financial statements, accounting, consolidating, forecasting, budgeting and cost acquisition based on inventory, bill of materials, collections, payments and bank reconciliation. With these skills, I develop financial modules, which incorporate complex components of business in an easy-to-use and logical manner.