- Type
- Full-time
- Department
- IT
- Closing date
- Today
- Source
- Vincere
Description
Excel questions:
The client is looking for someone highly proficient in Excel, particularly when working with large volumes of data.
-
Can you give me an example of working with a large Excel dataset? Roughly how many rows or records were involved?
-
Have you used Excel to compare two sets of data, identify missing information, duplicates or discrepancies?
-
Which Excel functions are you comfortable using? For example, VLOOKUP/XLOOKUP, filters, conditional formatting or pivot tables?
-
Have you been responsible for cleansing or restructuring data ahead of a system migration or upload?
-
How do you ensure accuracy when working through large volumes of information?
Skills
Excel