库存结构分析---数据透视表操作手册宝洁公司分销商渠道多功能小组目录一、报表准备........................................................................................................11．下载..................................................................................................................1二、报表整理........................................................................................................12．增加销售数据..................................................................................................13．输入公式..........................................................................................................14．复制公式..........................................................................................................25．选中数据域......................................................................................................26．排序..................................................................................................................37．另存新品..........................................................................................................38．输入销量排名..................................................................................................4三、制作库存结构透视表....................................................................................49．选中数据区域..................................................................................................410．进入向导........................................................................................................411．进入布局界面................................................................................................512．布局透视表....................................................................................................513．调整字段格式................................................................................................614．完成布局........................................................................................................715．调整透视表....................................................................................................716．组合数据........................................................................................................817．库存ABC分类..............................................................................................818．分析................................................................................................................9四、制作库存天数分布透视表..........................................................................1119．进入布局界面..............................................................................................1120．透视表布局..................................................................................................1121．调整字段格式..............................................................................................1122．组合库存天数..............................................................................................1223．库存天数分段..............................................................................................1324．分析..............................................................................................................1325．合并透视表...................................
