You will get Microsoft excel data entry, VBA and macros, clean and formatted data.


Project details
My core goal is to help you achieve data cleaning tasks and to alter your scattered data into a readable and user-friendly form. MS Excel, its formulas, Data Entry, Data Manipulation, Data Merge, Data Cleanup, Formatting etc. I will be your ideal VA to outstand all your requirements and deliver you the best of my work!
Here are the mentioned problems I can solve for you:
-Data Cleaning and formatting
-Data Analysis
-Scan/PDF to Excel conversion
-Collect data from a website to excel
-The first name and Last name separation
-Address formatting
-Concatenating different excel files
-Create Professional automated Dashboards.
-Beautify your Spreadsheet.
-Create / Correct Simple / Complex Nested Formulas.
-VLOOKUP & HLOOKUP, INDEX-MATCH, OFFSET, SUMIF, SUMIFS, and many more...
-Pivot Tables.
-Macros
-UserForms
-Customized Scripting
-Conditional Formatting
-Graphs and Charts
Note: Please discuss the project before sending offer.
Here are the mentioned problems I can solve for you:
-Data Cleaning and formatting
-Data Analysis
-Scan/PDF to Excel conversion
-Collect data from a website to excel
-The first name and Last name separation
-Address formatting
-Concatenating different excel files
-Create Professional automated Dashboards.
-Beautify your Spreadsheet.
-Create / Correct Simple / Complex Nested Formulas.
-VLOOKUP & HLOOKUP, INDEX-MATCH, OFFSET, SUMIF, SUMIFS, and many more...
-Pivot Tables.
-Macros
-UserForms
-Customized Scripting
-Conditional Formatting
-Graphs and Charts
Note: Please discuss the project before sending offer.
Data Tool
Microsoft ExcelWhat's included
| Service Tiers |
Starter
$50
|
Standard
$300
|
Advanced
$500
|
|---|---|---|---|
| Delivery Time | 2 days | 5 days | 7 days |
Number of Revisions | 1 | 1 | 1 |
Number of Pages Mined/Scraped | 10 | 50 | 100 |
Number of Sources Mined/Scraped | 1 | 2 | 5 |
Optional add-ons
You can add these on the next page.
Macros
+$100
Button forms
+$100
model documentation
+$100
2 reviews
(1)
(0)
(1)
(0)
(0)
This project doesn't have any reviews.
PA
Paul A.
Apr 21, 2023
Data ETL
PA
Paul A.
Apr 18, 2023
Big Data
About Umer
Cloud Data Engineer and Analyst
Karachi, Pakistan - 7:55 am local time
What do I offer?
DATA ENGINEERING
MICROSOFT AZURE:
Data Lake
Data Warehouse
Cloud Database
Azure Data Factory
Azure Storage
Azure SQL
Blob
AWS:
Amazon Redshift
AWS EMR
AWS RDS
AWS DMS
AWS Security
AWS EC2
AWS Athena
AWS S3
AWS Appflow (SAAS)
GOOGLE CLOUD PLATFORM:
BigQuery
Dataflow
DataProc
Data Transfer
Data Warehouse
Frameworks:
Apache Spark
Hadoop
Hive
DATA VISUALIZATION:
Microsoft Excel
Power BI
Tableau
AWS Quicksight
SCRAPING AND AUTOMATION
*HTML, CSS, and JavaScript
*Scrapy
*Scrap images and pdfs from a website
*Beautiful Soup4
*Selenium
*Bot Development
*Pandas
*Lead Generation
*Regex Parsing
* SQL, MYSQL integration
*MongoDB integration
*Email integration
* AWS integration
*File Handling
DATA MINING AND AUTOMATION With:
*Microsoft Excel
*Microsoft Word
Everyone wants to have accurate work within a good time, I'm capable of that. Please feel free to inquire about the services I'm offering. I'll be glad to help you with numerous solutions.
Regards,
Umer
Steps for completing your project
After purchasing the project, send requirements so Umer can start the project.
Delivery time starts when Umer receives requirements from you.
Umer works on your project following the steps below.
Revisions may occur after the delivery date.
Requirements:
Briefly discuss the scope and project requirements.
Create Outline:
We will schedule the time interval for the tasks to be completed.