This is a past event. Registration is closed. View other German Chamber of Commerce in China - North China events.

On August 15, 2018 the German Chamber of Commerce in Shenyang will host an advanced EXCEL Training on the topic "Advanced Data Management & Analysis Reporting" at Wuerth Industrial Park Shenyang.


This full-day EXCEL Data Management training for advanced users will introduce you to the most relevant EXCEL analysis methods for your daily work and teach you the principles and most important tools to create an advanced data worksheet. It can help you to solve complex data management problems and provides solutions to deal with the challenges of data analysis to improve your ability to control and manage your companies data and figures in a more efficient and structured way.


This advanced training course will mainly focus on:


Part 1: Create Intelligent Report Models 第一章:智能报表模型构建

  • How to Create Graphical Reports 图形化报表构建思路
  • Introduction to Data Analysis Methods 数据分析方式与数据分析方法简介
  • Realizing a Reporting Structure 形化报表实现的技术准备
  • How to Create Analysis Index and Modeling 分析指标与分析模型创建

Part 2: Realize Monitoring and Alerting System 第二章: 监控与预警机制实现

  • Create Index Monitoring and Alerting System 指标监控与预警模型的创建思路
  • Case Study for Textual Hint & Graphical Alerting 文字提示性&图形界面化预警案例分析
  • Realize Monitoring and Alerting with EXCEL 报表设计中的监控与预警实现

Part 3: EXCEL-Advanced Data Management 第三章:数据的高级管理

  • EXCEL Data Table Structure Design EXCEL 数据表结构设计
  • VB and Function Application with multiple linked data 数据关联与链接时的VB与函数应用
  • Excel Bulk data analysis of norms and techniques EXCEL 批量数据的分析规范与技巧

Language: Chinese/中文

Fee: German Chamber Member: 200 RMB I Non-Member: 400 RMB

Please note: We recommend you to use your own laptop and IT equipment (mouse, charger ... if needed) during the training, but we´ll provide you with suitable power supply. Microsoft EXCEL Version 2013 or above should be installed !

请您携带自己的笔记本电脑及IT设备(鼠标、充电器等)参与培训,我们将为您提供电源。Microsoft Office 软件建议为2013或以上版本。


Wuerth Industrial Park Shenyang 沈阳伍尔特工业园
No. 119-2 Jianshe Road,SEUZ, Dadong District
Shenyang 110122

ShenyangLiaoning, China

See route

Contact us

For additional event or venue information, please email hu.chaoran@bj.china.ahk.deYou can also reach us at +86 2481113996


In Partnership with

Yearly Sponsors 2018/2019