I will automate excel reports with vba macros and power query

United Kingdom

I speak English

Chattered Accountant

Welcome! Your Numbers, My Expertise — Your Business, My Priority. Are you looking for a reliable Chartered Accountant who can help you manage your finances, simplify accounting, and make smarter busi...
About this Gig

Still spending hours copying, pasting, and formatting the same Excel report every week? Ill turn it into a one-click process.

I build custom Excel automation using VBA macros and Power Query so your reports refresh, clean, and format themselves.

What I can automate:

Importing and merging data from Excel, CSV, folders, PDFs, databases, and web sources

Cleaning messy data (duplicates, formatting, split/merge columns, errors)

Pivot tables, charts, and dashboards that update automatically

Report formatting, PDF export, and emailing via Outlook

Custom buttons, forms, and macros for repetitive tasks


What you get:

A clean, commented, fully working file

Simple instructions (video walkthrough on higher packages)

Free support after delivery

Strict confidentiality: your data stays private


After placing your order, please message me a sample file (remove sensitive data) and a short list of your current manual steps so I can confirm the scope and recommend the right package.

Works with Excel 2016, 2019, 2021, and Microsoft 365 (Windows).

Platform:

Excel

•

Google Sheets

•

Power BI

Development technology:

VBA

•

Google Apps Script

•

Power Query

Expertise:

Formatting

•

Fixing

•

Pivot tables

•

Formulas

•

Macros

Other Data Processing Services I Offer