Excel365 The series_Practice.xlsx

	A	B	C	E	G	H	I	K	L	M
1	RAW DATA			SORTED LIST	TOP Job Title BY AVG. SALARY			TOP Job Title BY GROWTH & AVG. SALARY
2	Job Title	Avg. Salary	YoY % Growth	Job Title	Job Title	Avg. Salary	YoY % Growth	Industry	Avg. Salary	YoY % Growth
3	Data Analyst	$72,000	3.2%	#NAME?	#NAME?			#NAME?
4	Marketing Manager	$85,000	2.5%
5	HR Specialist	$62,500	2.5%
6	Software Engineer	$95,000	4.0%
7	Graphic Designer	$58,000	1.9%
8	Business Analyst	$78,500	2.7%
9	Customer Service Rep	$45,000	3.0%
10	IT Support	$55,000	3.0%
11	Sales Executive	$66,700	3.5%
12	Financial Analyst	$80,000	2.6%
13	UX Designer	$73,000	2.2%
14	Product Manager	$90,000	3.1%
15	Accountant	$65,000	2.0%
16	QA Engineer	$70,000	2.9%
17	Legal Counsel	$100,000	1.5%
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100