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

[Background 背景]

With over four decades of foreign-funded enterprises entering China, accompanied by China’s opening-up policy and active promotion of foreign investment, the legal framework applicable to foreign-funded enterprises has been continuously evolving. In order to provide a favorable and equitable business environment for foreign investment, the Foreign Investment Law came into effect in 2020, replacing the three old laws related to foreign investment and marking a new chapter where foreign-funded enterprises are equally subject to the Company Law. To meet the demands of economic development, the Company Law was revised at the end of last year and will come into effect on July 1, 2024. This revision proposes numerous new requirements concerning registered capital system, rights and responsibilities of shareholders, directors, supervisors and senior executives which will undoubtedly bring both new opportunities and challenges for foreign-funded enterprises.
外企入华四十余载,伴随着中国对外开放、积极引入外资的进程,适用于外资企业的法律法规也在不断变迁。为了给予外资优良公平的营商环境,《外商投资法》于2020年开始施行,旧三资法相应废止并归入历史,外资企业翻开了平等适用《公司法》的发展新篇章。为了适应经济发展需求,《公司法》于去年底通过修订并将于2024年7月1日起施行。此次修订对注册资本制度、股东及董监高权责提出了诸多新要求,必将为外资企业带来全新的机遇与挑战。

“Capital” and “Person” have always been the two cornerstones for development of enterprises. Through this presentation, we will summarize the legislative evolution in recent years affecting foreign-funded enterprises, focusing on the impact of the new regulatory framework under Company Law from the perspectives of “Capital” and “Person” which are critical to corporate governance and operations. We will discuss topics such as capital contributions of shareholders, capital increase and decrease, equity transfer procedures, appointment of legal representatives, corporate governance structures, shareholders’ rights and responsibilities, rights and responsibilities of directors, supervisors, and senior executives, as well as risks and safeguards related to their roles.
“资”与“人”,向来是企业发展的两大基石。通过本次分享活动,我们将归纳近年来涉及外资企业的立法演进,重点从关涉公司治理与经营的“资”与“人”之角度探讨新的公司法规制模式对外资企业的影响,对股东出资、公司增资减资、股权转让、法定代表人的选任、公司治理结构、股东权责、董监高权责及任职风险与保障等方面进行探讨。

  • 2024-06-18 | 14:30 - 17:00
  • Bourbon Room, 2F, Goose Island 鹅岛餐厅 二楼波本包间
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) 新华国际会议中心
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) 新华国际会议中心

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

The European Chamber Southwest China Chapter cordially invites you to participate in the oral health seminar "A Better Life, Starting from Teeth" to be held on May 10, 2024 (Friday) at Rytime Dental Hospital in Chongqing. Oral disease is one of the most common but also easily overlooked health issues. Together with the European Chamber, visit Rytime Dental Hospital, listen to seminars from dental experts on adult and child dental health, paid attention to the oral health, and cared for ourselves.
中国欧盟商会西南分会诚邀您参加将于2024年5月10日(星期五)在重庆瑞泰口腔医院举行的“美好生活,从齿开始”口腔健康讲座。口腔疾病是最普遍但也最容易被忽视的健康问题之一,和欧盟商会一起走进瑞泰口腔,聆听口腔专家关于成人以及儿童口腔健康的讲座,关注口腔,关爱自己。

  • 2024-05-10 | 14:30 - 16:30
  • Chongqing Rytime Dental 重庆瑞泰口腔医院

The European Chamber Southwest China Chapter and Bureau Veritas Certification sincerely invite you to participate in the online GSTC-Global Sustainable Tourism Certification Seminar on April 26, 2024 (Friday). With sustainable development becoming a global consensus, more and more travelers hope to reduce their carbon footprint and contribute to environmental protection by choosing sustainable hotels. We hope that this seminar can increase the understanding of GSTC standards among members from different industries and jointly explore future trends in sustainable development.
中国欧盟商会西南分会和必维认证诚邀您参加将于2024年4月26日(星期五)在线上举办的 GSTC全球可持续旅游认证研讨会。随着可持续发展成为全球的共识,越来越多的旅客也希望通过选择可持续酒店来减少自己的碳足迹,为环境保护做出贡献。相信本场研讨会可以让来自不同行业的会员们增加对GSTC标准的了解,共同探讨未来可持续发展的趋势。

  • 2024-04-26 | 14:00 - 16:30
  • Online 线上研讨会

98% people nowadays are generally lack time quotient. The so-called "time quotient" is our attitude towards our own time, the attitude towards the time of others, and the ability to use time to create value. We're often so busy that we're answering messages while we're eating; So busy that there are only three days off in a month; Too busy to rest, exercise and spend time with family... ...Our biggest problem is that we spend 80 percent of our time being "busy."

98%的中国人普遍缺少“时间商”。所谓“时间商”,就是我们对待自己时间的态度,对待别人时间的态度,以及运用时间创造价的能力。我们经常忙到吃饭的时候都在回复各种信息;忙到一个月只有 3 天休息的日子;忙到没有时间休息、锻炼和陪伴家人……我们最大的问题,就是花费了80%的时间放在了一些所谓的“忙”上面。

  • 2024-04-23 | 09:00 - 16:00
  • Online webinar/ 线上培训

Advocating the concept of low carbon and developing a low carbon economy has become a global consensus. China, as a responsible major country in the world, has explicitly proposed the goal of "carbon peak and carbon neutrality" and has formulated clear strategies for this, known as the "Dual Carbon Strategy." Currently, an increasing number of enterprises are setting carbon reduction targets based on the requirements of international organizations for controlling global warming and their own actual situations, promoting low carbon transformation. They aim to establish ambitious emission reduction targets to ensure that their transformation actions are consistent with the level required by climate science. By reducing greenhouse gas emissions, they hope to enhance their ambition for climate action. Green development has become an inevitable requirement for enterprises to achieve long-term development, which also helps to improve their competitive advantage and brand image.
倡导低碳理念、发展低碳经济已经成为世界共识。中国作为世界负责任的大国,明确提出了“碳达峰,碳中和”目标并为此制定了清晰的战略,即“双碳战略”。目前越来越多的企业依据国际组织对地球控温要求及企业的实际情况设立减碳目标,推动低碳转型,希望建立高远的减排目标来确保自身转型行动与气候科学所要求的水平相一致,希望通过减少温室气体排放来提高企业对气候行动的雄心,绿色发展已成为企业实现长远发展的必然要求,更有助于提升企业竞争优势和品牌形象。

To help more enterprises achieve emission reduction targets, formulate scientific carbon reduction plans, and create zero carbon factories, the European Chamber of Commerce in Shenyang and SGS cordially invite you to participate in the seminar focusing on "Dual Carbon" and supporting enterprises on the road to zero carbon, to be held in Shenyang on the afternoon of April 22nd. We will share with you the latest dual carbon policies, energy-saving and carbon reduction pathways, and help enterprises on the road to zero carbon.
为帮助更多企业实现减排目标,制定科学的碳减排,创建零碳工厂,中国欧盟商会沈阳分会及SGS诚邀您参加4月22日下午在沈阳举办的聚焦“双碳”助力企业零碳之路研讨会,与您分享最新双碳政策、节能减碳路径,助力企业零碳之路。

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

Many foreign enterprises are B2B companies that need to develop a large number of enterprise-level clients in China. The customer base of B2B companies is characterized by intense competition, long procurement cycles, complex procurement decisions, and difficulty in exploring potential customers. Therefore, the branding and marketing teams of B2B companies encounter many challenges. This course aims to comprehensively analyze the pain points and characteristics of B2B clients, thereby enhancing the team's understanding of branding and marketing work for B2B companies, learning more management skills to apply in daily work, and improving marketing efficiency.
很多外企是B2B类企业,需要在中国开发大量的企业级客户。B2B企业的客户群体存在竞争大、采购周期长、采购决策复杂、潜客挖掘难等特点。因此B2B企业的品牌及市场部团队的工作会遇到不少难点。本课程旨在全面梳理B2B客户的痛点和特点,从而提高团队对B2B类企业的品牌和市场营销工作的认知,学习更多管理技能,以便运用在日常工作中,提高市场营销的效率。

  • 2024-04-19 | 09:00 - 16:00
  • Online Course - link will be shared prior to the training by email