I will create advanced excel formulas and data clean
I will create Excel formulas,lookups, logical function and conditional formating
About this Gig
I can help you data clean, data lookup, data conditional formating, match, and organize data using Excel lookup functions. Whether you need to retrieve email addresses, text values, numbers, or other information, I will provide accurate and efficient results.
Services include:
* DATA CLEAN
* DATA CONDITIONAL FORMATING
* VLOOKUP
* XLOOKUP
* HLOOKUP
* Data Matching
* Data Organization
* DATA LOOKUP
I am committed to delivering quality work with quick communication and on-time delivery.
Technology:
Excel
•
Google Sheets
Industry:
Construction
•
Events Planning
•
Gaming
•
Real estate
Data type:
Numeric
•
String
•
Date
•
Free text
•
Custom
FAQ
What information do you need to get started ?
Please provide your Excel file and a brief description of the task
Can you work with email, text, and number data?
Yes, I can lookup, match, and organize email, text, and number data.
Which Excel functions do you use?
I work with VLOOKUP, XLOOKUP, HLOOKUP, IF, IFS, SUMIF, COUNTIF, and other Excel formulas.
What is included in data cleaning?
Data cleaning includes removing duplicates, fixing formatting issues, organizing data, and improving data quality.
What type of conditional formatting can you apply?
I can highlight duplicates, blanks, specific values, dates, top/bottom values, and custom conditions

