You will get assistance in cleaning & formating data in Excel, Data mining & Charts
Project details
If you are looking for someone who can extract data from other sources into Excel Workbook for analysis, I am the person for you, to your utmost satisfaction.
Extract Data from CSV files to Excel
Extract Data from PDF to Excel
Extract Data from Web to Excel
Extract Data from Word to Excel
Extract Data from Databases such as MS Access to Excel
Clean the Extracted data & create Pivot Tables & charts for analysis
Clean Data of Excel using Power Query
Analyze Excel Data using advanced Functions such as SUMIFS, INDEX MATCH, OFFSET, SUMPRODUCT, etc
Work with Power Pivot
Create Dashboards for visual analysis
My Assurance:
• High working standards
• Support even after completion of the project
• On-time delivery of the Project
I am doing Data analysis for one of the largest Cotton Processing industries in India, which processes around 100,000 full-pressed cotton bales per cotton season.
I have attached screenshots of one of my projects which are self-explanatory.
You can contact me for a custom quote. I look forward to working with you.
Extract Data from CSV files to Excel
Extract Data from PDF to Excel
Extract Data from Web to Excel
Extract Data from Word to Excel
Extract Data from Databases such as MS Access to Excel
Clean the Extracted data & create Pivot Tables & charts for analysis
Clean Data of Excel using Power Query
Analyze Excel Data using advanced Functions such as SUMIFS, INDEX MATCH, OFFSET, SUMPRODUCT, etc
Work with Power Pivot
Create Dashboards for visual analysis
My Assurance:
• High working standards
• Support even after completion of the project
• On-time delivery of the Project
I am doing Data analysis for one of the largest Cotton Processing industries in India, which processes around 100,000 full-pressed cotton bales per cotton season.
I have attached screenshots of one of my projects which are self-explanatory.
You can contact me for a custom quote. I look forward to working with you.
Data Tool
Microsoft ExcelWhat's included
| Service Tiers |
Starter
$20
|
Standard
$50
|
Advanced
$100
|
|---|---|---|---|
| Delivery Time | 1 day | 2 days | 3 days |
Number of Revisions | 3 | 3 | 5 |
Number of Pages Mined/Scraped | 4 | ||
Number of Sources Mined/Scraped | 4 |
Optional add-ons
You can add these on the next page.
Fast Delivery
+$5 - $70
Additional Revision
+$5
Additional Page Mined/Scraped
(+ 2 Days)
+$5
Additional Source Mined/Scraped
(+ 2 Days)
+$5Frequently asked questions
About Alex
Excel Data Analyst, Pivot Tables, Power Pivot, Advanced Functions
Coimbatore, India - 2:28 pm local time
I am Alex.
I am from India.
I have been working with MS Excel and MS Access since 1990, right from while in service.
Well Experienced in MS Excel & MS Access:
• Convert pdf files to excel & format according to needs
• Create pivot tables and charts for analysis
• Can extract data into Excel Workbooks from pdf files, other Excel files, MS Access Databases, CSV files, from the web & so on with the help of Power Query for analyzing data
• Create Data Modal through Power Pivot
• Can work with measures in Data Modal
• Can work with the updated versions of MS Excel
I am well experienced in working with MS Access Database & designing databases for the past 30 years.
Since I worked in a corporate office for 30 years, I know very well what type of data the management require.
After retirement, some companies all over India utilized my skills to develop Access databases and Excel workbooks to analyze data from the Access databases.
Hitfilm Express:
• Create Photo Slide shows
• Create my own developed transitions
• Create opening & end credits
• Create animated texts for slide shows
I can work with Adobe Photoshop & using the software for the past 20 years since I am interested in photography. I do have the latest version of the software.
Looking forward to working with you.
Steps for completing your project
After purchasing the project, send requirements so Alex can start the project.
Delivery time starts when Alex receives requirements from you.
Alex works on your project following the steps below.
Revisions may occur after the delivery date.
Requirements
The client should inform the requirements precisely.
Instruction on nature of work
The client should inform what task to be done. Whether to clean and format existing Excel files. If data is to be imported from external sources such as CSV files, PDF, Web, Databases, etc If Pivot Tables & Charts are to be created for analysis.