I will do excel, data cleaning, visualizations, pivot table and vlookup, xlookup
Certified MS Excel Expert and Data Scraper
Over deze dienst
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
Ontwikkelingstechnologie:
vba
•
Power Query
Mijn portfolio
Veelgestelde vragen
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 van deze dienst
| (0) | ||
| (1) | ||
| (0) | ||
| (0) | ||
| (0) |
Specificering van de beoordeling
- Communicatieniveau van de freelancer
- Kwaliteit van de levering
- Waarde van de levering
Sorteer op
D 
debmckenzie

Canada
thank you Nomi, appreciate your ability to transpose my excel database from vertical data to horizontal columns.
Tot maximaal US$ 50
Prijs
1 dag
Looptijd
Nuttig?
1 reviews van deze dienst
| (0) | ||
| (1) | ||
| (0) | ||
| (0) | ||
| (0) |
Specificering van de beoordeling
- Communicatieniveau van de freelancer
- Kwaliteit van de levering
- Waarde van de levering
Sorteer op
D 
debmckenzie

Canada
thank you Nomi, appreciate your ability to transpose my excel database from vertical data to horizontal columns.
Tot maximaal US$ 50
Prijs
1 dag
Looptijd
Nuttig?

