You will get a Clean Data for Data Analysis using Excel
Project details
Good day! Here are the details of my Gig.
Data Cleaning using Microsoft Excel
The data will be checked for the following and will do appropriate actions:
1. Null Values (will be removed)
2. Zero Values (will be removed if not valid)
3. Outliers (data treatment will depend on the client's advice)
4. Columns/Rows (will be aligned, sorted if needed)
5. Inconsistent data format (will be changed to correct format)
6. Extra spaces on Data (will be trimmed in Excel)
7. Duplicate Values (will be removed if not valid), and other Disorganized Data (will do appropriate actions as per client's advice)
8. Conditional Formatting (as per client's advice)
Add-ons for Quantitative Data:
Descriptive Statistics Summary using the Data Analysis Tool pack in Excel
Regression Table using the Data Analysis Tool pack in Excel
Correlation Table using the Data Analysis Tool pack in Excel
Not included:
1. Graphs (All Graphs)
2. Normal Distribution table/graphs
3. Dynamic Tables/Dashboard
4. VBA Automation
5. Power Query
6. Power BI
Please get in touch with me before purchasing to discuss the best fit package for your project. The consultation will be free.
Regards,
Roan Tabinas
Data Cleaning using Microsoft Excel
The data will be checked for the following and will do appropriate actions:
1. Null Values (will be removed)
2. Zero Values (will be removed if not valid)
3. Outliers (data treatment will depend on the client's advice)
4. Columns/Rows (will be aligned, sorted if needed)
5. Inconsistent data format (will be changed to correct format)
6. Extra spaces on Data (will be trimmed in Excel)
7. Duplicate Values (will be removed if not valid), and other Disorganized Data (will do appropriate actions as per client's advice)
8. Conditional Formatting (as per client's advice)
Add-ons for Quantitative Data:
Descriptive Statistics Summary using the Data Analysis Tool pack in Excel
Regression Table using the Data Analysis Tool pack in Excel
Correlation Table using the Data Analysis Tool pack in Excel
Not included:
1. Graphs (All Graphs)
2. Normal Distribution table/graphs
3. Dynamic Tables/Dashboard
4. VBA Automation
5. Power Query
6. Power BI
Please get in touch with me before purchasing to discuss the best fit package for your project. The consultation will be free.
Regards,
Roan Tabinas
Data Tool
Microsoft ExcelWhat's included
| Service Tiers |
Starter
$5
|
Standard
$20
|
Advanced
$30
|
|---|---|---|---|
| Delivery Time | 1 day | 3 days | 5 days |
Number of Revisions | Unlimited | Unlimited | Unlimited |
Optional add-ons
You can add these on the next page.
Descriptive Statistics
+$5
Linear Regression Analysis
+$5Frequently asked questions
About Roan
SQL & ETL Specialist | Data Analytics | Azure & Power BI | Excel & VBA
Imus, Philippines - 6:21 am local time
I'm Roan, a SQL Consultant based in the Philippines, currently working in the FinTech industry and pursuing my Master’s in Business Analytics.
My main skill is SQL, and I work with it every day—whether it's writing queries, debugging issues, or optimizing performance for stored procedures and functions. I also handle full ETL workflows—from extracting raw data, transforming it for use in ODS (Operational Data Store) tables, and loading it into fact and dimension tables for reporting and analytics.
Here are some of the tools I use regularly at work:
✅ SQL Server Management Studio (SSMS)
✅ Azure Portal
✅ Azure DevOps / Azure Data Factory
✅ Visual Studio Code
✅ Power BI
✅ SQL (intermediate level – performance tuning, troubleshooting, investigation)
✅Microsoft Excel
Aside from SQL, I also work on tasks related to:
✅ Building and maintaining ETL pipelines
✅ Creating dashboards and reports in Power BI
✅ Cleaning and transforming data
✅ Analyzing and reconciling financial transactions
✅ Automating reports with Excel & VBA
✅ Basic analytics using Python, Excel, and statistical tools
Why work with me?
✔️ I’m organized, detail-oriented, and reliable
✔️ I work well under pressure and can juggle multiple tasks
✔️ I communicate clearly and keep you updated regularly
✔️ I tailor every output based on what you need
✔️ I’m easy to reach and always happy to help
Thanks for taking the time to read my profile! I’d love to hear more about your project and how I can help. Feel free to message me here anytime.
📎 P.S. Don’t forget to check out my portfolio to see some of my past work!
Steps for completing your project
After purchasing the project, send requirements so Roan can start the project.
Delivery time starts when Roan receives requirements from you.
Roan works on your project following the steps below.
Revisions may occur after the delivery date.
Client to Provide Source Data in csv or excel format
Discussion on what to do with outliers or any add-ons needed