每逢月底年底,您是否都因为制作工作报告而烦恼?
面对大量的数据,怎么能最快速的整理出有价值的信息?
纷繁的信息和数据怎么才能呈现出最直观的效果?
邮件高效沟通的正确方法是什么?
如何安排、分配、接受企业会议邀请 ?
快来参加我们的课程,体验一瞬间完成数据汇总的急速快感, 尝试3分钟制作PPT的流程,掌握专业高效的邮件沟通方法。有效的培训将大幅提高被培训者的工作效率和质量。
本课程旨在让学员掌握Excel、PPT和OUTLOOK在财务,人事,销售及其他管理工作中的大量应用和高级技巧,在以后的工作中少走弯路,事半功倍。
丰富的实例和课堂练习使学员在1天内迅速提高办公软件使用水平,在日常工作中,将展现令人信服的办事效率,改变自己繁忙的工作状态!
Are you bothered by making work reports at the end of each month?
How can we quickly sort out valuable information when we faced a large amount of data?
How can the complex information and data present the most intuitive effect?
Come to our course, experience the rapidity of data aggregation in, master professional and efficient mail communication methods.
This training will greatly improve the working efficiency and quality of trainees.
This course aims to enable trainees to master advanced skills of Excel and PPT in the financial, human resourse, sales and other management position. Rich examples and classroom exercises enable students to rapidly improve the use of office software within one day. In their daily work, they will improve efficiency and change their working method.
课程对象 Who Should attend
需要进一步提升EXCEL和PPT操作技能的人员
Person who want to further improve EXCEL and PPT operation skills
上午课程 Morning session: Excel
模块一: 智能化应用让工作倍儿轻松
Module 1 Easy work with intelligent application
|
模块二:表单的统计分析技巧
Module 2: Statistical analysis skills in forms
|
- 数据输入与整理技巧
- 文本、数字、日期类型数据的快速输入技巧
- 其他应用程序导入的数据清洗方法
- 将普通表单转换为智能列表
- 让数据范围动态增删改
- 另类的冻结方法
- 简单快捷的二维计算
- 实现前10名排名筛选
- 快速查看变动的数据
- 快速查看有重复的数值
- 用条件格式突出报表的重点
- 清晰查看与标准值比较的结果
- 描述数据的变化趋势
- 用红绿灯监控数据的变化
- Data input and arrangement skills
- Quick input skills (Text, Number and Date Data)
- Data cleaning methods
- Convert plain forms to smart lists
- Add, delete and change the data range
- Alternative freezing methods
- Two-Dimensional computation
- Quick view of changing/duplicated data
- Highlight points in report with conditional format
- Clear view the results compared with standard values
- Describe data trends
- Monitor data changes
|
- 多维表单的快速计算
- 1秒钟快速汇总和对比
- 求和的各种方法(累加、权重、带条件求和)
- 用Vlookup函数实现多张表的关联
- 数据透视表的数据源要求
- 创建透视表的方法
- 告诉你会议现场实时分析的技巧
- 数据透视表的核心统计功能
- 用切片器进行筛选的优势
- 实现对日期型数据分组
- 实现对数值型数据分组
- 查看时间序列分布状况,查看频率分布状况
- 在数据透视表上实现排序的三个技巧
- Fast computing of multidimensional forms
- Quick summary and comparison in 1 second
- Various methods of summation (cumulative, weighted, conditional summation)
- Realize the association of multiple tables with vlookup function
- Data Source Requirements for PivotTable
- Method of creating PivotTable
- Skills of real-time analysis on the conference site
- The Core Statistical Function of PivotTable
- Advantages of slicer
- Date-based/numerical data grouping
- View time series/ frequency distribution and distribution
- Three Skills of Implementing Sorting in PivotTable
|
下午课程 Afternoon session: Ppt
模块三: 图文并茂幻灯片的排版技巧
Module 3: Typographic skills of illustrated and textual Slides
|
- 排版常用的快捷键
- 图片的四种裁切技巧
- 纵横比裁剪:将图片以多种形状呈现
- 矩形裁剪:让图片匹配幻灯片大小
- 抠像:删除图片背景,自然结合画面
- 多图排版:多张图片在一张幻灯片快速排版
- 图示绘制的四个技巧(变化多、生成快、质量好、效果省)
- 文字型图示的创建与设计(转换、更改颜色、添加特效)
- 图文并茂幻灯片的图块化排版
- 母版的设计要领
- 规范各种插入对象的大小、位置、形状
- 制作专业规范的版式
- 保存版式并应用到工作报告
- Commonly used shortcut keys in typesetting
- Four kinds of cutting skills for pictures
- Length-to-aspect ratio clipping: presenting pictures in multiple shapes
- Rectangular clipping: Let the picture match the slide size
- Delete the background of the picture and combine the slide naturally
- Multi-image typesetting: Quick typesetting of multiple images on a slide
- Four skills of graphic drawing (Variable, Fast Generation, Good Quality, Low Effect)
- Creation and Design of Text Graphics (Transform, Change Colors, Add Special Effects)
- Block typesetting of illustrative and textual slides
- Main Points of Master Plate Design
- Making Professional Standard Format
- Save layout and apply it to work reports
|
课程安排 Agenda
08:45-09:00, registration
09:00-12:30, morning session
12:30-13:30, lunch break
13:30-17:00, afternoon session
注意事项:
请于2019年12月3日前报名缴费
缴费可通过银行转账或联系商会工作人员。
付款方式:报名后请将培训费汇款至以下账户,并在银行转账单上附注 BJ20191205
A/C Name: 中国欧盟商会
A/C No.: 7110210182500027543
China CITIC Bank 中信银行京城大厦支行
北京市朝阳区新源南路6号京城大厦
取消政策:
如果您不能参加已注册过的活动,请至少在活动开始72小时之前取消您的注册。若您未能及时地通知我们,我们将收取您相应的活动费用。
您可以联系工作人员取消,也可以网上自行取消。