excel 练习素材-刘伟

[{"title":"（ 52 个子文件 1.3MB ） excel 练习素材-刘伟","children":[{"title":"第6章：数据透视图","children":[{"title":"06-02 设置透视图.xlsx <span style='color:#111;'> 27.67KB </span>","children":null,"spread":false},{"title":"06-01 创建数据透视图.xlsx <span style='color:#111;'> 25.13KB </span>","children":null,"spread":false},{"title":"06-04 格式图表.xlsx <span style='color:#111;'> 28.94KB </span>","children":null,"spread":false},{"title":"06-05 图表模板.xlsx <span style='color:#111;'> 31.13KB </span>","children":null,"spread":false},{"title":"06-03 筛选图表数据项.xlsx <span style='color:#111;'> 28.11KB </span>","children":null,"spread":false}],"spread":true},{"title":"第5章：数据透视分析","children":[{"title":"05-06 数据条.xlsx <span style='color:#111;'> 26.77KB </span>","children":null,"spread":false},{"title":"05-03 切片器.xlsx <span style='color:#111;'> 33.87KB </span>","children":null,"spread":false},{"title":"05-05 突出显示特定值.xlsx <span style='color:#111;'> 26.49KB </span>","children":null,"spread":false},{"title":"05-07 色阶.xlsx <span style='color:#111;'> 26.63KB </span>","children":null,"spread":false},{"title":"05-08 图标集.xlsx <span style='color:#111;'> 26.63KB </span>","children":null,"spread":false},{"title":"05-09 编辑条件格式.xlsx <span style='color:#111;'> 25.88KB </span>","children":null,"spread":false},{"title":"05-02 筛选.xlsx <span style='color:#111;'> 28.96KB </span>","children":null,"spread":false},{"title":"05-04 清除已删标题项.xlsx <span style='color:#111;'> 44.61KB </span>","children":null,"spread":false},{"title":"05-01 排序.xlsx <span style='color:#111;'> 29.34KB </span>","children":null,"spread":false}],"spread":true},{"title":"第7章：打印","children":[{"title":"07-04 打印透视图.xlsx <span style='color:#111;'> 37.91KB </span>","children":null,"spread":false},{"title":"07-03 重复打印行标签.xlsx <span style='color:#111;'> 36.10KB </span>","children":null,"spread":false},{"title":"07-02 分项、分页打印.xlsx <span style='color:#111;'> 47.82KB </span>","children":null,"spread":false},{"title":"07-01 打印透视表.xlsx <span style='color:#111;'> 35.47KB </span>","children":null,"spread":false}],"spread":true},{"title":"第4章：值的汇总及显示方式","children":[{"title":"04-03 多字段百分比显示.xlsx <span style='color:#111;'> 32.63KB </span>","children":null,"spread":false},{"title":"04-07 升序、降序显示.xlsx <span style='color:#111;'> 31.34KB </span>","children":null,"spread":false},{"title":"04-02 值百分比显示.xlsx <span style='color:#111;'> 30.37KB </span>","children":null,"spread":false},{"title":"04-05 差异显示.xlsx <span style='color:#111;'> 32.02KB </span>","children":null,"spread":false},{"title":"04-04 父级百分比显示.xlsx <span style='color:#111;'> 32.27KB </span>","children":null,"spread":false},{"title":"04-06 累计值.xlsx <span style='color:#111;'> 34.15KB </span>","children":null,"spread":false},{"title":"04-01 值多汇总显示.xlsx <span style='color:#111;'> 30.26KB </span>","children":null,"spread":false}],"spread":true},{"title":"第3章：数据透视计算","children":[{"title":"03-01 日期组合.xlsx <span style='color:#111;'> 43.83KB </span>","children":null,"spread":false},{"title":"03-02 数值组合.xlsx <span style='color:#111;'> 47.64KB </span>","children":null,"spread":false},{"title":"03-04 计算字段.xlsx <span style='color:#111;'> 49.43KB </span>","children":null,"spread":false},{"title":"03-03 自定义组合.xlsx <span style='color:#111;'> 19.33KB </span>","children":null,"spread":false},{"title":"03-06 计算项.xlsx <span style='color:#111;'> 46.28KB </span>","children":null,"spread":false},{"title":"03-07 求解次序及列出公式.xlsx <span style='color:#111;'> 31.19KB </span>","children":null,"spread":false},{"title":"03-05 计算字段的局限性.xlsx <span style='color:#111;'> 21.21KB </span>","children":null,"spread":false}],"spread":true},{"title":"第2章：创建数据透视表","children":[{"title":"02-04 数据透视背后原理.xlsx <span style='color:#111;'> 44.19KB </span>","children":null,"spread":false},{"title":"02-08 报表布局.xlsx <span style='color:#111;'> 44.51KB </span>","children":null,"spread":false},{"title":"02-13 刷新及更改数据源.xlsx <span style='color:#111;'> 41.50KB </span>","children":null,"spread":false},{"title":"02-14 创建单页字段透视表.xlsx <span style='color:#111;'> 18.94KB </span>","children":null,"spread":false},{"title":"02-01 数据透视规范.xlsx <span style='color:#111;'> 45.54KB </span>","children":null,"spread":false},{"title":"02-18 格式数据透视表.xlsx <span style='color:#111;'> 29.62KB </span>","children":null,"spread":false},{"title":"02-17 导入Access文件.xlsx <span style='color:#111;'> 9.65KB </span>","children":null,"spread":false},{"title":"02-11 整理复合字段.xlsx <span style='color:#111;'> 43.28KB </span>","children":null,"spread":false},{"title":"02-12 推迟布局更新.xlsx <span style='color:#111;'> 84.77KB </span>","children":null,"spread":false},{"title":"02-16 引用外部数据.xlsx <span style='color:#111;'> 14.35KB </span>","children":null,"spread":false},{"title":"02-02 创建数据透视表 .xlsx <span style='color:#111;'> 29.18KB </span>","children":null,"spread":false},{"title":"02-05 多字段布局.xlsx <span style='color:#111;'> 43.38KB </span>","children":null,"spread":false},{"title":"02-10 合并标签.xlsx <span style='color:#111;'> 44.30KB </span>","children":null,"spread":false},{"title":"02-06 父字段项与子字段项.xlsx <span style='color:#111;'> 43.66KB </span>","children":null,"spread":false},{"title":"02-03 数据透视术语及结构 .xlsx <span style='color:#111;'> 19.71KB </span>","children":null,"spread":false},{"title":"02-16 连接外部Excel文件.xlsx <span style='color:#111;'> 9.65KB </span>","children":null,"spread":false},{"title":"02-07 功能选项卡.xlsx <span style='color:#111;'> 44.51KB </span>","children":null,"spread":false},{"title":"02-15 创建自定义字段透视表.xlsx <span style='color:#111;'> 24.75KB </span>","children":null,"spread":false},{"title":"02-09 分类汇总、空行、总计.xlsx <span style='color:#111;'> 43.83KB </span>","children":null,"spread":false},{"title":"02-17 汽车销售收入数据.accdb <span style='color:#111;'> 744.00KB </span>","children":null,"spread":false}],"spread":false}],"spread":true}]