目录EXCEL 第一套 条件格式、sum average mid & 分类汇总.............................................................................................................................................................................................................1EXCEL 第二套 vlookup、sumifs、averageifs...............................................................................................................................................................................................................................3EXCEL 第 3 套 条件、sum average mid 汇总 簇状图.................................................................................................................................................................................................................5EXCEL 第 4 套 mid & sumifs averageifs 图表................................................................................................................................................................................................................................7EXCEL 第 5 套 vlookup 透视表 图表.............................................................................................................................................................................................................................................8EXCEL 第 6 套 名称 vlookup 透视表 图表................................................................................................................................................................................................................................10EXCEL 第 7 套 vlookup sumifs 透视表 图表..............................................................................................................................................................................................................................12EXCEL 第 8 套 自动填充 数据有效性 区域转换 汇总........................................................