Training Objective:

This course teaches students how to use Excel's advanced data analysis features to work with various formula and functions, manage data, create charts, and so forth. It helps participants to have a better understanding and working knowledge about data management and data analysis with Excel.

Target Audience:

· Staff with intermediate knowledge of Excel.

· Staff who would like to improve their skills in data management, statistical analysis, functions and charts.

· Staff at any level concerned.

Course Outline:

- Standardised data lists and data cleansing

- Custom sorting and advanced filtering

- In-depth use of PivotTable and PivotChart

- Consolidation of multiple worksheets

- Data modelling with Scenario Manager and Data Table

- Math functions and calculation under multi-condition

- Text functions to extract, merge or split characters

- Date functions to calculate work days

- Logical functions to construct logical cases

- Lookup functions to search data in various ways

- Functions in conditional formatting

- Functions in data validation

- Chart types and chart design

- Chart advanced (I) Dual-axes charts, progress charts, combo charts, waterfall charts, etc.

- Chart advanced (II) Special charts, e.g., interactive charts

- Excel charts in PowerPoint

Trainer:

The VenusTrain Instructor Team

VenusTrain, established in 1993, is dedicated to providing target-oriented computer training services to many multinational enterprises, such as Siemens, GM, Volkswagen, Dell, Roche, etc.

The instructors of VenusTrain are not only experts in computer technology, but, most importantly, they are also good at communicating and willing to share their knowledge with trainees. They pay close attention to improve trainee's ability of applying computer skills to practical work.

The instructors have benefited many clients and, therefore, they have been popularly recognised and trusted.

Language: CN

Price: RMB 3,000 (excl. 6% VAT) p.p

课程目标：

本课程学习EXCEL数据管理、图表分析和函数综合应用技巧，提高学员EXCEL数据统计和分析的能力。

适合人群：

· 具备EXCEL应用基础；

· 期望在EXCEL数据管理、统计分析、函数应用、图表分析和呈现方面有进一步提高的职业人士；

· 各职位级别均可。

课程大纲：

- 数据表规范和数据整理

- 数据自定义排序和高级筛选

- 数据透视表和数据透视图的深度应用

- 多个表单的数据合并

- 应用模拟运算表和方案管理器建立分析模型

- 数学统计类函数多条件运算和统计

- 文本类函数实现字符的提取,合并与拆分

- 日期类函数计算年龄/工作日/到期日

- 逻辑类函数实现多条件判断

- 查找搜索类函数实现多途径查找

- 函数在条件格式中的应用

- 函数在数据有效性检验中的应用

- 数据图表选型和设计

- 高级图表技术(I)- 双坐标轴图，项目进度图，多类型组合图表，瀑布图等

- 高级图表技术(II)- 动态图表等多种特殊效果图表

- 数据图表在PPT中的呈现技巧

培训讲师：

VenusTrain讲师团队:

VenusTrain创办于1993年，长期致力于为包括西门子、通用、大众、戴尔、罗氏等在内的众多跨国企业提供针对性的培训及咨询服务。VenusTrain的讲师不仅是计算机软件应用技术方面的专家，更重要的是，他们善于沟通，愿意与学员分享他们的知识。他们十分重视提高学员将软件技能应用于实际工作的能力。这些讲师为许多客户带来了利益，受到了广泛的认可。

语言: CN

价格: RMB 3,000 (excl. 6% VAT) p.p