Main Content 主要内容
The method of making data report quickly Excel 数据报表快速制作
Skills and tips in slide making PPT 内容加工整理技巧
PPT typesetting and designing rules and tools PPT 排版设计方法和工具
Software version required:Office 2010 or 2007 软件版本为 Office 2010 或 2007
Audience 课程受众
Fit to the people who often make data report and show it in PowerPoint. Need a mid-high level using skill. We will share more report designing ideas and advanced skills with you.
在工作中需要利用 Excel 处理数据并利用 PPT 制作工作报告/总结,对于 Office 办公软件使 用熟练,希望在使用思路和高级技巧方面进一步提升的企业办公人员。
Course Objective 课程目标
1. Learn about how to make the growth analysis, Profit analysis, mission completion analysis report by Excel.
2. Master the skill of Excel Pivot table and Pivot chart.
3. Learn how to use chart and graphic instead of word and data and make it more clearly and intuitive.
4. Master the PPT typesetting rules and skills. Make a better slide than ever before.
1. 了解工作中常见的业绩增长分析、利润分析、任务完成图等汇报表格、图表的构建方法。
2. 熟练掌握利用数据透视进行数据分析和报表制作的方法和技巧
3. 学习利用图示化的方法让 PPT 更清晰直观。
4. 熟练应用排版守则对 PPT 进行排版和美化,制作出整洁美观的工作报告。
Course Agenda 课程大纲
1 The Challenges in our work report
2 Standardization——Using template in PPT
3 Make report quickly——make data report by PivotTable
4 Visualization——making PPT more intuitive
5 Perfect details——the typesetting experience for beginners
6 Show time——Presentation skills
1 工作报告的挑战和问题
2 以标准化开头——工作幻灯片的风格快速统一
3 急速体验数据分析——制作 PPT 需要的数据和报表
4 信息至上——让报告更加直观的技巧
5 成败细节——非专业设计人员的 PPT 排版技巧
6 完美展示——工作报告演示技巧
Agenda (培训者请一定带电脑来参加)
8:45 - 9:00 Registration
9:00 - 12:00 Morning Session
12:00 - 13:00 Lunch
13:00 - 16:00 Afternoon Session
About the Trainer
薛峥 Xue Zheng
- Tsinghua University special trainer for MBA - 4 years Microsoft Most Valuable Professional (MVP) - Microsoft Certified Professional (MCP)
As a long-term Microsoft corporate trainer, Mr. Xue is engaged in providing professional MS Office training to large state-owned and foreign-funded enterprises.
He currently teaches Microsoft courses for Eddic, whose clients consistently provide excellent reviews of his teaching skills. He has earned the Microsoft Certified Trainer certification, MCSE, MCDBA, MCP, and MCT.
·Office金牌讲师
·清华大学MBA班特邀培训师
·连续4年微软Office最有价值专家(MVP)
·微软认证技术专家(MCP)
长期担任企业员工培训Office课程讲师,服务客户设计各个行业众多大型国有、外资企业,积累丰富的企业办公自动化培训经验。如:微软中国、 奥美广告公司、思科系统、国务院新闻办公室、中国电信、中央电视台、清华大学等;擅长根据企业客户需求订制Office办公效率培训解决方案,帮助客户员工提高工作效率。
教学讲解生动、贴切,课堂气氛轻松,活跃。授课条理清晰,深入浅出。善于调动学员学习积极性,利用实战案例引导学员独立思考和解决问题,通过实际操作和理论知识的结合巩固培训效果,深受学员好评。