kl800.com省心范文网

EXCEL教程__人力资源篇[1]汇编_图文

2

2.1 4

2.2

5

2.3

6

2.1 4
2.1.1

Excel

" "Excel

2.1.2

2-1

2-2

2.1.3
COUNTIF

2.1.4
1
1Excel 2003
2" "
3"" Sheet1" "

2 ""
""

1"" ""
2

3" .prn"
4"" "" "" "1" "936 GB2312"

5 ""
6

3 ""
1 2

4 ""


5 ""
1""
2 """ 5" "2005-2007"

6
7 5
8 2005-2007

9
1Sheet2" "
2
3"" B3

4"=COUNTIF( !$D$2:$D$26,"")" EnterB3""
5

10
1"" A2:B9 2"" 3

2.1.5
" " COUNTIF


2.1.6
1.80
2.""
3.

2.2 5
2.2.1


"" Excel

2.2.2

2-3

2-4

2.2.3
AVERAGESUM COUNTIFRANK

2.2.4
1
1Excel 2003
2" "
3"" Sheet1" "

2 ""
1""
2

3 ""
4 """"
1"" 2""

5

0100

6 "" 7 RANK
1I3

2 "=RANK(H3,$H$3:$H$21)" Enter
3I3 I21I4:H21

8
1A22" "
2D22 "=AVERAGE(D3:D21)" Enter

5D22 F22 E22:F22

9 COUNTIF
80

1G22" "
2I22 "=COUNTIF(G3:G21,"<80")"
3Enter

10
""" "1

11
1 2 3

4
5

12
1""
2

3"""" """"
4" "

5 Sheet4 Chart1Sheet4 Sheet4
"" Chart1Chart1
" "

2.2.5
"" AVERAGESUM COUNTIFRANK


2.2.6
1. 2. 3.

2.3 6
2.3.1


"" Excel

2.3.2

2-5

2-6

2.3.3
YearRoundVlookupIF INDEXROWCOLUMNINT

2.3.4
1
1Excel 2003
2" "
3"" Sheet1" "

2 ""
"" " "

3 ""
1""
2""" """""" "

2-60

3E1F1G1 """ """
4""

5"" =*50% 6""
""10 50050

4 ""
1"" " "
2""" """
3E1F1 """"

4
5
= /30/8*1.5*

5 ""
1"" " "
2""" """

3E1:K1 """"" """"" """"

4"""" ""
5""
50

6""
50%"= /30*0.5*"

7""
"=/30* "
8""

6 ""
1Sheet2" "
2
3"""" ""

4""" """""

D3
"VLOOKUP"

""
D3 D26D3:D26

5" """""
6""
7""

8""
=+ *8%

9""
=+ *2%

10""
=+ *1%
11""

12""
13""
=* - 2-1

2-1

N3
=IF(M3>2000,IF((M3-2000)<=500,(M32000)*0.05,IF(AND((M3-2000)>500,(M32000)<=2000),(M3-2000)*0.1-25)),0)

Enter,
N3 N26N3:N26

13""

7 ""
1
2 ""2 ""

3
4"""" "" """ "

8 ""
1Sheet3" "
2""A1

3"" Enter
=IF(MOD(ROW(),3)=0,"",IF(MOD( ROW(),3)=1, !A$2,INDEX( !$A:$O,INT((ROW()-
1)/3)+3,COLUMN())))

4A1 O1 B1:O1
5A1:O1 O74 A2:O74

6
7""

2.3.5
"" YearDatedif TodayRoundSum" """" "

VlookupIF ""
INDEXROW COLUMNINT""

2.3.6
1. 2.