I will automate excel tasks using formulas, power query, and macros

India

I speak Hindi, English

1 order completed

Excel Dashboards, Data Cleaning and Business Reports

Hi, I’m Asjad. I help small businesses and professionals organize raw data and turn it into clear Excel dashboards and reports. I can assist with data cleaning, formulas, PivotTables, charts, KPI trac...
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