I will automate excel tasks using formulas, power query, and macros
Excel Dashboards, Data Cleaning and Business Reports
About this Gig
Tired of repeating the same Excel steps every week or month?
I will create or fix Excel formulas and build practical spreadsheet automation using Power Query, simple VBA macros, buttons, and refreshable reports.
Services may include:
- Creating or repairing formulas such as XLOOKUP, VLOOKUP, IF, SUMIFS, INDEX MATCH, and date or text functions
- Automating repetitive formatting, calculations, and report updates
- Combining similarly structured Excel or CSV files with Power Query
- Creating simple VBA macros and buttons
- Fixing #N/A, #VALUE!, #REF!, and broken formula references
- Building validation checks and summary tables
- Adding refresh instructions or basic documentation when included
I focus on organized, understandable solutions that match the agreed workflow. I will not change or delete records outside the confirmed scope, and I keep a working copy during development.
Please contact me before ordering if your project includes complex VBA, protected files, external systems, multiple workbooks, confidential data, or urgent delivery. Send your Excel version, current file, and an example of the expected result so I can recommend the correct package.
Platform:
Excel
•
VBA
•
Microsoft Office
Development technology:
VBA
•
Power Query
•
Excel
Expertise:
Fixing
•
Formulas
•
Macros
•
Power Query
•
Data validation
FAQ
What should I send before ordering?
Please send your current Excel file, sample source files, a description of the manual steps, the expected result, and your Excel version.
Can you fix broken Excel formulas?
Yes. I can review and repair formula errors such as #N/A, #VALUE!, #REF!, broken references, incorrect ranges, and lookup issues.
Can you automate reports with Power Query?
Yes, when the source files have a suitable structure. I can combine, transform, and create an agreed refresh process for Excel or CSV data.
Do you create VBA macros?
Yes. I can create simple VBA macros and buttons for agreed repetitive tasks. Please contact me first for complex VBA or multiple-workbook projects.
Will the solution work in my Excel version?
Please share your Excel version before ordering. I will confirm compatibility because VBA, Power Query, and some formulas require specific desktop Excel versions.
Can you combine multiple Excel or CSV files?
Yes, if the files have a similar structure. Please send sample files first so I can confirm the best method and package.
Is my data kept confidential?
I use your files only for the agreed project and keep them private. Please remove unnecessary sensitive information before sharing whenever possible.
Do you provide instructions or documentation?
Brief refresh or usage notes are included with the Premium package. Documentation for other packages can be added through a custom offer.

