Archive

有了 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

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
Members only

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 欧盟商会上海分会办公室
Members only
6
Jun

In order to adapt to the ever-changing changes, on the basis of summarizing the lessons learned over the years, APOP has decided to revamp and release the third edition of APQP manual in March 2024. After the release of the new version of the manual, enterprises need to adjust and implement the project development process accordingly according to the changes, which is not only the improvement of the project development process of the enterprise, but also the requirements of the IATF16949 standard, and customer-specific requirements CSR) will soon be put forward as soon as possible to the supply side of the implementation of the requirements.

  • 2024-06-06 | 14:00 - 17:00
  • Sunwah International Conference Centre (Sunwah Tianxi Centre) 新华国际会议中心

In order to celebrate Children's Day and to further parent-child interaction, European Chamber Shenyang Chamber is going to hold Aroma Stone Diffuser DIY Activity to friends in and out of member companies.

  • 2024-06-01 | 09:30 - 11:00
  • 新华天玺大厦F座 3层新华创新中心 3rd Floor Xinhua Innovation Centre Block F, Xinhua Tianxi Building

The Annual General Meeting (AGM) of the European Union Chamber of Commerce in China will be held on Thursday 30th May in Beijing, from 16:00-18:00. The AGM will be available for members to join both in person and online.

  • 2024-05-30 | 15:30 - 18:00
  • The Four Seasons Hotel, 3rd Floor, Beijing Ballroom
Members only

The European Chamber Construction and Carbon Market Working Groups are pleased to invite you to join an onsite visit and workshop to the Suzhou High-speed Rail New Town to meet the local authorities, learn how the new town is being planned and engage in knowledge sharing on low-carbon construction and development of the town.

  • 2024-05-28 - 2024-05-28 | 13:30 - 17:00
  • Ziguang building, No.99 Nantiancheng Road, XiangCheng District,Suzhou
Members only
24
May
Shenyang > Seminars

ESG风险治理与合规研讨会

ESG and compliance have become key pillars of corporate development, prompting increasing attention from companies and investors on a company's ESG performance and compliance level. In order to promote further development in the ESG and compliance fields, SGS has specially planned an ESG risk management and compliance seminar, scheduled to take place in Shenyang on May 24, 2024. We cordially invite you to participate in this event.



  • 2024-05-24 | 13:30 - 16:30
  • Sunwah International Conference Centre (Sunwah Tianxi Centre) 新华国际会议中心
23
May

2024 has presented a challenging backdrop of economic slowdown and trade tensions, making it increasingly important for European companies to better engage with internationally influential media to tell their China stories. To tackle this important topic, the Marketing and Communications Forum is delighted to invite seasoned journalists from international media outlets to have a panel discussion. This event will take a practical approach of how communications professionals can effectively connect with media as well as their suggestions to communications professionals in providing news content.

  • 2024-05-23 | 14:00 - 16:00
  • European Chamber Beijing Office and Online (via Teams)
Members only

Business writing is one of the most crucial skills for achieving success in your professional career. Many individuals, ranging from professional writers to new employees, from non-native English speakers to senior executives, use the techniques of business writing to enhance their communication and presentation of ideas. This course will teach you how to apply the principles of effective business writing to your work, improve your writing significantly through simple tools, and master organization, structure, and revision to communicate more proficiently than ever before. Starting with this course, you will be able to immediately apply the newly acquired knowledge to your work and enhance your writing, leaving a professional impression on others.
商务写作是你在职场中取得成功的最重要技能之一。如此多的受训人员,从专业作家到新员工,从 非英语母语人士到经验丰富的高管都使用商务写作中的技术来增强他们沟通和提出想法的能力。本课程将教你如何将良好的商务写作的原则应用于你的工作,如何通过简单的工具来显着改善你的写作,以及如何执行组织,结构和修订,比以往任何时候都更熟练地沟通。从这堂课开始,你能够立即将新学到的知识应用到你的工作中,并改善你的写作,给他人留下职业的印象。

  • 2024-05-22 | 09:00 - 16:00
  • Online training