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

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) 新华国际会议中心

Easily create PPT professional presentations, quickly produce working presentations that meet the requirements of the company, make the presentations more exciting through pictures, shapes, colors, etc., master the most practical cover and catalog design, improve the level of presentation production.

轻松创建 PPT 专业性演示文稿,快速制作出符合公司要求的工作型演示文稿,通过图片、形状、颜色搭配等让演示文稿更精彩,掌握最实用的封面、目录设计,提升演示文稿制作水平。

  • 2024-04-16 | 09:00 - 16:00
  • Online Training

For promoting the exchanges and cooperation between China and Germany in low-carbon technologies, the WBA ,German Chamber of Commerce in China - North China and European Chamber Shenyang Chapter will hold the "China-Germany Carbon Neutral Bioenergy Technology Innovation Seminar" in Shenyang on April 10th, 2024.

为了促进中德双方在低碳技术领域的交流与合作,中国德国商会华北及东北地区沈阳办公室和中国欧盟商会沈阳分会携手国际生物能源协会于2024年4月10日在沈阳举办 "中德零碳生物质能技术创新研讨会"。

  • 2024-04-10 | 13:30 - 17:00
  • Hilton Hotel Shenyang, 3rd floor, Function Room 5, Shenyang 沈阳世茂希尔顿酒店 三层多功能五厅
Members only

The leadership pipeline theory originates from GE and has been successfully implemented in over a hundred Fortune 500 companies worldwide. This experiential course is based on the classic leadership pipeline theory, which explores the value creation points of different management roles within organizations. It utilizes an innovative course design methodology to systematically introduce how to achieve the transformation of managers from knowledge to action at various levels. Through a "unity of knowledge and action" learning journey, the transformation of managers is reflected in daily work scenarios, ensuring that classroom learning can be implemented and behavioral changes can be tracked.
领导梯队理论源于 GE,已在世界五百强企业中的一百多家得到推广与成功实践。本体验课基于经典的领导梯队理论,洞察组织中不同管理角色的价值创造点,并运用独创的课程设计方法论,系统化介绍如何实现各层级管理者由知到行的转变。并通过”知行合一“的学习旅程,让管理者的转变体现在日常工作场景中,让课堂学习可落地、行为转变可追踪。

  • 2024-04-02 | 09:00 - 12:00
  • Online Training

With the rise of the Internet and artificial intelligence, the world is exhibiting the most prominent characteristics of "networking, digitization, transparency, integration, and efficiency." Therefore, whether we are willing or not, the era of "big collaboration" has unfolded. This is a broad and profound transformation that not only affects every industry and every enterprise but also impacts each of us as individuals. The collaborative capability of organizations is more important than ever in maintaining and demonstrating sustained competitive advantages for businesses.This workshop differs from traditional training; its theoretical framework is not only derived from academic research but also distilled from over twenty years of practical experience and has been validated by nearly 2500 companies. Through the breakthrough format of workshops and the experiential learning of practical sandplay, participants fundamentally change their perception of organizational collaboration, identify reasons for ineffective collaboration, and build a culture of collaboration.
随着互联网、人工智能的兴起,整个世界表现出最明显的 “网络化、数据化、透明化、紧密化、高效化” 特征。因此,不管我们是否愿意,一个“大协同时代”已经展开。这是一个广泛、深刻的变革,其不仅影响到每一个行业、每一个企业,也影响到我们每一个个体。组织的协同能力比以往任何时候都更能体现和保持企业的持续竞争优势。本工作坊不同于传统的培训,工作坊的理论框架不只是来源于学术研究,而是来源于二十多年的实战提炼,并得到了近 2500 家企业的验证,工作坊形式的突破,实战沙盘的体验让学员,从根源上改变对组织协同的看法,找到协同不力的原因,构建协同的文化。

  • 2024-04-02 | 14:00 - 17:00
  • Online Training