BYU Student Author: @Carter_Lee
Reviewers: @Dallin_Gardner, @Benjamin_lau, @Trent_Barlow
Estimated Time to Solve: 10 Minutes
This challenge was written in partnership with a accountant professional. The data, scenario or both were inspired by real-world business scenarios
We provide the solution to this challenge using:
Need a program? Click here.
Overview
Welcome to Mtasty, a leading fast-food chain committed to excellence in service and employee satisfaction. As a newly appointed accountant, your role is pivotal in analyzing employee salary data to derive actionable insights and support strategic decision-making. Mtasty wants to know the increase in salary for employees over two different years. The project aims to provide insights into salary trends, assess the impact of salary changes, and facilitate decision-making regarding compensation adjustments.
Instructions
- Open Excel and locate the sheet titled “Combined Salary Summary Report” and fill in the column titled “Year 2023” by finding each employee’s salary in 2023 in the sheet titled “Salary Report”
- Fill in the column titled “Year 2024” by finding each employee’s salary in 2024 in the sheet titled “Salary Report”
- Find the percent increase in salary for each employee by dividing “Year 2023” by “Year 2024”
- Find the name of the Employee with the highest salary increase by percent
- Take the average salary increase by percent and find the average salary increase by percent between the 2 years
- Create a new column and title it “year 2025” and find the salary of each employee if each employee gets a 6.5% increase
Data Files
Solution
Time to Complete: 10 min
Level: Beginner
Good beginner level challenge.
Challenge223_dataset.xlsx (38.6 KB)
Time to Complete: 10 min
Level: Beginner
Good beginner level challenge.
Challenge223_dataset (1).xlsx (28.5 KB)
Time to complete : 10 minutes
Rating : Beginner
I enjoyed how easy the data was to follow.
Challenge223.xlsx (37.4 KB)
Challenge223_dataset.xlsx (38.6 KB)
Time to Complete: 10 minutes
Rating: beginner
I appreciated the simplicity of the data. Very straightforward and easy to follow.
Challenge223_dataset.xlsx (36.1 KB)
Level: Beginner
Time: 15 Minutes
There it is.
Time to complete: 10 min
Level: Beginner
Good challenge for beginners in excel
Challenge223_dataset.xlsx (46.2 KB)
Time to complete: 15 min
Level: Beginner
The instructions were straight forward and that made the activity enjoyable.
Challenge223_dataset 2024.xlsx (39.0 KB)
Time to complete: 12 minutes
Level: Beginner
This was easy to solve, but some of the instructions didn’t fit the Excel sheet.
Challenge223_dataset Hailey Smith.xlsx (43.2 KB)
Time to Complete: 15 min
Level: Beginner
It was great! Super easy to finish
Challenge223_dataset.xlsx (36.5 KB)
Challenge223_dataset BM.xlsx (37.1 KB)
Time to Complete: 10 Minutes
Level: Beginner
Enjoyed the data set
Time to complete: 15 minutes
Level: Beginner
Loved the instructions and the video was easy to follow along to make sure I did everything right.
Challenge223_datasetMKTG.xlsx (37.1 KB)
Time to complete: 10 minutes
Rating: Beginner
Challenging but not to difficult
Challenge223.xlsx (37.3 KB)
Time to complete: 10 minutes
Beginner
It was fun!!
Challenge223_datasetreal.xlsx (42.0 KB)
Time to complete: 10 minutes
Rating: Beginner
Fun project, not very difficult but helps with familiarity with basic functions in excel
Challenge223_dataset.xlsx (36.1 KB)
Time to Complete: 10 minutes
Rating: Beginner
Good skills that honestly everyone should learn, I’ll make sure to continue using their youtube videos for learning. Good activity.
SONA tech hub excel.xlsx (37.4 KB)
Time to complete: 10 minutes
Rating: Beginner
This was a fun test of skills and helped remind me of different excel functions that can help in daily uses of excel.
Challenge223_dataset.xlsx (39.3 KB)
Time to complete: 15 minutes
Rating: beginner
short fun project that tested some basic skills I need to be good at.
Challenge223_dataset.xlsx (43.1 KB)