培训地址/Training address：上海Shanghai

培训价格/Training quotation： 3980RMB/one person
（含培训费、培训资料费、餐费、茶点.include training cost, paper material, lunch、tea break.）

培训对象Target Group：总经理、人力资源总监、人力资源经理、招聘经理、培训经理、薪酬统计分析主管等。
GM, COO,CFO, HR and Recruiting managers, Finance Manager ,S&B(Salary and Benefit) Manager, T&D(Training and Development) manager etc.

培训收益Training Benefits
让员工只用鼠标就能完成你设计的各类表格，并且不会出错。
Staff can finish the designed reporting sheet easily, fast, and with nil mistakes, efficiency can be highly improved.
快速地分析公司管理结构和工资结构是否平衡合理,
Quickly analyze whether company management structure and payroll structure is reasonable.
方便地制作工资表，并在几分钟内做出各类薪酬统计分析；
Easily work out the payroll sheet, handle various payroll statistics and analysis within minutes.
建立动态的薪酬调整方案，并找到可选范围。
Establish dynamic payroll adjusting module, automatically find out payroll adjustment range.
通过离职人员数据多纬度分析，对员工流失的可能性进行提前防范。
Based on data analysis on left staffs file, set up system to control risk of losing staffs.
通过驱动因素表，直观地建立各部门和岗位目标一致的量化KPI指标体系
Through driving factors sheet, aimed for the same target, establish KPI indicator system for all departments and positions.
知道管理人员和业务员的销售行为模式，哪些是开拓性销售人员，哪些是保守性的销售人员。在公司业务转型和开拓市场时你可以有充分依据建议派遣合适的人员。
Be aware of management and sales person sales style; know who are of the developing style, who are of the conservative style. When the company is changing its business direction or developing new market, you can have sufficient base to decide assigning what type of sales/management person.
知道关键业务员工和有潜力性员工在哪里，可以给于他们更大的关注,并有目的的进行人员搭配。
Be aware of the key staffs and staffs with potential, pay more attention to them, and match different personnel together for different purposes.
通过最优方案工具，让计算机告诉你加班排班的最合适结果.
Through optimization tool, let the PC tell you how to set up the overtime / work shifts schedule.

培训大纲Training Outline
1.EXCEL提高工作效率和质量
Excel enable to improve working efficiency and quality
a)友好界面表格的制作及保护　
User-friendly interface design and protection.
b)数据透视表在海量数据分析中的应用
Application pivot table on mass data analysis.
c)图形展示和在线分析的应用
Application on graphic and online analysis.
2.在人力资源结构分析上的应用
Application on analysis of human resources structure.
a)公司员工结构多纬度分析
Multi-dimension analysis on staff structures
b)离职员工分析和职业周期预测
Analysis on data of left staffs, work out prediction of staff career cycle, the management can prepare accordingly in order to minimize risks
3.在薪资预算和薪酬管理上的应用
Application on Salary and Benefit budget and management.
a)快速描述薪资结构的方法
Approach of quickly describing Salary and Benefit structure
b)年度薪资预算方案模型制定
Making model of annual Salary and Benefit budget
c)自动排班安排方案模型
Automatic shift scheduling model
4.在绩效体系设计和绩效管理上的应用
Application on performance management system design and management
a)员工任职能力匹配分析
Analysis on staff capability matching.
b)绩效评估分析方法
Performance evaluation and analysis approach
c)绩效分布矩阵图
Performance distribution matrix.
5.在业务人员管理上的应用
Application on management of sales persons
a)业务人员行为分析建模
Mathematic Model on analysis of sales persons’ behavior
b)销售业绩趋势分析的方法
Approach on analysis of sales performance trend.
c)业务人员绩效跟踪方法
Approach on Performance tracking of Sales persons

讲师介绍Trainer
杨老师6年海外生活工作经验、5年外企工作经验、15年企业高管管理经验，对制造业、零售、快消、文化产业熟悉；又具有十年各行业丰富的培训经验，授课超过五百天，培训企业过千家。
曾担任澳大利亚 BEVERLY HILLS教会学校中文教师；澳大利亚 Classique Furniture Pty. Ltd. Australia 上海办事处首席代表；宝隆洋行英特尔乳品有限公司行政主管；国内某著名集团企业总裁办公室行政经理；上海国内某著名集团企业集团人力资源总监助理，企业标准化部长；国内某著名集团企业集团文化传播公司常务副总经理；国内某著名集团企业集团乳业股份公司总经理；国内某著名上市集团公司董事等。
85年中国第一批程序开发员,主持实施ERP软件，以顾问式、项目式管理方式，帮任职企业解决众多实际管理问题。