Hi, I did some similar projects. I develop modules in Microsoft Excel by using VBA, which enable you to enter and manage transactions in a spreadsheet and to get immediate reports and up-to-date information. The modules also can upload from external databases. During the process, Excel validates the data and prepares reports based on the required parameters and criteria. There is a report generator, which enables you to develop templates independently. Moreover, the files are secured by the username login and password.
About Me:
I am a financial guru and expert in Excel and VBA. I have in-depth knowledge and expertise in advanced formulas, pivot tables and Visual Basic Application, including preparing dynamic dashboards, screen layouts (UserForms), drop-down boxes, generator reports and charts. I develop financial modules, such as business valuation methods and ratios for investors, and produce pitch decks, business plans, financial projections and more.
During my over 30-year long career serving as a CFO, Controller, and Chief Accountant at various companies worldwide, I’ve gained knowledge and expertise in financial reports, accounting, consolidating, forecasting and budgeting. I have experience in implementing information systems for organisations and businesses (accounting, payroll, treasury, budgeting and control, using Intuit QuickBooks, SAP, ERP, etc) in a multi-currency environment of the global marketplace.