Это прошедшее мероприятие. Регистрация закрыта. Посмотреть другие мероприятия организации German Chamber of Commerce in China - North China

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.

德国商会沈阳办公室将于8月15日星期三在沈阳伍尔特工业园举办关于高阶报表设计之一键核算与自动监控的培训。


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.

EXCEL数据管理高阶体验——将会从日常所需的各类分析需求入手,深入揭露数据表单的设计原则与思路,从根本上解决您的数据应用与分析困扰,真正实现随心所欲的掌控您的数据。


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
沈阳市大东区欧盟经济开发区建设路119号

Shenyang, Liaoning, Китай

Посмотреть маршрут

Связаться с нами

Для получения дополнительной информации о мероприятии или адреса мероприятия, пожалуйста, напишите письмо hu.chaoran@bj.china.ahk.de, также Вы можете позвонить нам +86 2481113996

Organizer

In Partnership with

Yearly Sponsors 2018/2019