Time to Complete: 10 minutes
Rating: Easy
Challenge223_dataset.xlsx (38.3 KB)
Time to Complete: 15 minutes
Difficulty: Beginner
Helped me practice different keyboard shortcuts and also allowed me to be a bit more creative on some functions.
Challenge223_dataset_LH.xlsx (46.0 KB)
Time to Complete: 10 min
Rating: Beginner
Completed Challenge dataset.xlsx (40.1 KB)
Challenge223_dataset.xlsx (39.2 KB)
This was a fun challenge! Roughly 10 minutes.
Challenge223_dataset.xlsx (5.0 MB)
- =XLOOKUP(A4,‘Salary Summary Report For 2023’!$A$4:$A$199,‘Salary Summary Report For 2023’!$D$4:$D$199)
- =XLOOKUP(A4,‘Salary Summary Report For 2024’!$A$4:$A$199,‘Salary Summary Report For 2024’!$D$4:$D$199)
- =1-(D4/E4)
- =XLOOKUP(MAX(G4:G199), G4:G199,B4:B199&" "&C4:C199)
- 28.59%
- =E4*1.065
Time to complete: 15 min
Rating: beginner
Solution:
Drew Excel Challenge.xlsx (39.9 KB)
Good review of XLookup.
Challenge223_dataset.xlsx (41.1 KB)
Challenge223_dataset.xlsx (39.1 KB)
Time to complete: 15 min
Level: beginner
Challenge223_dataset.xlsx (40.2 KB)
Time to complete: 15 min
Difficulty: Beginner
I got tripped up on the instructions
Challenge223_dataset_Solved.xlsx (39.5 KB)
Challenge223_dataset_solution.xlsx (40.1 KB)
Time to Complete: 15 mins
Difficulty: Beginner
Challenge223_dataset_solved.xlsx (36.4 KB)
Time: 10 Minutes
Difficulty Beginner
Solution:
Challenge223_dataset.xlsx (39.2 KB)
Challenge223_dataset.xlsx (39.6 KB)
| Highest Payed Employee | Gabriel | Holland |
|---|---|---|
| Average Salary For 2023 | $66,620 | |
| Average Salary For 2024 | $93,286 | |
| Average Increase | 32.62% |
Time to Complete: 10mins
Rating: Easy
Challenge223_dataset.xlsx