Master Excel using skills, improve working style, improve working efficiency; Design a pleasing professional data report, through more than three functions nested to solve complex work problems; Create "talking" professional charts and use Pivottables to generate arbitrary reports.
掌握Excel使用技巧,改善工作方式,提高工作效率;设计令人赏心悦目的专业数据报表,通过三个以上的函数嵌套解决复杂工作问题;创建“会说话”的专业图表,通过数据透视表随便所欲生成各种报表。
【课程大纲】
时间
|
主题
|
内容
|
时长
|
09:00-10:40
|
1. 表格根基:高级操作技巧
|
- 分列与快速填充
- 条件格式
- 标记和删除重复值
- 数据一级和二级验证
- 单元格、工作簿和工作簿保护
- 排序和高级筛选
|
90mins
|
10:40-10:50
|
休息
|
10mins
|
10:50-12:00
|
2. 表格灵魂:常用函数解析(上)
|
- 公式与基础函数
- 统计求和家族: Sum/Sumif Sumifs/Count/Countif/Countifs
|
30mins
|
13:00-13:40
|
2. 表格灵魂:常用函数解析(下)
|
- 逻辑查找帮你解难题:
If/Vlookup/Match/Index/ Indirect等
|
40mins
|
13:40-14:50
|
3. 表格利器:透视规划分析
|
- 单表和多表创建透视表
- 自动分组和手动分组
- 切片器联动
- 值汇总方式
- 动态数据透视表
|
70mins
|
14:50-15:00
|
休息
|
10mins
|
|
4. 表格印象:图表演示之道
|
- 各种图表简介
- 图表类型选择建议
- 制作美观专业的图表
- 创意折线图、柱形图和比例图
|
60mins
|
16:00-16:10
|
问答
|
10mins
|
Speaker:Yan Yan, 易迪思中国 金牌讲师
MCT(微软认证讲师),微软金牌合作伙伴讲师,微软Office、Power BI中英双语讲师,微软Office国际大师认证,微软Office PPT国际认证专家,微软Office Excel国际认证专家,微软Office Word国际认证专家(全球Word唯一满分获得者),微软Power BI数据分析认证,微信公众号“Office女神”创办人。
Payment:
Wechat Pay or Bank transfer
RMB Bank Account
A/C Name: 中国欧盟商会
A/C No.: 7110210182500027543
China CITIC Bank 中信银行京城大厦支行
Capital Mansion Sub Branch
No. 6, Xinyuan Nan Road
Chaoyang District, 100004 Beijing
北京市朝阳区新源南路6号京城大厦
S.W.I.F.T. Code: CIBKCNBJ100
2. Online pay through Wechat.
Terms & Conditions:
This event has limited seating and requires registration and payment in advance. No walk-ins accepted.
Cancellation Policy:
If you cannot attend this event, please cancel your registration at least 3-working days before. If you fail to notify us of your cancellation in a timely fashion, you will be charged for the full event costs.
To cancel, please contact Mr Ziguang Yang at zgyang@europeanchamber.com.cn