Training
05.16 | [Online Training] The efficient use of Excel in the enterprise | Excel在企业中的高效应用
Event language(s)
This training is conducted in Chinese. 本次课程用中文授课。
The efficient use of Excel in the enterprise | Excel在企业中的高效应用
课程目标 Course Objectives
• 掌握Excel使用技巧,改善工作方式,提高工作效率 | Let the trainees master excel skills, and improve the way of working and increase work efficiency
• 设计令人赏心悦目的专业数据报表,通过三个以上的函数嵌套解决复杂工作问题 | Help trainees design pleasing professional data reports and solve complex work problems through nesting of more than three functions
• 创建“会说话”的专业图表,通过数据透视表随便所欲生成各种报表 | Create vivid and talkative professional charts and generate any kind of reports you want from pivot tables
课程大纲 Course Outline
I. 操作技巧 | Operation skills
- 条件格式 | Condition format
- 分列与快速填充 | Columns and fast filling
- 数据验证 | Data validation
- 数据保护 | Data protection
II. 函数公式 | Function formulas
- 基础统计函数 | Basic statistical functions
- 逻辑判断函数 | Logical judgment function
- 查找函数 | Find function
- 优等生的其他解法 | Alternative solutions for the top trainees
- 其它必备函数 | Other necessary functions
III. 数据透视表 | Form Soul: Analysis of Common Functions (Part 2)
- 快速统计|Quick statistics
- 进阶应用 | Advanced applications
IV. 专业图标制作与美化 | Professional chart production and beautification
- 专业图表指南 | Professional Chart Guide
- 动态图表制作 | Dynamic charting
Agenda 课程安排
Date: Tuesday, May 16th | 5月16日,周二
Time: 09:00 am - 04:00 pm
Language: Chinese
授课语言:中文
Trainer 讲师
Grace YAN 晏艳
微软Office国际认证大师
曾任全球前10强外企培训师
知名世界500强外企从业经历
多家世界500强企业Office授课经验
中英双语讲师
线下受众学员10000人以上
Microsoft Office International Certified Master
Trainer working experience for the top 10 foreign companies
Working experience of the world's top 500 companies
Training experience of the world's top 500 companies
Bilingual lecturer
More than 10000 in-house trainees
Registration 课程报名
Please scan the below QR code to compelete your registration | 请扫描下方二维码报名
The connecting processes will be sent by email after registration | 报名成功后会发送网课登录信息到邮箱。
05.16 | [Online Training] The efficient use of Excel in the enterprise | Excel在企业中的高效应用
Event ended.