Data Entry - Internship

Selected intern's day-to-day responsibilities include:

Collect, clean, and organize large datasets using Microsoft Excel and Google

Sheets

Use formulas and functions such as VLOOKUP/XLOOKUP, INDEX-MATCH, IF, COUNTIF,

SUMIF, and TEXT functions

Create and manage pivot tables and pivot charts for data analysis

Perform data validation, remove duplicates, and handle missing or incorrect

data

Maintain structured spreadsheets with proper formatting and documentation

Prepare dashboards and summary reports using charts and conditional formatting

Track and analyze data trends to support decision-making

Ensure data accuracy, consistency, and version control

Collaborate with team members using Google Sheets sharing and comments

Automate basic tasks using filters, sorting, and templates