I will create excel macros and automation in excel using power query
Data Analyst
About this Gig
Need to automate repetitive Excel tasks and save time? I can help simplify your workflow with Excel Data Automation using Power Query, formulas, and organized spreadsheet solutions.
Hi! I'm Muhammad Sufyan, an aspiring Data Analyst and Excel Freelancer who helps organize data and improve everyday Excel workflows.
What I Can Help With:
- Excel data automation and processing
- Power Query data cleaning and transformation
- Remove duplicates and format messy data
- Automated reports and data updates
- PivotTables for quick analysis
- Excel formulas and workflow improvements
- CSV data organization and management
Why Work With Me?
I focus on understanding your requirements, organizing data carefully, and creating practical solutions that reduce repetitive manual work. I value accuracy, clear communication, and responsible handling of your files.
Please message me before ordering so we can discuss your project, data, and the best automation solution for your needs.
Technology:
Excel
•
Google Sheets
•
VBA
My Portfolio
FAQ
Q1. What is Microsoft Excel Power Query?
Power Query is an Excel tool used to import, clean, combine, and transform data through repeatable steps.
Q2. Can you clean messy Excel data using Power Query?
Yes. I can remove duplicates, handle blank rows, correct data types, and perform other agreed transformations.
Q3. Can you combine multiple Excel or CSV files?
Yes, if the files have compatible structures. I can combine them using Power Query.
Q4. Will I be able to refresh the data later?
Yes. I can configure a refreshable query workflow when the source files and setup support it. You may need to update source paths if files are moved.
Q5. Can you merge and append queries?
Yes. I can merge tables using matching columns or append compatible tables, depending on your requirements.
Q6. Do you work with large or complex datasets?
Please contact me first. I will review the file size, data structure, transformation rules, and expected output before confirming the scope.

