Accounting, Financial Projections, Business Plans, Excel, VBA, Power BI
Hello, I am a financial expert and a guru in Math, Excel, VBA, Macro and Power BI. I have considerable experience in merging files, manipulating the data in a structured database, and importing and exporting external (Intuit QuickBooks Online, XERO, SAGE SAP, ERP, REVEL, Dear etc.) files to a structured database in Excel (+ automation with VBA). I work with advanced formulas, pivot tables, visual basics including available interfaces, graphical and visualisation reports, dynamic dashboards, user-forms, drop-down boxes, generator reports, charts (by scripts) and API (trading, google maps SQL etc.). Furthermore, I have experience in accounting, financial statements, consolidating, forecasting, budgeting, costing, cash flow, payrolls,multi-currency, including collections, payments, inventory, bill of materials, taxation and bank reconciliation. With these skills, I develop financial modules which incorporate complex components of business in a simplified and logical manner. I am sure that my combined knowledge, skills and creativity will lead to exceptional results that will exceed your expectations.
What do I love to do?
* Accounting, Consolidation & reconciliation
* Modules in Excel: financial projections, inventory, stock trading (API), financial
reports, Extract & Cleaning
* Databases in Excel by algorithms, VBA/Macro and Pivot Tables
* Manipulate databases and populate reports
* Monitoring apps by algorithms, keywords and API for traders and
stockbrokers