Upwork home
Sign up
Project Catalog
DesignDesign
Video & AudioVideo & Audio
Development & ITDevelopment & IT
MarketingMarketing
Writing & TranslationWriting & Translation
MoreMore
Amr isn't taking new orders for this project right now. Here are some similar projects to explore.

You will get a master Excel sheet to combine data and reporting

Amr N.Status: Offline
Amr N.
5.0
Top Rated
Preview image

Let a pro handle the details

Buy Data Entry & Cleaning services from Amr, priced and ready to go.
Amr N.Status: Offline
Amr N.
5.0
Top Rated
Preview image

Let a pro handle the details

Buy Data Entry & Cleaning services from Amr, priced and ready to go.

Project details

You will get an automated master file that collects data from multiple files and output data ready for reporting.
The data transformation including filtering or calculations will be embedded in the sheet without the use of macros.
For setting up the file help will be provided to install on your computer once.
That works for any Excel desktop on Windows or Mac. Not supported for excel online
If files are on one drive / sharepoint necessary permissions are required to access the files
Data Tool
Microsoft Excel

What's included $200

These options are included with the project scope.

$200
  • Delivery Time 3 days
  • Number of Revisions 0
  • Number of Sources Mined/Scraped 2
Optional add-ons You can add these on the next page.
Fast 2 Days Delivery
+$50
5.0
13 reviews
100% Complete
(13)
1% Complete
(0)
1% Complete
(0)
1% Complete
(0)
1% Complete
(0)

ED

Emilien D.
5.00
Jun 25, 2024
Workflow execution's time optimisation AppSheet / App Script / Google Sheets Amr is by far, the best App Script I've never hired on Upwork.
He takes initiative, he really understand all of purposes of my missions and his english is pretty nice.
I could recommend him closed eyes.

Thank's for all Amr.

PJ

Parker J.
5.00
Mar 31, 2023
Looking for an Excel Sheet Expert to Help Troubleshoot Amr stepped in after I had an issue with another Upwork freelancer. I can't even begin to say how thankful I am for him. He is extremely professional, courteous, and has an impeccable level of knowledge with excel. I highly recommend working with this freelancer. We will definitely continue to work with him in the future!

SL

Shawn L.
5.00
Mar 9, 2023
Create Automated Timesheet Tracker With splendid experience and mentorship regarding automation services, I will not hesitate to do business again, you shouldn't either - you will be in great hands with Amr.

AY

Angela Y.
5.00
Mar 9, 2023
Excel Formula Request Great job on a quick turn request. I look forward to working with Amr again.

MO

Matthew O.
5.00
Feb 13, 2023
Nutrient Conversion and JSON Sorting Excellent work, delivered fast. Exceptional communication.
Amr N.Status: Offline

About Amr

Amr N.Status: Offline
Data Analyst | PowerBI Certified
100% Job Success
5.0  (13 reviews)
Alexandria, Egypt - 12:03 pm local time
With over 5 years of experience in data analysis, I have honed my skills in various areas, such as spreadsheet design, dashboard creation, and formula writing. Additionally, I am proficient in data extraction techniques like Power Query, SQL, and web scraping. My extensive knowledge of data analysis includes data cleaning, descriptive analysis, and hypothesis testing (A/B tests) methods. When it comes to data visualization, I am well-versed in Tableau, Microsoft PowerBi, and Python Matplotlib.

Steps for completing your project

After purchasing the project, send requirements so Amr can start the project.

Delivery time starts when Amr receives requirements from you.

Amr works on your project following the steps below.

Revisions may occur after the delivery date.

Initial data gathering setup

The data collection will be built based on the files provided and sent to the client.

Local setup

Step by step guide (video if needed) will be shared with the client to update the data source on their local machine

Review the work, release payment, and leave feedback to Amr.