【 Course Objectives 】
● Master Excel using skills, improve the way of work, improve work efficiency;
● Design a pleasing professional data report, using more than three functions nested to solve complex problems;
● Create professional "talking" charts to generate arbitrary reports from Pivottables.

【课程目标】
·掌握 Excel 使用技巧，改善工作方式，提高工作效率；
·设计令人赏心悦目的专业数据报表，通过三个以上的函数嵌套解决复杂工作问题；
·创建“会说话”的专业图表，通过数据透视表随便所欲生成各种报表。

• 2022-12-20 | 09:00 - 16:10
• Online Training

With the continuous development of economy and society, the quality of products has been highly valued by people. The level of laboratory management plays an extremely important role in product quality control, directly affecting the stability of the company's products, quality improvement and the rapid advancement of new products. It undertakes the important tasks of index control and process research and development. Enterprise laboratory management level and technical ability are challenged by more and more customers, requiring more professional testing reports. In order to meet the challenges, the laboratory should accurately grasp the relevant requirements of ISO/IEC 17025 and establish an effective quality management system according to it. It can not only prove its technical ability to the society and customers, but also realize self-improvement of the laboratory, and constantly improve the detection technology ability, shorten the gap with the authoritative laboratory, to adapt to the new requirements of customers.

随着经济社会的不断发展，产品的质量问题受到了人们的高度重视，而实验室管理水平的高低，对产品质量控制起着极为重要的作用，直接影响着公司产品的稳定性、质量改进以及新产品的快速推进，承担着指标控制和工艺研发的重要任务。企业实验室管理水平和技术能力受到越来越多客户的挑战，要求出具更专业的检测报告。为了应对挑战，实验室应准确地掌握 ISO/IEC 17025相关要求，并按其建立有效的质量管理体系。其不仅可以向社会、客户证明自己的技术能力，而且还可以实现实验室自我改进，并不断提高检测技术能力，缩短与权威实验室差距，适应客户不断提出的新要求。

• 2022-12-19 - 2022-12-21 | 09:00 - 17:00
• Online Training

Direct managers are under the pressure of interlayer, high standard of superiors, non-cooperation of peers, immaturity of subordinates, picky customers... When it comes to the current situation, many people will use the words "busy, tired, bored" to describe it. More importantly, most of the direct managers are not from the management background, and most of them are promoted to the management position from the business or technical backbone.
How to transform technology into management, from individual excellence to team excellence, is the key problem that they need to solve urgently. How to fundamentally change this state, effectively improve the management efficiency of the department, and help managers liberate themselves from "busy, tired and bored"?

In the face of such problems, this course will greatly enhance the understanding of the importance of human resource management of each position; Promote enterprise managers to establish correct and forward-looking HRM concepts; Strengthen the functions of managers in human resource planning, recruitment, staff development, position management, performance management and compensation management; Improve the overall performance of all departments.

直线经理承受着夹层压力，上级的高标准，同级的不配合，下级的不成熟，客户的挑剔……一提到现状，很多人都会用“忙、累、烦”来形容。更重要的是，直接经理大多数非学管理出身，多由业务或技术骨干提拔到管理岗位，“做而优则仕”。

如何让技术转化为管理，从个人优秀影响到团队优秀是他们急需解决的关键问题。如何从根本上改变这种状态，有效提升部门的管理效能，帮助管理者从“忙、累、烦”中解放出来？

面对这种种的问题，本课程，将极大地增进各岗位对人力资源管理重要性的认识；促进企业管理者树立正确的、前瞻性的人力资源管理观念；强化管理者在人力资源规划、招聘、员工发展、岗位管理、绩效管理和薪酬管理等方面的职能；提高各部门的总体绩效。

• 2022-12-14 | 20:00 - 21:00
• Online Webinar

The era of great changes has come, and the development of enterprises poses higher challenges to the self-control, rapid adaptation and innovative development ability of managers. In this unpredictable environment, they can help themselves adapt to new changes quickly, get out of some changes, challenges, difficulties and setbacks quickly, adjust their state and manage pressure efficiently and find the core driving force and core needs to motivate themselves is one of the necessary abilities for managers to cope with this era of change.

大变局时代已经来临，企业的发展对于管理者的自我管控、快速适应以及创新发展能力提出了更高的挑战，在这种变幻莫测的环境下，帮助自己敏捷的适应新变化，帮助自己从某些变化、挑战、困难以及挫败的情境中快速的走出来，调整自己的状态与高效的管理压力，找到自己的核心驱动力、核心需求去激励自己，是管理者应对这个变革时代的必备能力之一。

• 2022-12-13 | 20:00 - 21:00
• Online Webinar

Common problems and misunderstandings of enterprises
·How to relax tolerances scientifically? What are the new tolerance application experiences?
·How to reduce technical disputes and simplify measurement work? So as to reduce the risk of measurement, as well as avoid the occurrence of misacceptance and rejection?
·How to improve the level of research and development, save manufacturing costs, improve the pass rate?
This course is highly practical. Several practical cases (especially classic error cases) are interspersed throughout the training. These cases will guide students to analyze the advantages of GD&T in design, assembly, inspection and application, so that students can understand and learn to apply GD&T.

企业常见问题与误区
·如何科学放宽公差？有哪些新的公差应用经验？
·如何减少技术纠纷，简化测量工作？从而减少测量的风险，以及避免误收和拒收的发生？
·如何提升研发水平，节约制造成本，提升合格率？
本课程实用性很强，将若干实用案例（特别是经典错误案例）穿插在培训中，这些案例将引导学员剖析GD&T 在设计、装配、检测和应用等等方面的优点，让学员理解并学会应用 GD&T。

• 2022-12-12 - 2022-12-13 | 09:00 - 17:00
• Online Training

This training is a 3-day live online training.
The automotive industry quality system standard IATF 16949:2016, developed by the IATF, clearly stipulates that organizations should have qualified internal auditors. This course is specifically designed for organisations implementing IATF 16949:2016 or training for certification purposes. Participants will learn the intent and requirements of IATF 16949:2016, including an introduction to the process approach and its core tools for the automotive industry. Through a precise understanding of the standard requirements, the simulation audit of the application of audit techniques and process methods in the automotive industry, the internal auditors of the organization can master the basic requirements of IATF 16949:2016 and have the ability to plan and complete the internal audit.

本课程为 3 天在线直播课程。
IATF 所制定的汽车行业质量体系标准 IATF 16949:2016 中明确规定，组织应具有有资格的内部审核员。本课程特别为组织推行 IATF 16949:2016 或认证目的培训。学员将学习到 IATF 16949:2016 的意图和要求，包括过程方法及其汽车行业核心工具介绍。通过对标准要求的精准理解，汽车行业审核技巧及过程方法应用的模拟审核，使组织的内审员可以掌握 IATF 16949:2016 基本要求并有能力策划完成内部审核。

• 2022-12-12 - 2022-12-14 | 09:00 - 17:30
• Online webinar

By deeply understanding the content of ISO 13485, this course will deepen the understanding of the specific requirements, risk analysis and evaluation, identification and traceability, feedback system, warning system, advisory notice, etc. related to the safety and effectiveness of medical devices. According to the basic principles of auditing, we can audit the internal quality management system, obtain audit evidence, and conduct a correct and objective audit evaluation of ISO 13485 system from the aspects of meeting the requirements of laws and regulations and maintaining an effective quality management system.

本课程将通过深入了解 ISO 13485 标准内容，加深理解医疗器械所特有的与产品安全性有效性有关的特定要求、风险分析和评估、标识与追溯、反馈系统、警戒系统、忠告性通知等；并能按照审核的基本原则，执行内部质量管理体系审核，获取审核证据，从满足法规要求、保持有效的质量管理体系等方面对 ISO 13485 体系进行正确客观的审核评价。

• 2022-12-12 - 2022-12-14 | 09:00 - 17:00
• Online webinar

The new EU Medical Device Regulation MDR (EU)2017/745, which replaces the previous MDD (93/42/EEC) directive and AIMD (90/385/EEC) directive, entered into force in May 2017 and became mandatory in May 2021. Compared with the current medical device directive, MDR adds many new regulatory requirements, such as the requirement of unique device identification (UDI), the requirement of regularly updating CE technical documents, and the requirement of post-market supervision. The transition period of MDR is very short, and this change is bound to have a significant impact on relevant Chinese medical device enterprises, which requires active response. This course provides guidance for organizations upgrading from MDD to MDR certification to customize and implement an independent CE conversion plan.

新的欧盟医疗器械法规 MDR (EU)2017/745 取代了之前的 MDD（93/42/EEC）指令和 AIMD（90/385/EEC）指令，已于 2017 年 5 月生效，并于 2021 年 5 月强制实施。相比现行医疗器械指令而言，MDR 增加了很多新的法规要求，比如：唯一器械标识（UDI）的要求、定期更新 CE 技术文件的要求、上市后市场监督的要求等。MDR 过渡期时间很短，此次变更势必对相关中国医疗器械企业造成重大影响，需要积极应对。此课程为 MDD 升级到 MDR 认证的企业提供指导，定制一套独立的 CE 转换计划并有效实施。

• 2022-12-12 - 2022-12-15 | 09:00 - 17:00
• Online Training

At present, the downward pressure on the economy is huge, operating costs are constantly increasing, orders are changing to small batches and multiple varieties, market competition is becoming more and more fierce, product iteration is accelerating, and uncertain factors in the external environment are increasing... What is the panacea to help Toyota maintain such prosperity The vitality of the world has created the myth of immortality that attracts the attention of the world? The answer is the Toyota lean management model.

当下，经济下行压力巨大，运营成本不断提升，订单向小批量多品种转变且市场竞争越演越烈，产品迭代加快，外部环境的不确定因素不断增多……是什么灵丹妙药帮助丰田汽车保持如此旺盛的生命力，创造了令世人瞩目的不老神话呢？ 答案是丰田精益管理模式。

• 2022-12-12 - 2022-12-15 | 13:00 - 16:30
• Online webinar

European Union Chamber of Commerce in China Shenyang Chapter in cooperation with AmCham China warmly welcomes you to join this year’s Christmas Market at Star Mall. We focus on families especially! 中国欧盟商会沈阳分会联合中国美国商会联合诚邀您加入今年在星摩尔购物中心的圣诞集市活动！我们的圣诞集市着重于家庭！

• 2022-12-10 | 10:00 - 20:00
• Star Mall Shenyang Plaza(People Square)