此课程为中文授课 This training is held in Chinese.
Course Description 课程描述
Excel 数据结构设计
数据的整理和分析技巧(含数据透视和常用函数)
利用图表有效呈现数据
Design of Excel data structure
Data collection and analysis skills(Containing PivotTable and popular function)
Effective presentation data with chart
The method of data security and protection
Course Objective 课程目标
您是否面临这样的挑战:需要掌握更高级的 Excel 应用技巧,以应对一项新的工作任务?
大量的动手实践活动,丰富的实战经验技巧,涵盖多项 Excel 关键技术。
没错!这就是本课程的魅力所在,帮助参与者拓展对 Excel 惯有的认识和了解,更上一层楼。
Beginning a new job that needs advanced Excel skills?
This is an activity-based workshop to cover advanced Excel features and commands for Excel users who wish to deepen their
knowledge of this business application.
Course Outline 课程大纲
单元格格式高级设置
条件格式中常用的函数 COUNTIF, AND, OR
高亮显示重复数据
必备常用函数
时间、日期类函数
逻辑函数
查找函数
统计函数
其他常用函数
构建数字仪表盘报表
报表设计思路与理念
向仪表盘添加微型图表
向仪表盘添加数据有效性
添加常用函数(VLOOKUP, INDEX)
高级函数、公式(数组公式)
排序筛选
含计算公式的条件区域
查找不重复的数值记录
数据透视
添加计算字段、计算项
对数字、日期进行分组
多重数据区域汇总合并
Excel 高级图表
目标求解、方案分析及规划求解
Who Should Attend? 课程受众
本课程适合有需要系统提升 Excel 使用水平,提高数据处理效率的 Excel 用户(中高级水平 培训)
Agenda 课程安排 (具体时间安排)
9:00 - 9:15 签到、社交
9:15 - 10:45 数据处理基本流程和注意事项、数据的收集和整理
10:45 - 11:00 茶歇
11:00 - 12:00 数据的快速统计与分析
12:00 - 13:15 午餐
13:15 - 15:45 利用函数进行统计分析和报表制作、数据信息的呈现、Excel 报表的发布准备
15:45 - 16:00 茶歇
16:00 - 16:15 Q&A
为了确保您的座位,我们鼓励参加课程前在网上注册与网上付款,同时我们支持现场微信,银行卡支付及银行转账,需要转账的学员请发邮件至:sluo@europeanchamber.com.cn 获得具体转账信息。To guarantee your seats, we encourage advance online registration and payment. For bank transfers, please email: sluo@europeanchamber.com.cn to get payment notice.
Terms & Conditions
Trainings have very limited seating so to ensure your attendance we encourage advance online registration and payment. We cannot guarantee entry to anyone not registered in advance.
The training is held in Chinese.
Cancellation Policy
If you cannot attend the training for which you have registered, please cancel your registration no later than one business day prior to the event. If you fail to notify us of your cancellation in a timely fashion, you will be charged for event costs.
To cancel you can: 1) email sluo@europeanchamber.com.cn, or 2) cancel online if you registered for the event through the website.