亲爱的小伙伴们，跟我学EXCEL系列福利来了，从初级一直到高级学习EXCEL系列文章，结合财务实际应用讲解，配合动图细节演示，通俗易懂，是一套比较系统的不可多见学习EXCEL的好文章。持续更新中！
本系列文章包括基础篇（包括技巧、函数）、进阶篇（主要是数据透视表）、高级篇（主要是Power Query）。
希望大家喜欢，欢迎提出宝贵意见和建议！
我们今天继续学习数据透视表。
三、EXCEL进阶篇-数据透视表05
08、数据透视表的使用---值汇总依据
我们前面说了，数据透视表不仅有合计的功能还有其他的一些功能。
我们将鼠标放置在值单元格内，右键--->“值汇总依据”，选项里有八个选项供我们使用，财务上比较常用的就是求和、计数和平均值，其他的用的比较少。截图一。
截图一
（1）、求和
求和是最常用的，我就不过多说了。需要注意的是，系统会根据值区域字段的格式自动选择“值汇总依据”，如果是数值系统会自动选择“值汇总依据”为求和，如果是文本系统会自动选择“值汇总依据”为计数，如果默认的不是我们需要的“值汇总依据”方式，右键修改即可。
（2）、计数
以前面用的“发票列表”为例，我们想统计每个月开票份数，将“发票号码”拖入相应区域即可。动图一。
动图一
（3）、平均值
以前面用的“发票列表”为例，我们还想统计每个月平均开票的含税销售额是多少，这里需要注意，字段不仅仅可以拖动到字段区域一次，可以有好多次，动图一里的“含税销售额”字段已经进行了一次求和，还可以再次拖入值区域，修改“值汇总依据”为平均值，可以求平均值。动图二。
动图二
其他的“值汇总依据”一般用得比较少就不介绍了。
在这里顺便说一下，利用数据透视表可以提取不重复项，其实很简单，实际就是把这个字段拖入行区域，形成的字段就是不重复的字段，和“数据”--->“删除重复项”功能是一样的，但用数据透视表操作稍微有一点好的地方就是，利用动态数据源可以动态刷新提取不重复项。例如想提取“发票列表”里的客户列表就可以这样操作，如果发票列表是动态变动的，我们随时刷新就可以动态提取客户列表了，比较简单，就不演示了。
09、数据透视表的使用---组合
组合是数据透视表的一个重要功能。
（1）、常规日期组合
首先我们来看日期组合里的常规组合，还是以前面用的“发票列表”为例，截图二，把光标放在数据透视表的开票日期列的任意一个单元格，右键“组合”，对话框如下，目前的组合只有“月”组合是蓝色标记，也就是按月组合。
在对话框内我们选择年、或季度、或日等等，都可以标蓝色，意思都可以按这个类型组合，既可以按单项组合也可以按多项组合，根据需要设置。组合出来的字段可以用也可以不用，可以移动字段位置任意搭建我们想要的表格样式，放行区域或列区域或筛选区域均可，根据需要放置即可，同样的，如果不想要组合了，通过这个右键的“取消组合”就行了。动图三。
截图二
动图三
有个地方大家注意些，原始字段“开票日期”根据你组合的情况会动态变化的，比如你组合日期为“月”，“开票日期”代表的是“月”，如果你组合日期为“季度”，“开票日期”代表的是“季度”，如果你组合日期为“年月日”，“开票日期”代表的是“日”，也就是说，原始字段“开票日期”始终代表你组合日期的最末级字段。
（2）、特殊日期组合
如果我们单选“日”组合，我们就会看到日期组合对话框右下角的“天数”选项由灰色不可用状态变为了黑色可用状态（截图三），这个时候我们可以选择天数来组合日字段。动图四。
截图三
动图四
（3）、综合日期组合
有人可能想按别的日期方式组合，比如按星期、按上中下旬等等怎么办？我们可以通过辅助列的方式实现。比如我们想按照上中下旬看开票数据，我们在“发票列表”增加一个函数公式辅助列，公式是=IF((DAY(H2)<=10),"上旬",IF((DAY(H2)>=21),"下旬","中旬"))（同理，想按星期的加入星期辅助列）。动图五。
动图五
这个地方要特别注意，演示用的数据透视表是静态数据透视表，也就是说数据透视表的数据源如果是静态区域，数据源区域如果有扩增，后面的数据透视表不会自动扩充汇总区域，还是使用原来的区域，想把新增数据汇总进去，就得手动修改汇总区域。
当然，如果是数据源区域有缩减就无所谓了。
可能有人会说，这也太麻烦了吧，弄成自动的多好，大家不要急，我们后面会讲到的！
修改好汇总区域，数据透视表字段列表就会多一个我们新增的“旬”字段了，就可以正常使用这个字段了。动图六。
动图六
（4）、数值组合
除了以上的日期组合，数值也是可以组合的，以一个员工登记表为例（样表在文末），我们想统计每5个年龄段的人数，就可以将年龄按每5年一个组合来统计。动图七。
动图七
（5）、文本组合
除了日期和数值可以组合，文本也是可以组合的，一个办法是像“综合日期组合”里一样，利用函数添加一个辅助列来实现，比如“发票列表”里的客户所属区域如下表：
客户名称
所属区域
A
华北
B
华北
C
华东
D
华东
E
华南
F
华南
G
东北
我们可以利用Vlookup函数在数据源表里增加一个辅助列来实现按所属区域统计，这个办法上面讲过了，这里就不重复了。
还有一个办法就是直接手动组合文本来实现这个需求，将想组合的字段选定，鼠标右键--->"组合"，将系统默认的字段名修改即可。动图八动图九。
动图八
动图九
END
数值组合案例表-员工登记表
姓名
出生日期
年龄
AA0001
1965-11-22
54
AA0002
1965-12-1
54
AA0003
1965-12-10
54
AA0004
1965-12-19
54
AA0005
1965-12-28
54
AA0006
1966-1-6
53
AA0007
1966-1-15
53
AA0008
1966-1-24
53
AA0009
1966-2-2
53
AA0010
1966-2-11
53
AA0011
1966-2-20
53
AA0012
1966-3-1
53
AA0013
1966-3-10
53
AA0014
1966-3-19
53
AA0015
1966-3-28
53
AA0016
1966-4-6
53
AA0017
1966-4-15
53
AA0018
1966-4-24
53
AA0019
1966-5-3
53
AA0020
1966-5-12
53
AA0021
1966-5-21
53
AA0022
1966-5-30
53
AA0023
1966-6-8
53
AA0024
1966-6-17
53
AA0025
1966-6-26
53
AA0026
1966-7-5
53
AA0027
1966-7-14
53
AA0028
1966-7-23
53
AA0029
1966-8-1
53
AA0030
1966-8-10
53
AA0031
1966-8-19
53
AA0032
1966-8-28
53
AA0033
1966-9-6
53
AA0034
1966-9-15
53
AA0035
1966-9-24
53
AA0036
1966-10-3
53
AA0037
1966-10-12
53
AA0038
1966-10-21
53
AA0039
1966-10-30
53
AA0040
1966-11-8
53
AA0041
1966-11-17
53
AA0042
1966-11-26
53
AA0043
1966-12-5
53
AA0044
1966-12-14
53
AA0045
1966-12-23
53
AA0046
1967-1-1
52
AA0047
1967-1-10
52
AA0048
1967-1-19
52
AA0049
1967-1-28
52
AA0050
1967-2-6
52
AA0051
1967-2-15
52
AA0052
1967-2-24
52
AA0053
1967-3-5
52
AA0054
1967-3-14
52
AA0055
1967-3-23
52
AA0056
1967-4-1
52
AA0057
1967-4-10
52
AA0058
1967-4-19
52
AA0059
1967-4-28
52
AA0060
1967-5-7
52
AA0061
1967-5-16
52
AA0062
1967-5-25
52
AA0063
1967-6-3
52
AA0064
1967-6-12
52
AA0065
1967-6-21
52
AA0066
1967-6-30
52
AA0067
1967-7-9
52
AA0068
1967-7-18
52
AA0069
1967-7-27
52
AA0070
1967-8-5
52
AA0071
1967-8-14
52
AA0072
1967-8-23
52
AA0073
1967-9-1
52
AA0074
1967-9-10
52
AA0075
1967-9-19
52
AA0076
1967-9-28
52
AA0077
1967-10-7
52
AA0078
1967-10-16
52
AA0079
1967-10-25
52
AA0080
1967-11-3
52
AA0081
1967-11-12
52
AA0082
1967-11-21
52
AA0083
1967-11-30
52
AA0084
1967-12-9
52
AA0085
1967-12-18
52
AA0086
1967-12-27
52
AA0087
1968-1-5
51
AA0088
1968-1-14
51
AA0089
1968-1-23
51
AA0090
1968-2-1
51
AA0091
1968-2-10
51
AA0092
1968-2-19
51
AA0093
1968-2-28
51
AA0094
1968-3-8
51
AA0095
1968-3-17
51
AA0096
1968-3-26
51
AA0097
1968-4-4
51
AA0098
1968-4-13
51
AA0099
1968-4-22
51
AA0100
1968-5-1
51
AA0101
1968-5-10
51
AA0102
1968-5-19
51
AA0103
1968-5-28
51
AA0104
1968-6-6
51
AA0105
1968-6-15
51
AA0106
1968-6-24
51
AA0107
1968-7-3
51
AA0108
1968-7-12
51
AA0109
1968-7-21
51
AA0110
1968-7-30
51
AA0111
1968-8-8
51
AA0112
1968-8-17
51
AA0113
1968-8-26
51
AA0114
1968-9-4
51
AA0115
1968-9-13
51
AA0116
1968-9-22
51
AA0117
1968-10-1
51
AA0118
1968-10-10
51
AA0119
1968-10-19
51
AA0120
1968-10-28
51
AA0121
1968-11-6
51
AA0122
1968-11-15
51
AA0123
1968-11-24
51
AA0124
1968-12-3
51
AA0125
1968-12-12
51
AA0126
1968-12-21
51
AA0127
1968-12-30
51
AA0128
1969-1-8
50
AA0129
1969-1-17
50
AA0130
1969-1-26
50
AA0131
1969-2-4
50
AA0132
1969-2-13
50
AA0133
1969-2-22
50
AA0134
1969-3-3
50
AA0135
1969-3-12
50
AA0136
1969-3-21
50
AA0137
1969-3-30
50
AA0138
1969-4-8
50
AA0139
1969-4-17
50
AA0140
1969-4-26
50
AA0141
1969-5-5
50
AA0142
1969-5-14
50
AA0143
1969-5-23
50
AA0144
1969-6-1
50
AA0145
1969-6-10
50
AA0146
1969-6-19
50
AA0147
1969-6-28
50
AA0148
1969-7-7
50
AA0149
1969-7-16
50
AA0150
1969-7-25
50
AA0151
1969-8-3
50
AA0152
1969-8-12
50
AA0153
1969-8-21
50
AA0154
1969-8-30
50
AA0155
1969-9-8
50
AA0156
1969-9-17
50
AA0157
1969-9-26
50
AA0158
1969-10-5
50
AA0159
1969-10-14
50
AA0160
1969-10-23
50
AA0161
1969-11-1
50
AA0162
1969-11-10
50
AA0163
1969-11-19
50
AA0164
1969-11-28
50
AA0165
1969-12-7
50
AA0166
1969-12-16
50
AA0167
1969-12-25
50
AA0168
1970-1-3
49
AA0169
1970-1-12
49
AA0170
1970-1-21
49
AA0171
1970-1-30
49
AA0172
1970-2-8
49
AA0173
1970-2-17
49
AA0174
1970-2-26
49
AA0175
1970-3-7
49
AA0176
1970-3-16
49
AA0177
1970-3-25
49
AA0178
1970-4-3
49
AA0179
1970-4-12
49
AA0180
1970-4-21
49
AA0181
1970-4-30
49
AA0182
1970-5-9
49
AA0183
1970-5-18
49
AA0184
1970-5-27
49
AA0185
1970-6-5
49
AA0186
1970-6-14
49
AA0187
1970-6-23
49
AA0188
1970-7-2
49
AA0189
1970-7-11
49
AA0190
1970-7-20
49
AA0191
1970-7-29
49
AA0192
1970-8-7
49
AA0193
1970-8-16
49
AA0194
1970-8-25
49
AA0195
1970-9-3
49
AA0196
1970-9-12
49
AA0197
1970-9-21
49
AA0198
1970-9-30
49
AA0199
1970-10-9
49
AA0200
1970-10-18
49
AA0201
1970-10-27
49
AA0202
1970-11-5
49
AA0203
1970-11-14
49
AA0204
1970-11-23
49
AA0205
1970-12-2
49
AA0206
1970-12-11
49
AA0207
1970-12-20
49
AA0208
1970-12-29
49
AA0209
1971-1-7
48
AA0210
1971-1-16
48
AA0211
1971-1-25
48
AA0212
1971-2-3
48
AA0213
1971-2-12
48
AA0214
1971-2-21
48
AA0215
1971-3-2
48
AA0216
1971-3-11
48
AA0217
1971-3-20
48
AA0218
1971-3-29
48
AA0219
1971-4-7
48
AA0220
1971-4-16
48
AA0221
1971-4-25
48
AA0222
1971-5-4
48
AA0223
1971-5-13
48
AA0224
1971-5-22
48
AA0225
1971-5-31
48
AA0226
1971-6-9
48
AA0227
1971-6-18
48
AA0228
1971-6-27
48
AA0229
1971-7-6
48
AA0230
1971-7-15
48
AA0231
1971-7-24
48
AA0232
1971-8-2
48
AA0233
1971-8-11
48
AA0234
1971-8-20
48
AA0235
1971-8-29
48
AA0236
1971-9-7
48
AA0237
1971-9-16
48
AA0238
1971-9-25
48
AA0239
1971-10-4
48
AA0240
1971-10-13
48
AA0241
1971-10-22
48
AA0242
1971-10-31
48
AA0243
1971-11-9
48
AA0244
1971-11-18
48
AA0245
1971-11-27
48
AA0246
1971-12-6
48
AA0247
1971-12-15
48
AA0248
1971-12-24
48
AA0249
1972-1-2
47
AA0250
1972-1-11
47
AA0251
1972-1-20
47
AA0252
1972-1-29
47
AA0253
1972-2-7
47
AA0254
1972-2-16
47
AA0255
1972-2-25
47
AA0256
1972-3-5
47
AA0257
1972-3-14
47
AA0258
1972-3-23
47
AA0259
1972-4-1
47
AA0260
1972-4-10
47
AA0261
1972-4-19
47
AA0262
1972-4-28
47
AA0263
1972-5-7
47
AA0264
1972-5-16
47
AA0265
1972-5-25
47
AA0266
1972-6-3
47
AA0267
1972-6-12
47
AA0268
1972-6-21
47
AA0269
1972-6-30
47
AA0270
1972-7-9
47
AA0271
1972-7-18
47
AA0272
1972-7-27
47
AA0273
1972-8-5
47
AA0274
1972-8-14
47
AA0275
1972-8-23
47
AA0276
1972-9-1
47
AA0277
1972-9-10
47
AA0278
1972-9-19
47
AA0279
1972-9-28
47
AA0280
1972-10-7
47
AA0281
1972-10-16
47
AA0282
1972-10-25
47
AA0283
1972-11-3
47
AA0284
1972-11-12
47
AA0285
1972-11-21
47
AA0286
1972-11-30
47
AA0287
1972-12-9
47
AA0288
1972-12-18
47
AA0289
1972-12-27
47
AA0290
1973-1-5
46
AA0291
1973-1-14
46
AA0292
1973-1-23
46
AA0293
1973-2-1
46
AA0294
1973-2-10
46
AA0295
1973-2-19
46
AA0296
1973-2-28
46
AA0297
1973-3-9
46
AA0298
1973-3-18
46
AA0299
1973-3-27
46
AA0300
1973-4-5
46
AA0301
1973-4-14
46
AA0302
1973-4-23
46
AA0303
1973-5-2
46
AA0304
1973-5-11
46
AA0305
1973-5-20
46
AA0306
1973-5-29
46
AA0307
1973-6-7
46
AA0308
1973-6-16
46
AA0309
1973-6-25
46
AA0310
1973-7-4
46
AA0311
1973-7-13
46
AA0312
1973-7-22
46
AA0313
1973-7-31
46
AA0314
1973-8-9
46
AA0315
1973-8-18
46
AA0316
1973-8-27
46
AA0317
1973-9-5
46
AA0318
1973-9-14
46
AA0319
1973-9-23
46
AA0320
1973-10-2
46
AA0321
1973-10-11
46
AA0322
1973-10-20
46
AA0323
1973-10-29
46
AA0324
1973-11-7
46
AA0325
1973-11-16
46
AA0326
1973-11-25
46
AA0327
1973-12-4
46
AA0328
1973-12-13
46
AA0329
1973-12-22
46
AA0330
1973-12-31
46
AA0331
1974-1-9
45
AA0332
1974-1-18
45
AA0333
1974-1-27
45
AA0334
1974-2-5
45
AA0335
1974-2-14
45
AA0336
1974-2-23
45
AA0337
1974-3-4
45
AA0338
1974-3-13
45
AA0339
1974-3-22
45
AA0340
1974-3-31
45
AA0341
1974-4-9
45
AA0342
1974-4-18
45
AA0343
1974-4-27
45
AA0344
1974-5-6
45
AA0345
1974-5-15
45
AA0346
1974-5-24
45
AA0347
1974-6-2
45
AA0348
1974-6-11
45
AA0349
1974-6-20
45
AA0350
1974-6-29
45
AA0351
1974-7-8
45
AA0352
1974-7-17
45
AA0353
1974-7-26
45
AA0354
1974-8-4
45
AA0355
1974-8-13
45
AA0356
1974-8-22
45
AA0357
1974-8-31
45
AA0358
1974-9-9
45
AA0359
1974-9-18
45
AA0360
1974-9-27
45
AA0361
1974-10-6
45
AA0362
1974-10-15
45
AA0363
1974-10-24
45
AA0364
1974-11-2
45
AA0365
1974-11-11
45
AA0366
1974-11-20
45
AA0367
1974-11-29
45
AA0368
1974-12-8
45
AA0369
1974-12-17
45
AA0370
1974-12-26
45
AA0371
1975-1-4
44
AA0372
1975-1-13
44
AA0373
1975-1-22
44
AA0374
1975-1-31
44
AA0375
1975-2-9
44
AA0376
1975-2-18
44
AA0377
1975-2-27
44
AA0378
1975-3-8
44
AA0379
1975-3-17
44
AA0380
1975-3-26
44
AA0381
1975-4-4
44
AA0382
1975-4-13
44
AA0383
1975-4-22
44
AA0384
1975-5-1
44
AA0385
1975-5-10
44
AA0386
1975-5-19
44
AA0387
1975-5-28
44
AA0388
1975-6-6
44
AA0389
1975-6-15
44
AA0390
1975-6-24
44
AA0391
1975-7-3
44
AA0392
1975-7-12
44
AA0393
1975-7-21
44
AA0394
1975-7-30
44
AA0395
1975-8-8
44
AA0396
1975-8-17
44
AA0397
1975-8-26
44
AA0398
1975-9-4
44
AA0399
1975-9-13
44
AA0400
1975-9-22
44
AA0401
1975-10-1
44
AA0402
1975-10-10
44
AA0403
1975-10-19
44
AA0404
1975-10-28
44
AA0405
1975-11-6
44
AA0406
1975-11-15
44
AA0407
1975-11-24
44
AA0408
1975-12-3
44
AA0409
1975-12-12
44
AA0410
1975-12-21
44
AA0411
1975-12-30
44
AA0412
1976-1-8
43
AA0413
1976-1-17
43
AA0414
1976-1-26
43
AA0415
1976-2-4
43
AA0416
1976-2-13
43
AA0417
1976-2-22
43
AA0418
1976-3-2
43
AA0419
1976-3-11
43
AA0420
1976-3-20
43
AA0421
1976-3-29
43
AA0422
1976-4-7
43
AA0423
1976-4-16
43
AA0424
1976-4-25
43
AA0425
1976-5-4
43
AA0426
1976-5-13
43
AA0427
1976-5-22
43
AA0428
1976-5-31
43
AA0429
1976-6-9
43
AA0430
1976-6-18
43
AA0431
1976-6-27
43
AA0432
1976-7-6
43
AA0433
1976-7-15
43
AA0434
1976-7-24
43
AA0435
1976-8-2
43
AA0436
1976-8-11
43
AA0437
1976-8-20
43
AA0438
1976-8-29
43
AA0439
1976-9-7
43
AA0440
1976-9-16
43
AA0441
1976-9-25
43
AA0442
1976-10-4
43
AA0443
1976-10-13
43
AA0444
1976-10-22
43
AA0445
1976-10-31
43
AA0446
1976-11-9
43
AA0447
1976-11-18
43
AA0448
1976-11-27
43
AA0449
1976-12-6
43
AA0450
1976-12-15
43
AA0451
1976-12-24
43
AA0452
1977-1-2
42
AA0453
1977-1-11
42
AA0454
1977-1-20
42
AA0455
1977-1-29
42
AA0456
1977-2-7
42
AA0457
1977-2-16
42
AA0458
1977-2-25
42
AA0459
1977-3-6
42
AA0460
1977-3-15
42
AA0461
1977-3-24
42
AA0462
1977-4-2
42
AA0463
1977-4-11
42
AA0464
1977-4-20
42
AA0465
1977-4-29
42
AA0466
1977-5-8
42
AA0467
1977-5-17
42
AA0468
1977-5-26
42
AA0469
1977-6-4
42
AA0470
1977-6-13
42
AA0471
1977-6-22
42
AA0472
1977-7-1
42
AA0473
1977-7-10
42
AA0474
1977-7-19
42
AA0475
1977-7-28
42
AA0476
1977-8-6
42
AA0477
1977-8-15
42
AA0478
1977-8-24
42
AA0479
1977-9-2
42
AA0480
1977-9-11
42
AA0481
1977-9-20
42
AA0482
1977-9-29
42
AA0483
1977-10-8
42
AA0484
1977-10-17
42
AA0485
1977-10-26
42
AA0486
1977-11-4
42
AA0487
1977-11-13
42
AA0488
1977-11-22
42
AA0489
1977-12-1
42
AA0490
1977-12-10
42
AA0491
1977-12-19
42
AA0492
1977-12-28
42
AA0493
1978-1-6
41
AA0494
1978-1-15
41
AA0495
1978-1-24
41
AA0496
1978-2-2
41
AA0497
1978-2-11
41
AA0498
1978-2-20
41
AA0499
1978-3-1
41
AA0500
1978-3-10
41
AA0501
1978-3-19
41
AA0502
1978-3-28
41
AA0503
1978-4-6
41
AA0504
1978-4-15
41
AA0505
1978-4-24
41
AA0506
1978-5-3
41
AA0507
1978-5-12
41
AA0508
1978-5-21
41
AA0509
1978-5-30
41
AA0510
1978-6-8
41
AA0511
1978-6-17
41
AA0512
1978-6-26
41
AA0513
1978-7-5
41
AA0514
1978-7-14
41
AA0515
1978-7-23
41
AA0516
1978-8-1
41
AA0517
1978-8-10
41
AA0518
1978-8-19
41
AA0519
1978-8-28
41
AA0520
1978-9-6
41
AA0521
1978-9-15
41
AA0522
1978-9-24
41
AA0523
1978-10-3
41
AA0524
1978-10-12
41
AA0525
1978-10-21
41
AA0526
1978-10-30
41
AA0527
1978-11-8
41
AA0528
1978-11-17
41
AA0529
1978-11-26
41
AA0530
1978-12-5
41
AA0531
1978-12-14
41
AA0532
1978-12-23
41
AA0533
1979-1-1
40
AA0534
1979-1-10
40
AA0535
1979-1-19
40
AA0536
1979-1-28
40
AA0537
1979-2-6
40
AA0538
1979-2-15
40
AA0539
1979-2-24
40
AA0540
1979-3-5
40
AA0541
1979-3-14
40
AA0542
1979-3-23
40
AA0543
1979-4-1
40
AA0544
1979-4-10
40
AA0545
1979-4-19
40
AA0546
1979-4-28
40
AA0547
1979-5-7
40
AA0548
1979-5-16
40
AA0549
1979-5-25
40
AA0550
1979-6-3
40
AA0551
1979-6-12
40
AA0552
1979-6-21
40
AA0553
1979-6-30
40
AA0554
1979-7-9
40
AA0555
1979-7-18
40
AA0556
1979-7-27
40
AA0557
1979-8-5
40
AA0558
1979-8-14
40
AA0559
1979-8-23
40
AA0560
1979-9-1
40
AA0561
1979-9-10
40
AA0562
1979-9-19
40
AA0563
1979-9-28
40
AA0564
1979-10-7
40
AA0565
1979-10-16
40
AA0566
1979-10-25
40
AA0567
1979-11-3
40
AA0568
1979-11-12
40
AA0569
1979-11-21
40
AA0570
1979-11-30
40
AA0571
1979-12-9
40
AA0572
1979-12-18
40
AA0573
1979-12-27
40
AA0574
1980-1-5
39
AA0575
1980-1-14
39
AA0576
1980-1-23
39
AA0577
1980-2-1
39
AA0578
1980-2-10
39
AA0579
1980-2-19
39
AA0580
1980-2-28
39
AA0581
1980-3-8
39
AA0582
1980-3-17
39
AA0583
1980-3-26
39
AA0584
1980-4-4
39
AA0585
1980-4-13
39
AA0586
1980-4-22
39
AA0587
1980-5-1
39
AA0588
1980-5-10
39
AA0589
1980-5-19
39
AA0590
1980-5-28
39
AA0591
1980-6-6
39
AA0592
1980-6-15
39
AA0593
1980-6-24
39
AA0594
1980-7-3
39
AA0595
1980-7-12
39
AA0596
1980-7-21
39
AA0597
1980-7-30
39
AA0598
1980-8-8
39
AA0599
1980-8-17
39
AA0600
1980-8-26
39
AA0601
1980-9-4
39
AA0602
1980-9-13
39
AA0603
1980-9-22
39
AA0604
1980-10-1
39
AA0605
1980-10-10
39
AA0606
1980-10-19
39
AA0607
1980-10-28
39
AA0608
1980-11-6
39
AA0609
1980-11-15
39
AA0610
1980-11-24
39
AA0611
1980-12-3
39
AA0612
1980-12-12
39
AA0613
1980-12-21
39
AA0614
1980-12-30
39
AA0615
1981-1-8
38
AA0616
1981-1-17
38
AA0617
1981-1-26
38
AA0618
1981-2-4
38
AA0619
1981-2-13
38
AA0620
1981-2-22
38
AA0621
1981-3-3
38
AA0622
1981-3-12
38
AA0623
1981-3-21
38
AA0624
1981-3-30
38
AA0625
1981-4-8
38
AA0626
1981-4-17
38
AA0627
1981-4-26
38
AA0628
1981-5-5
38
AA0629
1981-5-14
38
AA0630
1981-5-23
38
AA0631
1981-6-1
38
AA0632
1981-6-10
38
AA0633
1981-6-19
38
AA0634
1981-6-28
38
AA0635
1981-7-7
38
AA0636
1981-7-16
38
AA0637
1981-7-25
38
AA0638
1981-8-3
38
AA0639
1981-8-12
38
AA0640
1981-8-21
38
AA0641
1981-8-30
38
AA0642
1981-9-8
38
AA0643
1981-9-17
38
AA0644
1981-9-26
38
AA0645
1981-10-5
38
AA0646
1981-10-14
38
AA0647
1981-10-23
38
AA0648
1981-11-1
38
AA0649
1981-11-10
38
AA0650
1981-11-19
38
AA0651
1981-11-28
38
AA0652
1981-12-7
38
AA0653
1981-12-16
38
AA0654
1981-12-25
38
AA0655
1982-1-3
37
AA0656
1982-1-12
37
AA0657
1982-1-21
37
AA0658
1982-1-30
37
AA0659
1982-2-8
37
AA0660
1982-2-17
37
AA0661
1982-2-26
37
AA0662
1982-3-7
37
AA0663
1982-3-16
37
AA0664
1982-3-25
37
AA0665
1982-4-3
37
AA0666
1982-4-12
37
AA0667
1982-4-21
37
AA0668
1982-4-30
37
AA0669
1982-5-9
37
AA0670
1982-5-18
37
AA0671
1982-5-27
37
AA0672
1982-6-5
37
AA0673
1982-6-14
37
AA0674
1982-6-23
37
AA0675
1982-7-2
37
AA0676
1982-7-11
37
AA0677
1982-7-20
37
AA0678
1982-7-29
37
AA0679
1982-8-7
37
AA0680
1982-8-16
37
AA0681
1982-8-25
37
AA0682
1982-9-3
37
AA0683
1982-9-12
37
AA0684
1982-9-21
37
AA0685
1982-9-30
37
AA0686
1982-10-9
37
AA0687
1982-10-18
37
AA0688
1982-10-27
37
AA0689
1982-11-5
37
AA0690
1982-11-14
37
AA0691
1982-11-23
37
AA0692
1982-12-2
37
AA0693
1982-12-11
37
AA0694
1982-12-20
37
AA0695
1982-12-29
37
AA0696
1983-1-7
36
AA0697
1983-1-16
36
AA0698
1983-1-25
36
AA0699
1983-2-3
36
AA0700
1983-2-12
36
AA0701
1983-2-21
36
AA0702
1983-3-2
36
AA0703
1983-3-11
36
AA0704
1983-3-20
36
AA0705
1983-3-29
36
AA0706
1983-4-7
36
AA0707
1983-4-16
36
AA0708
1983-4-25
36
AA0709
1983-5-4
36
AA0710
1983-5-13
36
AA0711
1983-5-22
36
AA0712
1983-5-31
36
AA0713
1983-6-9
36
AA0714
1983-6-18
36
AA0715
1983-6-27
36
AA0716
1983-7-6
36
AA0717
1983-7-15
36
AA0718
1983-7-24
36
AA0719
1983-8-2
36
AA0720
1983-8-11
36
AA0721
1983-8-20
36
AA0722
1983-8-29
36
AA0723
1983-9-7
36
AA0724
1983-9-16
36
AA0725
1983-9-25
36
AA0726
1983-10-4
36
AA0727
1983-10-13
36
AA0728
1983-10-22
36
AA0729
1983-10-31
36
AA0730
1983-11-9
36
AA0731
1983-11-18
36
AA0732
1983-11-27
36
AA0733
1983-12-6
36
AA0734
1983-12-15
36
AA0735
1983-12-24
36
AA0736
1984-1-2
35
AA0737
1984-1-11
35
AA0738
1984-1-20
35
AA0739
1984-1-29
35
AA0740
1984-2-7
35
AA0741
1984-2-16
35
AA0742
1984-2-25
35
AA0743
1984-3-5
35
AA0744
1984-3-14
35
AA0745
1984-3-23
35
AA0746
1984-4-1
35
AA0747
1984-4-10
35
AA0748
1984-4-19
35
AA0749
1984-4-28
35
AA0750
1984-5-7
35
AA0751
1984-5-16
35
AA0752
1984-5-25
35
AA0753
1984-6-3
35
AA0754
1984-6-12
35
AA0755
1984-6-21
35
AA0756
1984-6-30
35
AA0757
1984-7-9
35
AA0758
1984-7-18
35
AA0759
1984-7-27
35
AA0760
1984-8-5
35
AA0761
1984-8-14
35
AA0762
1984-8-23
35
AA0763
1984-9-1
35
AA0764
1984-9-10
35
AA0765
1984-9-19
35
AA0766
1984-9-28
35
AA0767
1984-10-7
35
AA0768
1984-10-16
35
AA0769
1984-10-25
35
AA0770
1984-11-3
35
AA0771
1984-11-12
35
AA0772
1984-11-21
35
AA0773
1984-11-30
35
AA0774
1984-12-9
35
AA0775
1984-12-18
35
AA0776
1984-12-27
35
AA0777
1985-1-5
34
AA0778
1985-1-14
34
AA0779
1985-1-23
34
AA0780
1985-2-1
34
AA0781
1985-2-10
34
AA0782
1985-2-19
34
AA0783
1985-2-28
34
AA0784
1985-3-9
34
AA0785
1985-3-18
34
AA0786
1985-3-27
34
AA0787
1985-4-5
34
AA0788
1985-4-14
34
AA0789
1985-4-23
34
AA0790
1985-5-2
34
AA0791
1985-5-11
34
AA0792
1985-5-20
34
AA0793
1985-5-29
34
AA0794
1985-6-7
34
AA0795
1985-6-16
34
AA0796
1985-6-25
34
AA0797
1985-7-4
34
AA0798
1985-7-13
34
AA0799
1985-7-22
34
AA0800
1985-7-31
34
AA0801
1985-8-9
34
AA0802
1985-8-18
34
AA0803
1985-8-27
34
AA0804
1985-9-5
34
AA0805
1985-9-14
34
AA0806
1985-9-23
34
AA0807
1985-10-2
34
AA0808
1985-10-11
34
AA0809
1985-10-20
34
AA0810
1985-10-29
34
AA0811
1985-11-7
34
AA0812
1985-11-16
34
AA0813
1985-11-25
34
AA0814
1985-12-4
34
AA0815
1985-12-13
34
AA0816
1985-12-22
34
AA0817
1985-12-31
34
AA0818
1986-1-9
33
AA0819
1986-1-18
33
AA0820
1986-1-27
33
AA0821
1986-2-5
33
AA0822
1986-2-14
33
AA0823
1986-2-23
33
AA0824
1986-3-4
33
AA0825
1986-3-13
33
AA0826
1986-3-22
33
AA0827
1986-3-31
33
AA0828
1986-4-9
33
AA0829
1986-4-18
33
AA0830
1986-4-27
33
AA0831
1986-5-6
33
AA0832
1986-5-15
33
AA0833
1986-5-24
33
AA0834
1986-6-2
33
AA0835
1986-6-11
33
AA0836
1986-6-20
33
AA0837
1986-6-29
33
AA0838
1986-7-8
33
AA0839
1986-7-17
33
AA0840
1986-7-26
33
AA0841
1986-8-4
33
AA0842
1986-8-13
33
AA0843
1986-8-22
33
AA0844
1986-8-31
33
AA0845
1986-9-9
33
AA0846
1986-9-18
33
AA0847
1986-9-27
33
AA0848
1986-10-6
33
AA0849
1986-10-15
33
AA0850
1986-10-24
33
AA0851
1986-11-2
33
AA0852
1986-11-11
33
AA0853
1986-11-20
33
AA0854
1986-11-29
33
AA0855
1986-12-8
33
AA0856
1986-12-17
33
AA0857
1986-12-26
33
AA0858
1987-1-4
32
AA0859
1987-1-13
32
AA0860
1987-1-22
32
AA0861
1987-1-31
32
AA0862
1987-2-9
32
AA0863
1987-2-18
32
AA0864
1987-2-27
32
AA0865
1987-3-8
32
AA0866
1987-3-17
32
AA0867
1987-3-26
32
AA0868
1987-4-4
32
AA0869
1987-4-13
32
AA0870
1987-4-22
32
AA0871
1987-5-1
32
AA0872
1987-5-10
32
AA0873
1987-5-19
32
AA0874
1987-5-28
32
AA0875
1987-6-6
32
AA0876
1987-6-15
32
AA0877
1987-6-24
32
AA0878
1987-7-3
32
AA0879
1987-7-12
32
AA0880
1987-7-21
32
AA0881
1987-7-30
32
AA0882
1987-8-8
32
AA0883
1987-8-17
32
AA0884
1987-8-26
32
AA0885
1987-9-4
32
AA0886
1987-9-13
32
AA0887
1987-9-22
32
AA0888
1987-10-1
32
AA0889
1987-10-10
32
AA0890
1987-10-19
32
AA0891
1987-10-28
32
AA0892
1987-11-6
32
AA0893
1987-11-15
32
AA0894
1987-11-24
32
AA0895
1987-12-3
32
AA0896
1987-12-12
32
AA0897
1987-12-21
32
AA0898
1987-12-30
32
AA0899
1988-1-8
31
AA0900
1988-1-17
31
AA0901
1988-1-26
31
AA0902
1988-2-4
31
AA0903
1988-2-13
31
AA0904
1988-2-22
31
AA0905
1988-3-2
31
AA0906
1988-3-11
31
AA0907
1988-3-20
31
AA0908
1988-3-29
31
AA0909
1988-4-7
31
AA0910
1988-4-16
31
AA0911
1988-4-25
31
AA0912
1988-5-4
31
AA0913
1988-5-13
31
AA0914
1988-5-22
31
AA0915
1988-5-31
31
AA0916
1988-6-9
31
AA0917
1988-6-18
31
AA0918
1988-6-27
31
AA0919
1988-7-6
31
AA0920
1988-7-15
31
AA0921
1988-7-24
31
AA0922
1988-8-2
31
AA0923
1988-8-11
31
AA0924
1988-8-20
31
AA0925
1988-8-29
31
AA0926
1988-9-7
31
AA0927
1988-9-16
31
AA0928
1988-9-25
31
AA0929
1988-10-4
31
AA0930
1988-10-13
31
AA0931
1988-10-22
31
AA0932
1988-10-31
31
AA0933
1988-11-9
31
AA0934
1988-11-18
31
AA0935
1988-11-27
31
AA0936
1988-12-6
31
AA0937
1988-12-15
31
AA0938
1988-12-24
31
AA0939
1989-1-2
30
AA0940
1989-1-11
30
AA0941
1989-1-20
30
AA0942
1989-1-29
30
AA0943
1989-2-7
30
AA0944
1989-2-16
30
AA0945
1989-2-25
30
AA0946
1989-3-6
30
AA0947
1989-3-15
30
AA0948
1989-3-24
30
AA0949
1989-4-2
30
AA0950
1989-4-11
30
AA0951
1989-4-20
30
AA0952
1989-4-29
30
AA0953
1989-5-8
30
AA0954
1989-5-17
30
AA0955
1989-5-26
30
AA0956
1989-6-4
30
AA0957
1989-6-13
30
AA0958
1989-6-22
30
AA0959
1989-7-1
30
AA0960
1989-7-10
30
AA0961
1989-7-19
30
AA0962
1989-7-28
30
AA0963
1989-8-6
30
AA0964
1989-8-15
30
AA0965
1989-8-24
30
AA0966
1989-9-2
30
AA0967
1989-9-11
30
AA0968
1989-9-20
30
AA0969
1989-9-29
30
AA0970
1989-10-8
30
AA0971
1989-10-17
30
AA0972
1989-10-26
30
AA0973
1989-11-4
30
AA0974
1989-11-13
30
AA0975
1989-11-22
30
AA0976
1989-12-1
30
AA0977
1989-12-10
30
AA0978
1989-12-19
30
AA0979
1989-12-28
30
AA0980
1990-1-6
29
AA0981
1990-1-15
29
AA0982
1990-1-24
29
AA0983
1990-2-2
29
AA0984
1990-2-11
29
AA0985
1990-2-20
29
AA0986
1990-3-1
29
AA0987
1990-3-10
29
AA0988
1990-3-19
29
AA0989
1990-3-28
29
AA0990
1990-4-6
29
AA0991
1990-4-15
29
AA0992
1990-4-24
29
AA0993
1990-5-3
29
AA0994
1990-5-12
29
AA0995
1990-5-21
29
AA0996
1990-5-30
29
AA0997
1990-6-8
29
AA0998
1990-6-17
29
AA0999
1990-6-26
29
AA1000
1990-7-5
29
每日一讲excel入门 带你0基础学excel
