excel教程PQ课件.rar

[{"title":"（ 46 个子文件 683KB ） excel教程PQ课件.rar","children":[{"title":"2020.02.14试播课课件","children":[{"title":"工作簿汇总","children":[{"title":"河南1月销售明细.xlsx <span style='color:#111;'> 19.70KB </span>","children":null,"spread":false},{"title":"上海1月销售明细.xlsx <span style='color:#111;'> 15.30KB </span>","children":null,"spread":false},{"title":"河南3月销售明细.xlsx <span style='color:#111;'> 15.94KB </span>","children":null,"spread":false},{"title":"上海2月销售明细.xlsx <span style='color:#111;'> 11.13KB </span>","children":null,"spread":false},{"title":"湖北3月销售明细.xlsx <span style='color:#111;'> 14.06KB </span>","children":null,"spread":false},{"title":"湖北1月销售明细.xlsx <span style='color:#111;'> 15.08KB </span>","children":null,"spread":false},{"title":"河南2月销售明细.xlsx <span style='color:#111;'> 12.88KB </span>","children":null,"spread":false},{"title":"湖北2月销售明细.xlsx <span style='color:#111;'> 11.02KB </span>","children":null,"spread":false},{"title":"上海3月销售明细.xlsx <span style='color:#111;'> 12.13KB </span>","children":null,"spread":false}],"spread":true},{"title":"人员信息.xlsx <span style='color:#111;'> 13.21KB </span>","children":null,"spread":false},{"title":"工作表汇总.xlsx <span style='color:#111;'> 30.21KB </span>","children":null,"spread":false},{"title":"数据转置","children":[{"title":"数据转置.xlsx <span style='color:#111;'> 9.38KB </span>","children":null,"spread":false}],"spread":true},{"title":"逆透视","children":[{"title":"逆透视二维表转一维表.xlsx <span style='color:#111;'> 17.38KB </span>","children":null,"spread":false}],"spread":true},{"title":"工资表.xlsx <span style='color:#111;'> 10.48KB </span>","children":null,"spread":false},{"title":"删除重复项","children":[{"title":"删除重复项.xlsx <span style='color:#111;'> 8.70KB </span>","children":null,"spread":false}],"spread":true},{"title":"工作表汇总","children":[{"title":"工作表汇总.xlsx <span style='color:#111;'> 30.21KB </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"第06课 逆透视与分组依据","children":[{"title":"PI","children":[{"title":"厂家信息.xlsx <span style='color:#111;'> 8.72KB </span>","children":null,"spread":false},{"title":"店铺销售信息.xlsx <span style='color:#111;'> 9.11KB </span>","children":null,"spread":false},{"title":"店铺信息.xlsx <span style='color:#111;'> 8.53KB </span>","children":null,"spread":false}],"spread":true},{"title":"课件.xlsx <span style='color:#111;'> 26.22KB </span>","children":null,"spread":false}],"spread":true},{"title":"第09课 M函数-List.Max最大值","children":[{"title":"M.xlsx <span style='color:#111;'> 31.17KB </span>","children":null,"spread":false}],"spread":true},{"title":"第02课 自定义列","children":[{"title":"自定义列.xlsx <span style='color:#111;'> 18.60KB </span>","children":null,"spread":false}],"spread":true},{"title":"第04课 6种连接类型","children":[{"title":"课件.xlsx <span style='color:#111;'> 9.41KB </span>","children":null,"spread":false}],"spread":true},{"title":"第03课 追加查询","children":[{"title":"工作簿汇总","children":[{"title":"河南1月销售明细.xlsx <span style='color:#111;'> 19.70KB </span>","children":null,"spread":false},{"title":"上海1月销售明细.xlsx <span style='color:#111;'> 15.30KB </span>","children":null,"spread":false},{"title":"河南3月销售明细.xlsx <span style='color:#111;'> 15.94KB </span>","children":null,"spread":false},{"title":"上海2月销售明细.xlsx <span style='color:#111;'> 11.13KB </span>","children":null,"spread":false},{"title":"湖北3月销售明细.xlsx <span style='color:#111;'> 14.06KB </span>","children":null,"spread":false},{"title":"湖北1月销售明细.xlsx <span style='color:#111;'> 15.08KB </span>","children":null,"spread":false},{"title":"河南2月销售明细.xlsx <span style='color:#111;'> 12.88KB </span>","children":null,"spread":false},{"title":"湖北2月销售明细.xlsx <span style='color:#111;'> 11.02KB </span>","children":null,"spread":false},{"title":"上海3月销售明细.xlsx <span style='color:#111;'> 12.13KB </span>","children":null,"spread":false}],"spread":true},{"title":"工作表汇总.xlsx <span style='color:#111;'> 30.21KB </span>","children":null,"spread":false},{"title":"小工具收好，你工作用的到","children":[{"title":"汇总工作表.txt <span style='color:#111;'> 1.27KB </span>","children":null,"spread":false},{"title":"汇总工作簿.txt <span style='color:#111;'> 650B </span>","children":null,"spread":false}],"spread":true}],"spread":true},{"title":"第01课 认识PQ","children":[{"title":"湖北3月销售明细.xlsx <span style='color:#111;'> 14.06KB </span>","children":null,"spread":false},{"title":"湖北1月销售明细.xlsx <span style='color:#111;'> 15.08KB </span>","children":null,"spread":false},{"title":"湖北2月销售明细.xlsx <span style='color:#111;'> 11.02KB </span>","children":null,"spread":false}],"spread":true},{"title":"第05课 合并查询","children":[{"title":"人员信息.xlsx <span style='color:#111;'> 13.21KB </span>","children":null,"spread":false},{"title":"工资表.xlsx <span style='color:#111;'> 11.43KB </span>","children":null,"spread":false},{"title":"课件.xlsx <span style='color:#111;'> 14.00KB </span>","children":null,"spread":false}],"spread":true},{"title":"第10课 M函数-List.Average求平均","children":[{"title":"求平均.xlsx <span style='color:#111;'> 25.76KB </span>","children":null,"spread":false}],"spread":true},{"title":"第12课 制作笛卡尔积表","children":[{"title":"第12课 制作笛卡尔积表.xlsx <span style='color:#111;'> 9.96KB </span>","children":null,"spread":false}],"spread":true},{"title":"第08课 空行空值错误值","children":[{"title":"课件.xlsx <span style='color:#111;'> 154.27KB </span>","children":null,"spread":false}],"spread":true},{"title":"全部课程观看链接.txt <span style='color:#111;'> 1.17KB </span>","children":null,"spread":false},{"title":"第07课 条件列","children":[{"title":"条件列.xlsx <span style='color:#111;'> 17.71KB </span>","children":null,"spread":false}],"spread":true}],"spread":true}]