I will automate excel and dashboards with vba and power query
About this Gig
Hi, welcome to my Gig.
I will help you create, fix, automate, and improve Excel spreadsheets and Google Sheets for business, finance, reporting, accounting, and data analysis.
I have strong experience in finance systems, ERP reporting, Excel automation, SQL, Power Query, VBA, SAP and Oracle ERP. I can help you turn manual spreadsheets, messy data, and repeated reporting tasks into clean, accurate, and automated files.
Services I offer:
- Excel formulas and advanced formulas
- VBA macros and automation
- Power Query data cleaning and transformation
- Pivot tables and charts
- Excel dashboards and Google Sheets dashboards
- Financial reports and budgeting templates
- Invoice, payment, cost control and accounting sheets
- Data cleaning and formatting
- SQL-based reporting support
- ERP exported data cleaning from SAP, Oracle or other systems
- Automated reports for business, finance and management
Why choose me?
I do not only work with spreadsheets. I also understand finance, accounting, ERP systems, reporting logic, cost control, and business operations. This means I can create files that are not only nice-looking, but also useful, accurate and professional.
Please contact me before placing an order.
Technology:
Excel
•
Power BI
Analysis type:
Quantitative analysis
Programming language:
R
•
SQL
•
Other
Tools:
Microsoft Excel
•
Other
FAQ
Can you work with both Excel and Google Sheets?
Yes, I can work with Microsoft Excel and Google Sheets.
Can you create VBA macros?
Yes, I can create VBA macros for automation, reporting, formatting, calculations and repetitive tasks.
Can you clean messy data?
Yes, I can clean, format, split, merge, organize and transform messy data using Excel tools, formulas or Power Query.
Can you create dashboards?
Yes, I can create professional dashboards with charts, pivot tables, slicers, KPIs and automated calculations.
Should I contact you before ordering?
Yes, please contact me first so I can check the complexity of your task and recommend the correct package.
