Data Entry
My attached work is below. You can also view it through this link.
In this project, I analyzed employee data that included attributes such as name, age, department, salary, and years of experience. Using spreadsheet functions, I calculated a cumulative average salary across the dataset to observe overall salary trends. Additionally, I filtered and computed the average salary specifically for the HR department ($5,208.33) to benchmark against other roles. A final Boolean column was added to indicate whether each employee's salary was above the HR department's average. This allowed for quick identification of salary outliers across departments and highlighted pay distribution patterns. The exercise demonstrates my skills in data organization, formula application (e.g., AVERAGE, AVERAGEIF, IF), and logical analysis in Excel or Google Sheets.
Data 2
After completing the initial analysis of individual employee data in Sheet 1, I created a pivot table in Sheet 2 to summarize the salary information by department. This pivot table was built directly from the data in Sheet 1, where each employee’s salary, department, and other details were recorded. The pivot aggregates the total salary per department, giving a clear overview of how salary resources are distributed across teams. For example, it shows that the Sales department has the highest total salary ($97,000), followed by Finance ($86,000), and so on. The pivot table provides a concise summary that supports higher-level insights, budget planning, and departmental comparisons.
Attached is my typing test certificate, which shows my typing speed.
My attached work is below. You can also view it through this link.
https://docs.google.com/spreadsheets/d/1ZjAxgYsfER-DCT9TNNzq0zyPGhlYnRpsGBVDlCUnr78/edit?usp=sharing
In this sample, I list the customers with outstanding mortgages by their name, customer ID, gender, location, education, position, monthly income, and outstanding mortgage amounts.
Another sample of Data Entry.
Here is the list of students, along with their subjects and remarks.
In our Data Entry training using Excel, we learn to apply different formulas to solve problems. I am using Conditional Formatting with the IF function.
