excel表格制作技巧

,单击此处编辑母版标题样式,单击此处编辑母版文本样式,第二级,第三级,第四级,第五级,2013/3/25,#,Excel,表基本公式与图表制作,Excel,表格的制作及常用基本公式,Excel,基本图表制作,Excel,表格制作及基本公式的应用,排名,新地区,工作职位,姓名,完成率,增长量,人均月均增量,同比人均月均增长量,/BU,人均月均增长量,代表完成率,/,大区完成率,参数和,1,BUN,浙江二区,销售代表,杜泽,124%,1605,134,0.18,1.24,1.42,2,BUN,浙三,江西,销售代表,陈英雪,120%,1275,106,0.14,1.21,1.35,3,BUN,浙江二区,销售代表,叶滨滨,129%,290,24,0.03,1.30,1.33,4,BUN,浙江一区,销售代表,严海虹,111%,1662,139,0.18,1.12,1.30,5,BUN,浙三,江西,销售代表,徐晔佳,107%,550,46,0.06,1.07,1.13,6,BUN,浙三,江西,销售代表,刘爱民,103%,841,70,0.09,1.04,1.13,7,BUN,浙江一区,销售代表,徐丽萍,104%,608,51,0.07,1.05,1.11,8,BUN,浙江二区,销售代表,陈小高,105%,410,34,0.05,1.05,1.10,9,BUN,浙三,江西,销售代表,张力,99%,844,70,0.09,1.00,1.09,10,BUN,浙江一区,销售代表,蒋夺伟,98%,511,43,0.06,0.99,1.05,11,BUN,浙江二区,销售代表,秦丽娜,101%,175,15,0.02,1.02,1.04,12,BUN,浙江二区,销售代表,潘家园,102%,45,4,0.00,1.03,1.03,13,BUN,浙三,江西,销售代表,李蒙,95%,418,35,0.05,0.95,1.00,14,BUN,浙江二区,销售代表,周伶娅,95%,264,22,0.03,0.95,0.98,15,BUN,浙江一区,销售代表,王圆,91%,15,1,0.00,0.92,0.92,16,BUN,浙江二区,销售代表,吴敏勇,86%,360,30,0.04,0.86,0.90,17,BUN,浙江一区,销售代表,凌昳,81%,-360,-30,-0.04,0.82,0.78,18,BUN,浙江二区,销售代表,柴永伦,68%,-599,-50,-0.07,0.69,0.62,基本计算公式,1,、完成率计算,2,、增长率计算,3,、增长量计算,4,、月均量计算,5,、参数计算,范本,.xlsx,Excel,常用“工具”,1,、单元格的“秘密”,2,、冻结单元格,3,、排序、筛选,4,、“行”与“例”的隐藏,5,、批注的使用,范本,.xlsx,1,、折线图,2,、饼图,Excel,基本图表制作,3,、柱形图,4,、组合图,