● Importing data from various sources into Excel. ● Removing duplicate records. ● Handling missing or erroneous data. ● Standardising data formats. ● Filtering and sorting data. ● Creating calculated columns using formulas. ● Pivot tables for aggregating and summarizing data. ● Creating pivot tables and pivot charts to analyze data from different perspectives. ● Combining data from multiple sources using functions like VLOOKUP, INDEX MATCH, and Power Query. ● Merging and consolidating datasets. ● Implementing data validation rules to ensure data integrity. ● Exporting Excel data to other formats (e.g., CSV, PDF). ● Collaborating with team members on shared workbooks using Excel Online or SharePoint. ● Tracking changes and managing version control. ● Creating documentation for data sources, transformations, and analysis procedures. ● Adding comments and annotations to Excel files.

● Demonstrated confidentiality in dealing with information to comply with privacy laws. ● Identified errors in data entry and related issues, reporting to supervisors for resolution. ● Conducted data cleaning tasks to achieve productive workflow. ● Researched and requested further information to complete missing documents.