Efficient Application of Excel for Businesses (Chinese Language Event)
We will subsequently give two more training sessions on Microsoft PowerPoint and Power BI at a later date, touching on the following topics: PowerPoint Logic and Making Presentations, and Power BI Business Data Analysis.
英中贸易协会诚挚邀请您参加 "Excel在企业中的高效应用"在线培训会。本课程旨在掌握Excel使用技巧,改善工作方式,提高工作效率;设计令人赏心悦目的专业数据报表,通过三个以上的函数嵌套解决复杂工作问题;创建“会说话”的专业图表,通过数据透视表随便所欲生成各种报表。除此之外,我们还有另外两场关于PPT和Power BI的培训会相继展开。主题分别是PPT深度逻辑与制作演示和Power BI商业数据分析。
日期:2022年6月29日 星期三
时间:09:00 - 17:00 (中国时间)
语言:中文
注:请参考如下收费标准
收费标准与报名方式
- CBBC会员价:960元/人/场
- 如果注册两场, 1800/人/场
- 如果注册三场,2200/人/场
- 非会员价:1160元/人/场
- 如果注册两场,2000/人/场
- 如果注册三场,2400/人/场
如您对活动感兴趣,请按照格式
“姓名+公司名+报名场数”
发送报名邮件至:
培训安排
9:00 - 10:40
- 表格的根基:高级操作技巧
- 分列与快速填充
- 条件格式
- 标记和删除重复值
- 数据一级和二级验证
- 单元格、工作簿和工作簿保护
10:40 - 10:50
休息
10:50 - 12:00
- 表格灵魂:常用函数解析(上)
- 公式与基础函数
- 统计求和家族: Sum, Sumif, Sumifs, Count, Countif, Countifs
12:00 - 13:00
午餐休息
13:00 - 13:40
- 表格灵魂:常用函数解析(下)
- 逻辑查找帮你解难题: Vlookup,Xlookup, SumProduct, Match, Index等
13:40 - 14:40
- 表格利器:透视规划分析
- 单表和多表创建透视表
- 自动分组和手动分组
- 切片器联动
- 值汇总方式
- 动态数据透视表
14:50-15:00
- 休息
15:00-16:00
- 表格新招:Power Query
- 数据自动处理
- 合并查询
- 追加查询
- 自动合并工作簿
- 自动合并文件夹
- 自动更新分组
- 连接动态数据透视表
16:00-17:00
- 表格印象:图标演示之道
- 各种图表简介
- 图表类型选择建议
- 制作美观专业的图表
- 创意折线图、柱形图和比例图
17:00-17:10
- 答疑环节
讲师简介
晏艳 Grace
晏艳,MCT(微软认证讲师),微软金牌合作伙伴讲师,微软Office、Power BI中英双语讲师,微软Office国际大师认证,微软Office PPT国际认证专家,微软Office Excel国际认证专家,微软Office Word国际认证专家(全球Word唯一满分获得者),微软Power BI数据分析认证,微信公众号“Office女神”创办人。
曾任全球前10强外企内部培训讲师,知名世界500强外企从业经历(戴尔、雪佛龙和保乐力加),多家500强企业微软Office和微软Power BI培训授课经验,长期为客户和学员解决Office和Power BI问题,线下受众学员100,000人以上,课程培训语种——中英双语教学(英语专业八级,听说读写译流利)。
10余年Office软件深度用户,多年500强外企工作经验,能准确挖掘企业培训需求,快速帮助学员提高Office技能;课程结构条例清晰,课程案例吻合工作需要;授课风格生动有趣,善于调动学员积极性,深受学员喜欢和好评。长期为多家客户设计制作工作、发布会等PPT。
Grace, Microsoft Certified Trainer, is also the trainer of Microsoft golden partner. She is certified as Microsoft Certified Office Master, Microsoft Certified Excel / PPT/ Word (Full mark in Word part) and Microsoft Certified Data Analyst Associate. She is also the Founder of WeChat Official Accounts Office Goddess which shares lots of Microsoft Office skills about Word, Excel, PPT, Power BI and others.
As a bilingual trainer, she was the internal trainer of G10 multinational enterprise. Grace has been worked in Dell, Chevron, and Pernod-Ricard. Having rich experience in office training in global 500 companies, she helps to solve office problems for clients and trainees. Until now, more than 10,000 trainees are benefited from Grace’s training.
Grace, with more than 10 years’ experience of Microsoft Office Word/Excel/PPT and Power BI, can meet corporate’s training requirements, and helps students’ office skills quickly. Her professional training is designed in good logic and is delivered in a humor style and being well acclaimed by trainees. She has permanent cooperation with companies for PPT designing and designed PPT for many companies for regular report or public press conference.