I will do excel, data cleaning, visualizations, pivot table and vlookup, xlookup
Certified MS Excel Expert and Data Scraper
About this Gig
I specializes in MS Excel and grasp full understanding in using formula, Vlookuo, Xlookup, functions, pivot table, charts and graphs. I have 10+ Years experience, I have worked and still working in Excel since last decade. I helped many enterprise across the globe to solve their problems. I can help you with any of services like:-
- Excel Formula and functions
- Designing and Formatting Worksheets
- Data Cleaning
- Summarize Data
- Charts and visualizations
- Transpose columns or rows data
- Pivot Table and Charts
- Excel advanced functions like Vlookup, Hlookup, match, date time manipulation, logical , trim and concatenate functions.
- Sort and filter data
- Remove duplicates
- Convert any file to Excel or CSV from PDF, Word and transpose data
Price plan may vary according to the requirements and complexity of the project.
Platform:
Excel
•
Google Sheets
•
Microsoft Office
Development technology:
VBA
•
Power Query
Expertise:
Formatting
•
Fixing
•
Pivot tables
•
Formulas
•
Functions
My Portfolio
FAQ
What Type Formulas I will use?
I may use basic arithmetic formulas, text formulas, date and time formulas and different conditionals.
Do You Apply theses formulas in google Sheets?
Yes, I Will apply and performs same tasks in google sheets as well?
Are you offer source file to the client?
Yes, I will provide either ms excel of google sheet to my client?
Do you performs Data Cleansing and Summarization?
Yes, if so required by client then I will definitely perform these tasks.
Can you use functions like vlookup and XLookup?
Yes, I can use and fix variety of functions like text functions, date and data manipulation function, vlookup and XLookup functions.
Are you capable to create charts and graphs?
Yes, I will create attractive charts and graphs for my client?
Are you are familiar with slicer and advanced excel tools?
Yes, conditional formatting , interlinked sheets and advance data summarization?
Can you create pivot table?
Yes, I am very comfortable with pivot table and its related functions.
Are you familiar with pivot charts?
Yes, Sure
1 reviews for this Gig
| (0) | ||
| (1) | ||
| (0) | ||
| (0) | ||
| (0) |
Rating Breakdown
- Seller communication level
- Quality of delivery
- Value of delivery
Sort By
D 
debmckenzie

Canada
thank you Nomi, appreciate your ability to transpose my excel database from vertical data to horizontal columns.
Up to $50
Price
1 day
Duration
Helpful?
1 reviews for this Gig
| (0) | ||
| (1) | ||
| (0) | ||
| (0) | ||
| (0) |
Rating Breakdown
- Seller communication level
- Quality of delivery
- Value of delivery
Sort By
D 
debmckenzie

Canada
thank you Nomi, appreciate your ability to transpose my excel database from vertical data to horizontal columns.
Up to $50
Price
1 day
Duration
Helpful?

