1. Sales data handling by Excel * How to input and format data effectively * Using general functions * The keys of sales data handling
2. Efficient Excel data management * Using database concept to manage sales data sheets * Sales data arranging, sorting, filtering, finding, matching and subtotaling * Collaboration with other people, sharing data in sales data management * Different styles of sales data management
3. Powerful Excel sales data analysis * Analyzing and matching different sheets, columns, rows * Using pivot tables to analyze data * Using solver tools to analyze decision * The sales data analysis tools
4. Presenting the accurate result * Using pivot tables to create personalized dynamic diagrams * Using different data sheets to create practical charts * Visiting external data to make work reports * Sample of sales report
你实际购买的价格
付款时最多可用622淘币抵扣622元现金
购买成功后，系统会给用户帐号返回的现金券
课程介绍 评价详情(0)
培训受众:
* 销售部助理
* 销售经理
* 其他销售相关人员
课程收益:
通过掌握Excel在数据分析方面的高级功能和技巧，您将大幅度提高分析销售数据的的能力。
课程大纲
* 快速、准确、规范的输入数据，并格式化
* 常用函数、公式应用
* 销售数据处理要点
2.高效的Excel销售数据管理
* 用数据库理念对销售数据表单进行管理
* 对销售数据整理、排序、筛选、查找、匹配、分类汇总
* 销售数据管理中的多人协同工作、共享数据
* 销售数据管理风格
3.强大的Excel销售数据分析
* 对不同数据表、不同行列进行对比、交叉分析
* 利用数据透视表（图）进行数据汇总分析
* 利用规划求解工具进行决策分析
* 销售的数据分析工具
4.完美呈现销售数据分析结果
* 利用数据透视表（图）快速创建个性化的动态图表
* 利用各种数据表绘制动态实用图表
* 访问外部数据源制作工作报告
* 销售工作报告样例
1. Sales data handling by Excel
* How to input and format data effectively
* Using general functions
* The keys of sales data handling
2. Efficient Excel data management
* Using database concept to manage sales data sheets
* Sales data arranging, sorting, filtering, finding, matching and subtotaling
* Collaboration with other people, sharing data in sales data management
* Different styles of sales data management
3. Powerful Excel sales data analysis
* Analyzing and matching different sheets, columns, rows
* Using pivot tables to analyze data
* Using solver tools to analyze decision
* The sales data analysis tools
4. Presenting the accurate result
* Using pivot tables to create personalized dynamic diagrams
* Using different data sheets to create practical charts
* Visiting external data to make work reports
* Sample of sales report
本课程名称： 全面分析销售数据—Excel超级实践
查看更多：销售管理公开课