Description:
We are seeking a Junior Data Analyst to clean, transform, analyse, and visualize data—often involving advanced tasks like pivot tables, data formatting, and quotation using Excel functionalities.
Key Advanced Excel Skills:
- Pivot Tables: Summarizing and analyzing data efficiently.
- VLOOKUP and HLOOKUP: Looking up data from one table to another.
- SUMIF and AVERAGEIF: Performing conditional calculations on data.
- INDEX MATCH: Performing more complex lookups than VLOOKUP.
- Conditional Formatting: Highlighting data based on specific criteria.
- Data Validation: Ensuring data integrity and accuracy.
- Charts and Graphs: Visualizing data to identify trends and insights.
08 May 2025;
from:
gumtree.co.za