Data Analyst
Data Cleaning and Preparation: • Removing duplicates. • Handling missing values.Data Analysis: • Sorting and filtering data. • Using pivot tables to summarize data. • Using Excel functions like VLOOKUP, HLOOKUP, INDEX, and more for data retrieval and analysis.Data Visualization: • Creating charts and graphs (e.g., bar charts, line charts, pie charts). • Using conditional formatting to highlight key data points.Automation: • Recording and running macros to automate repetitive tasks.Reporting: • Generating regular reports and summaries. • Using templates to standardize reporting formats. • Exporting data and reports to other formats (e.g., PDF, CSV).