Banner Image

All Services

Other

Financial Modules in Excel and Power BI

Hello, I am a financial expert and guru in Excel and Power BI with extensive knowledge and expertise in ETL (extract, transform, load), advanced formulas, pivot tables, tables, solver and visual basics including preparation of available interfaces, dynamic dashboards, screen layout's (user-forms), drop-down boxes, generator reports, and charts (by VBscript). Also, I deal with exporting and importing big data and create automation with VBA. My modules allow filling information on forms (with drop-down list ), manipulating and merging info into structured tables and populating results in built-in reports and forms. There is a search engine with high search capability to find specific records. During the process, Excel validates the information and prepare graphical and visualisation reports and documents based on needed parameters and criteria. There is a report generator which enables you to develop templates independently. The modules are secured by username login and password. Furthermore, I have experience in accounting, financial reports, consolidating, forecasting, budgeting, costing, cash flow, multi-currency, long term debts, including collections, payments, inventory, bill of materials, taxation and bank reconciliation. With these skills, I prepare dynamic and designed reports and dashboards, for pitch decks, business plans, due diligence, financial modules, feasibility studies, and financial projections with scenarios and charts.

Skills & Expertise

Excel Advanced FormulasExcel AutomationExcel Dashboard DesignFinancialPower BI

0 Reviews for This Service

This Freelancer has not received any feedback.