You will get VLOOKUP, Data Extraction and Data Merging from multiple Excel spreadsheets
Project details
You will get an efficient, accurate and timely data extraction from multiple Excel spreadsheets to create data reports and analysis using VLOOKUP and other excel formulas/functions like COUNTIF/COUNTIFS, SUMIF/SUMIFS, IF (including multiple/nested IF statements), etc.
All data will be merged accurately according to their specified data fields, creating a master data list well designed and formatted according to your preference.
You will also get duplicates identitied and scrubbed out, and spreadsheets compared to identify which data is included or not included in other spreadsheets.
All data will be merged accurately according to their specified data fields, creating a master data list well designed and formatted according to your preference.
You will also get duplicates identitied and scrubbed out, and spreadsheets compared to identify which data is included or not included in other spreadsheets.
Data Tool
Microsoft ExcelWhat's included
| Service Tiers |
Starter
$20
|
Standard
$30
|
Advanced
$50
|
|---|---|---|---|
| Delivery Time | 1 day | 1 day | 2 days |
Number of Revisions | 2 | 2 | 2 |
About Onyedika
Certified BI & Data Analyst | Excel Expert | Spreadsheet Specialist
Lagos, Nigeria - 6:40 pm local time
Provides creative solutions to complex Excel spreadsheet / Google Sheets problems, and offers excellent data analytics services by utilizing Advanced Excel, including Power Query / ETL, Power BI, Power Pivot / DAX, Tableau, and SQL to extract relevant and insightful information needed to make data-driven business decisions in the right direction.
You are at the right place if you need a Microsoft Excel Specialist or Business Intelligence & Data Analyst to assist in data-related projects ranging from data analysis to data visualization, data entry, data cleaning, data transformation, data manipulation, data wrangling, data processing, data reporting, and data management.
🔶 PROFESSIONAL EXPERIENCE:
About 3 years of experience in Project Monitoring & Evaluation (M&E), and analyzing, managing and extracting relevant and insightful information from large datasets and multiple Excel spreadsheets to ensure accountability, learning, and efficiency in project implementation on a CDC-funded HIV/AIDS intervention program.
🔶 TECHNICAL SKILLS:
Adept in Advanced Microsoft Excel formulas and functions like:
✅ VLOOKUP / XLOOKUP
✅ TREND / FORECAST
✅ Pivot Tables and Pivot Charts
✅ COUNTIF / COUNTIFS
✅ IF (and nested IF), IFERROR, IFNA, AND, OR
✅ INDEX / MATCH
✅ Data Visualization Dashboard (Charts and Graphs)
✅ SUMIF / SUMIFS
✅ CORREL
✅ Date / Time Formulas
✅ Advanced Sorting and Filtering
✅ Power Query / ETL & Power Pivot / DAX
✅ Conditional Formatting (especially with formulas)
✅ Data Validation (especially dropdown lists)
✅ What-if Analysis (Goal Seek and Scenario Manager)
✅ Spreadsheet protection/cell locking
✅ Macros/VBA automation
✅ and more...
🔶 SOFT SKILLS:
Passionate about data, people, technology, music production, and human development.
A lifelong learner, value-oriented, analytical, solutions-driven, creatively inclined, and tech-savvy.
Also a cryptocurrency/blockchain enthusiast.
Steps for completing your project
After purchasing the project, send requirements so Onyedika can start the project.
Delivery time starts when Onyedika receives requirements from you.
Onyedika works on your project following the steps below.
Revisions may occur after the delivery date.
Data Cleaning
Data cleaning as required, like removing duplicates and data organization
Data Extraction
Extracting data from multiple spreadsheets, analyzing data, comparing datasets and merging data accurately. This is the main body of the work that requires the use of formulas/functions like VLOOKUP, COUNTIF/COUNTIFS, SUMIF/SUMIFS, etc.