I will automate excel spreadsheets with vba macros, formulas and dashboards
Financial Modeling, Valuation and Forecasting Analyst
Level 1
Has met certain performance criteria and shows strong potential in the marketplace.
About this Gig
Your spreadsheet should do the work, not you.
I build automated Excel and Google Sheets systems that replace manual
work with formulas, VBA macros and live dashboards.
WHAT I BUILD
- Custom formulas: INDEX MATCH, XLOOKUP, SUMIFS, array and dynamic formulas
- VBA macros and userforms to automate repetitive tasks
- Power Query for cleaning and merging data automatically
- Interactive dashboards with pivot tables, slicers and charts
- Automated reports, trackers, invoices and budget templates
WHY ME
ICAP qualified in Certificate of Accounting and Finance with 4 years of audit experience at two international accounting networks. Most Excel sellers can write a macro. Few can tell you whether the numbers it produces are correct. Your file will be built to reconcile, with assumptions documented and logic you can follow after I hand it over.
HOW IT WORKS
Send me your file or a description of the task. I will confirm the scope and timeline before you order, so there are no surprises.
Every delivery includes a short walkthrough video so you can maintain the file yourself.
Message me before ordering for a custom quote.
Platform:
Excel
•
Google Sheets
•
OpenOffice
Development technology:
VBA
•
Python
•
Power Query
Expertise:
Formatting
•
Fixing
•
Pivot tables
•
Formulas
•
Functions
FAQ
Do you work with Google Sheets as well as Microsoft Excel?
Yes. I build formulas, dashboards and automation in both Excel and Google Sheets. Google Sheets automation uses Apps Script rather than VBA, and it is available as a gig extra.
Will the Excel VBA macro work on Mac?
Most VBA macros run on Mac, but some Windows-only features do not, including ActiveX controls and certain file system commands. Tell me your operating system and Excel version before ordering and I will confirm what is possible.
Can you fix or improve a spreadsheet someone else built?
Yes, and it is a large part of my work. I debug broken formulas, repair VBA macros, fix circular references and rebuild files that have become slow or unreliable. Send the file and I will quote after reviewing it.
Can you build an Excel dashboard from my raw data?
Yes. I use Power Query to clean and merge your data, then build an interactive dashboard with pivot tables, slicers and charts that refreshes automatically when new data arrives.
Do I receive the VBA source code and can I edit it later?
Yes, from the Standard package onward. The code is commented and unlocked, and Premium includes written documentation so you or your team can maintain it without me.
What do you need from me to get started?
Your Excel or CSV file, a description of the manual process you want automated, what the finished output should look like, and your Excel version and operating system. The clearer this is, the closer the first draft will be to final.
How do I know the numbers in my spreadsheet are correct?
I am ICAP qualified in Certificate of Accounting and Finance with four years of audit experience at two international accounting networks. Every file is checked so totals reconcile and assumptions are documented. Building the formula is the easy part; verifying the output is what most sellers skip.
4 reviews for this Gig
| (3) | ||
| (1) | ||
| (0) | ||
| (0) | ||
| (0) |
Rating Breakdown
- Seller communication level
- Quality of delivery
- Value of delivery
Sort By
K keith_barns

United States
Good work.
$50
Price
1 day
Duration
Helpful?H hanibol53

United States
Really responsive and quick to address issues. The product wasn’t exactly what I wanted but it’s a start to what I want and I will take it from here.
$50-$100
Price
6 days
Duration
Helpful?F fuzuli019

United States
Ongoing collaborationGreat work. Well done!
$50
Price
5 days
Duration
Helpful?K kevin_snith242

Germany
Ongoing collaborationgreat work as always. Please contact me again for new work thanks
$50
Price
4 days
Duration
Helpful?
4 reviews for this Gig
| (3) | ||
| (1) | ||
| (0) | ||
| (0) | ||
| (0) |
Rating Breakdown
- Seller communication level
- Quality of delivery
- Value of delivery
Sort By
K keith_barns

United States
Good work.
$50
Price
1 day
Duration
Helpful?H hanibol53

United States
Really responsive and quick to address issues. The product wasn’t exactly what I wanted but it’s a start to what I want and I will take it from here.
$50-$100
Price
6 days
Duration
Helpful?F fuzuli019

United States
Ongoing collaborationGreat work. Well done!
$50
Price
5 days
Duration
Helpful?K kevin_snith242

Germany
Ongoing collaborationgreat work as always. Please contact me again for new work thanks
$50
Price
4 days
Duration
Helpful?
