This roundtable discussion aims to provide an opportunity and open mindset for Tianjin members, especially those who has import/export business to discuss and exchange on the logistics challenges, practices, trends, and possible solutions.

本次圆桌会议旨在为中国欧盟商会天津会员企业，尤其具有进出口业务需求的会员，提供开放平台，讨论目前物流安排面临的挑战，实践，趋势以及可能的解决方案。

• 2024-06-13 | 13:45 - 16:00
• European Chamber Tianjin Office

An exclusive offline seminar for members on the interpretation of the cross-border data transfer (CBDT) policies and its implementation guidance. Speaker is the Chief Engineer of Shanghai CAC.

• 2024-06-17 | 09:00 - 11:30
• European Chamber Shanghai office 欧盟商会上海分会办公室

Factory Visit - A Tour to Hörmann Tianjin Door Production Co., Ltd. 工厂参观 - 霍曼（天津）门业有限公司

• 2024-06-18 | 14:00 - 16:05
• Hörmann (Tianjin) Door Production Co.,Ltd.

This event is co-organized by the European Union Chamber of Commerce in China and the Sino-German Energy Partnership of the Deutsche Gesellschaft für Internationale Zusammenarbeit (GIZ), acting on behalf of the German Ministry for Economic Affairs and Climate Action and the Chinese National Development and Reform Commission and National Energy Administration.

• 2024-06-18 | 15:00 - 17:30
• Beijing Yuyang Hotel and Zoom

有了 Power 插件，EXCEL 开启自动化时代面对海量数据，如何快速提炼、合并表单？如何整理成规范智能的工作表？如何迅速建立灵活的分析环境，找到问题和关键原因，找到破解问题的方法？如何讲操作过程自动化？如何轻松完成复杂解题过程？单凭 EXCEL 常规用法显得力不从心，高版本的 EXCEL 提供 Power 智能插件，让我们走进数据自动化办公时代，工作变得轻松又高效。Excel Query 插件，提高 10 倍效率的整理法数据整理虽然不能带来多高的价值，但会用 PQ 智能工具能节省出 80%的整理时间。如果可以将繁冗的数据整理工作搭建成一套智能的数据模型，数据的增删改都可以在其中自动化运转，这不次于亲手组装一条自动化的生产线。这就是我们一直寻找的提升 10 倍效率的工作法。Excel AI 插件，提升函数的解题能力在 365 版本中新增加的 AI 函数是个亮点，自动化支持数据增删改，减少重复工作，智能识别数据范围，加速计算运行，在课上我们可以一起感受这些函数的强大之处。
Faced with massive amounts of data, how can you quickly extract and merge sheets? How can you organize them into standardized, intelligent worksheets? How can you swiftly establish a flexible analysis environment to identify issues and key causes, and find solutions? How can you automate the operational process and easily complete complex problem-solving tasks? Conventional Excel usage falls short in these areas. However, with the Power intelligent add-ins provided by the latest versions of Excel, we enter an era of automated data management, making work easier and more efficient.Although data organization itself may not add significant value, using the Power Query (PQ) intelligent tool can save up to 80% of the time spent on data organization. By creating an intelligent data model, where data additions, deletions, and modifications can be automated, it’s akin to assembling an automated production line. This is the 10x efficiency improvement method we’ve been looking for.A highlight of the 365 version is the newly added AI functions. These functions support automated data additions, deletions, and modifications, reducing repetitive tasks, intelligently recognizing data ranges, and accelerating computational processes. During the course, we will experience the powerful features of these functions together.

• 2024-06-19 | 09:00 - 16:00
• Online Training

[A 2-DAY Offline Training] Human Resource Cost Control and Organization Human Efficiency Improvement [2天线下培训] 人力成本管控与组织人效提升

• 2024-06-19 - 2024-06-20 | 09:00 - 16:30
• 5/F, No.3 Meeting Room, Atour S Hotel Beijing Dongzhimen

数据时代人力资源的工作已经不能单靠 HR 的直觉来做决定了，日新月异的数字时代，多元化的员工结构，人力资源各模块大量的基础数据，人力资源从业者需要从传统的人力资源工作思维向数字化思维转型，数据驱动业务，提升人力资源工作运营效率。现在大部分的 HR 缺乏人力资源数据分析的能力，对数据分析的认识也停留在 EXCEL 做图表的阶段，在数据分析的技能上也仅仅是 EXCEL 的简单的报表处理和基础的图表设计，在数据分析层面仅停留在基础的数据记录和描述层面，并不能结合公司的业务和战略对数据进行分析。

In the era of data, HR work can no longer rely solely on the intuition of HR professionals. The rapidly changing digital age, coupled with a diverse employee structure and the vast amount of fundamental data in various HR modules, necessitates that HR practitioners transition from traditional HR thinking to digital thinking. This transition is driven by data, aimed at enhancing the operational efficiency of HR work.

Currently, most HR professionals lack the ability to analyze HR data and their understanding of data analysis remains at the stage of creating charts in Excel. Their data analysis skills are limited to simple report processing and basic chart design in Excel. At the data analysis level, they only perform basic data recording and description, without being able to analyze the data in conjunction with the company's business and strategic objectives.

• 2024-06-20 | 09:00 - 16:00
• Online Training

The fifth episode of the Interpreting the EU's Toolbox series will focus on EU's Corporate Sustainability Due Diligence Directive (CSDDD), which was given a green light by both the European Parliament and the Council of the EU in April and May 2024 respectively. On Thursday 20th June at 15:30, representatives of DG JUST at the European Commission will provide an online overview of the CSDDD, which will be followed by a presentation by Herbert Smith Freehills Partner Antony Crockett on how to approach compliance with this regulation in China.

• 2024-06-20 | 15:30 - 17:00
• Online

Supply Chain Training - PowerBI Desktop: Skill Application Intensive Learning 供应链相关PowerBI课程：Power BI 技能应用精讲 (Chinese Language 中文授课)

• 2024-06-21 | 09:00 - 17:00
• The Big Meeting Room

Sport knows no borders in partnership with Roicare Hospital & Clinics and the Australian Consulate General in Shenyang embark on this journey where China meets Europe and Australia.
体育无国界，中国欧盟商会与安联医院及澳大利亚驻沈阳总领事馆合作，开启中国与欧洲和澳大利亚的交流之旅。

• 2024-06-22 | 09:00 - 11:00
• Banana Camp Inside the Horse Range/沈水湾公园香蕉营地 新领地马场内