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}]