Viewing posts from: November 2000

[Training] EXCEL 数据处理与统计技巧课程(中文)| Excel Data Analysis Skills (Chinese)

by eggplant in

In Association with

SwissCham Shanghai is delighted to invite you to:

1-Day Training Program:

Better Manage Your Data – Excel Data Analysis Skills
更好的管理你的数据 – EXCEL 数据处理与统计技巧课程

合理的 Excel 数据结构设计
数据的安全和保护方法软件版本为 Office 2010 或 2007

本课程适合有需要系统提升 Excel 使用水平,提高数据处理效率的 Excel 用户(中高级水平 培训)

1. 掌握数据分析中的理想数据源格式,改变建立数据表格的错误习惯
2. 学习并掌握能提升数据处理效率的实用功能并掌握操作技巧
3. 掌握快速进行报表制作的重要工具和常用数据分析函数,提高数据统计分析效率
4. 找到适合自己的数据呈现方式和表现手法,突出数据信息,提高工作报表质量

1 数据处理基本流程和注意事项
1.1 工作中的数据处理流程
1.2 数据处理的必要前提

2 数据的收集和整理
2.1 数据的收集
2.1.1 多种来源导入数据
2.1.2 控制手工输入数据的合规性
2.2 数据的整理
2.2.1 处理不合格的数据格式(数据有效性)
2.2.2 重复数据的处理
2.3 常用数据处理工具
2.3.1 排序的特殊应用
2.3.2 筛选的高级应用

3 数据的快速统计与分析
3.1 利用分类汇总快速统计数据
3.2 灵活运用数据透视表构建报表
3.2.1 数据透视的构建前提
3.2.2 数据透视表的构建方法和技巧
3.2.3 数据透视表的调整和美化

4 利用函数进行统计分析和报表制作
4.1 函数运用的必要准备知识
4.2 常用函数的学习
4.2.2 查找引用函数的学习和应用(VLOOKUP 等)
4.2.3 逻辑函数的学习和应用(IF、AND、OR 等)
4.3 利用函数综合解决实际问题——案例学习
4.4 函数常见错误的排除

5 数据信息的呈现
5.1 专业化的商务图表应用
5.1.1 常用图表类型与制作技巧
5.1.2 图表的布局与美化
5.1.3 图表应用高级技巧
5.2 使用条件格式呈现数据信息
5.2.1 自动套用条件格式
5.2.2 自定义你的条件格式

6 Excel 报表的发布准备
6.1 Excel 报表排版技巧
6.1.1 表内超链接的使用
6.1.2 排版技巧
6.2 电子版本的发布设置
6.2.1 保护报表不被更改
6.2.2 设置允许编辑区域

Prices 价格:

Member: RMB1,500 per person 会员价
Non-Member: RMB 2,000 per person 非会员价
Payment should be done in advance. 培训费用需提前支付
Payment details will be provided upon registration. 付款细节将随报名确认信一起提供

Location 位置

AustCham Shanghai 澳大利亚商会上海办公室
Office 2E, 668 Huai’An Road (near Xi Suzhou Road)

Read more

AustCham Shanghai

by in

AustCham Shanghai 澳大利亚商会上海办公室
Office 2E, 668 Huai’An Road (near Xi Suzhou Road)

Read more

Sino-Swiss Economic Forum 2018

by eggplant in

SwissCham Beijing is delighted to invite you to the Sino-Swiss Economic Forum 2018


Dear Members and Friends of SwissCham,
On the occasion of the official visit to China of the Head of the Federal Department of Economic Affairs, Education and Research, His Excellency Federal Councillor Johann N. Schneider-Ammann, SwissCham Beijing, in association with the Embassy of Switzerland in the People’s Republic of China, is delighted to announce the 5th edition of the Sino-Swiss Economic Forum.

 The Sino-Swiss Economic Forum 2018 (SSEF 2018) will focus on the topic of free trade today and in the future. Four years after the entry into force of the Free Trade Agreement between Switzerland and China (FTA), trade flows between the two countries have been growing robustly and the number of companies making use of the FTA is increasing to reap even more benefits in the future, the two countries have committed themselves to a further enhancement of the FTA on the occasion of Chinese President Xi Jinping’s State visit to Switzerland in January 2017.

The SSEF 2018 builds a platform for high level experts from various disciplines, such as business, economics, politics, architecture, future studies and art. Two panel discussions in the afternoon will focus on the potentials of free trade on specific markets and take a broader look into the future.

We remain at your disposal should you have any questions and are looking forward to seeing you there!

With best regards,

Your SwissCham Team

Co-organized with:



New retail: how technology is revolutionizing tomorrows supply chain and consumer habits
– Life, work and sustainable economies in the Sino-Swiss future

Under the first topic panelists will discuss the chances and risks of the Chinese market for SME’s. The panel will also bring light to the advantage that specific companies gain by making use of latest technologies in retail. After a quick break the second panel discussion will widen the scope and take a look into the future. The focus will lie on the ways of living in the future cities in China and Switzerland and what new markets will develop.

The second part of the SSEF will include speeches on the overall topic of free trade by the President of SwissCham Beijing, His Excellency Federal Councillor Johann N. Schneider-Ammann, a Minister or Vice Minister of the People’s Republic of China and the Head of business delegation. An exclusive gala dinner will close the event.



In 2018, the SSEF will be the most important economic event between Switzerland and China, this year. Sponsoring this event not only gives you the opportunity to associate your company with a very high profile event but also gain access to a community of successful business owners and important players in China.

There are several ways to attend the SSEF 2018:

  • Choose one of our Sponsorship Package;
  • Book a Corporate Table (members only);
  • NEW Purchase a Presentation Booth (SME members only);
  • Individual Entrance.

Financial Sponsorship Packages

Corporate Table
The corporate tables are located in central area with a logo on the table and are for member only. Price (net): RMB 29,900 (MNC) and RMB 19,900 (SME).

NEW Presentation Booth
We offer to our Small and Medium Corporate members the fantastic chance to purchase a booth in order to present your latest products. Price (net): RMB 9’900 including 1 free entry.

Individual Entrance
RMB 990 (member) and RMB 1,490 (non-member).
Due to the limited number of seats, members can register a maximum of 2 entries on a “first come, first serve” policy.




活动流程 (TBA)

14:00 – 14:45 Registration
15:00 – 16:00 Panel Discussion: module I
16:00 – 16:45 Coffee & Tea
17:00 – 18:00 Panel discussion: module II
18:00 – 19:00 Networking Cocktail & canapés
19:15 – 19:45 Speeches
19:45 – 21:30 Gala Dinner



Mr. Olivier Smaga
+86 10 8468 3982 ext. 182
More information about the previous edition in 2016.

Read more

25th Anniversary

by eggplant in

About us

Founded in 1996, the Swiss Chamber of Commerce in China (SwissCham China) is the only Swiss non‐profit and non‐governmental business & trade association officially registered in Mainland China. Our main goal is to gather all actors of the Sino‐Swiss business community on a common platform to strengthen the political and economic bonds between the two countries to stimulate interaction and develop business opportunities. Our close relations with Swiss and Chinese official institutions allow us to have the ability to make your voice heard in regards to your experience in doing business in China. Since its inception, SwissCham China has grown in terms of members and services. The growth accelerated in the last few years and our offices cover Beijing, Shanghai, South China (Guangzhou and Shenzhen) and South West of China (Chengdu and Chongqing).

2021: a Jubilee Year

2021 marks the 25th anniversary of the establishment of SwissCham China, an iconic age.

We also would like to mention a few milestones. In 2007, Switzerland was the first Western country to recognize China as a market economy. Then, the entry into force of the Free Trade Agreement on 1 July 2014 which is a true token of our eminent relations with China, not only in trade, but in various other fields. On 30 September 2015, Federal Councilor Alain Berset and Social Security Minister Yin Weimin signed a social security agreement, following a survey conducted by SwissCham China. 2020 marks the 70th anniversary of the establishment of diplomatic relations between China and Switzerland. In 1950, Switzerland was one of the first Western countries to recognize the newly founded People’s Republic of China. The two countries have enjoyed long-term exchanges and cooperations ever since with remarkable results. Meanwhile, SwissCham China has developed during the last 25 years some unmissable events: The Ambassador’s and Consular Briefings, the Swiss Ball, the Sino‐Swiss Business Awards and of course the Sino‐Swiss Economic Forum.

These meaningful cobblestones undoubtedly map out a route full of opportunities for at least the next 25 years!

About the logo

We are very proud to present you our 25th anniversary logo, created by Ms. Barbara Seidelmann, founder and managing director of 5 Star Plus Retail Design, and her team. This agency provides branded retail and store design, consulting and project management services to high end brands wishing to enter, expand or redefine their presence in the Chinese market.”Key inspirations for the logo design were Chinese and Swiss elements that would be considered “typical” for these two countries – from art and culture, and especially calligraphy. The color scheme is kept simple with some red touches as a reference to the color in the Swiss and Chinese flags,” Barbara said.

25th Anniversary Events

Swiss Traditionnal Dinner

To celebrate our 25th anniversary, on March 26, 2021, at NUO Hotel we hosted the Swiss Traditional Dinner, which followed the RAGA and NAGA.
After the elections, more than 200 guests from the Sino-Swiss business community as well as representatives from the Embassy including Ambassador of Switzerland to the PRC, HE Bernardino Regazzoni, enjoyed the Swiss Traditional Dinner at the NUO Hotel Beijing. We wish to thank all our sponsors, corporate tables and all the attendees, who made the evening a fantastic success!

Sino-Swiss Business Awards
Sino-Swiss Business Awards (SSBA) is organized by the SwissCham Beijing with the support of the Swiss Embassy, with the participation of Swiss and Chinese high rank government representatives. The Awards will showcase individuals and companies who have achieved distinct results and demonstrated the highest level of commitment to the Swiss-Chinese community, Swiss foreign trade and the promotion of Switzerland in China and vice-versa. The highlight of this gala night will be the awards ceremony accompanied by an exclusive dinner. It is a prime opportunity for your business to gain exposure and network with Swiss and Chinese business leaders. The SSBA are open to all Swiss owned companies or organizations operating in Mainland China as well as Chinese companies or organization established or participating to the development of the Sino-Swiss economic relations.

SwissCham Night
The SwissCham Night is the perfect opportunity for our member companies and others to invite colleagues, business partners and friends in order to celebrate together the achieved targets and the end of the year! Meet and mingle with other guests in an informal and relaxed setting around a good meal and international wines. The highlight of the evening is the SwissCham Christmas Lucky Draw with fantastic prizes such as flight tickets, watches, hotel and restaurant coupons and many more. Try your luck and join us for the last event of 2021!

Read more

InterChamber Networking @ Top Bar in Sanlitun

by eggplant in

SwissCham Beijing is delighted to invite you to the InterChamber Networking @ Top Bar in Sanlitun

Dear Members and Friends of SwissCham,
SwissCham Beijing, in collaboration with the French and the Benelux Chambers, would like to welcome you to our Interchamber Networking @ Top Bar in Sanlitun on 26 July 2018You will enjoy the drinks and a selection of cocktails and snacks.
Don’t miss this opportunity to mingle with friends or to meet new people from other chambers and enjoy a fun evening.

With best regards,

Your SwissCham Team

In collaboration with:

The entrance fee includes 2 FREE drinks and a selection of cocktails and snacks.


Salami on garlic crouton with gherkin

Vegetable spring rolls with sweet Thai chili sauce

Bruschetta with olive and tomato


2 free drinks per person (House wine/beer/fruit juice/soda drinks…)
每人2 杯饮品(红酒/啤酒/果汁/苏打……)

More Information

Ms. Cindra WANG
+86 10 8468 3982

RSVP: Please register by 25 July 2018 请在2018年7月25日前报名


In case you need to cancel your attendance to the event, please write an email to
at least 24 hours prior to the event. Failure to cancel your RSVP timely will require the payment of a “no show bill” of the full amount stated in this invitation.  You can reach us as well by telephone:
+86 10 8468 3982


Read more

Your Swiss Business Platform in China

SwissCham China has roughly 600 company members. Our Chamber maintains a strong relationship with the Embassy of Switzerland, Swiss Global Enterprise, Swissnex and Switzerland Tourism. As the representative of the Swiss companies established in China, our goal is to help you to increase your business and visibility, especially amongst the Sino-Swiss business community.

Become A Member

Sign Up For Our Newsletter

  • This field is for validation purposes and should be left unchanged.
March 25, 2021
Published By in Bank / Finance / Insurance
March 22, 2021
Published By in Bank / Finance / Insurance
March 12, 2021
Published By in Engineering / Manufacturing
March 5, 2021
Published By in Engineering / Manufacturing
February 25, 2021
Published By in Bank / Finance / Insurance