更好的管理你的数据 - EXCEL 数据处理与统计技巧课程 Better Manage Your Data - Excel Data Analysis Skill Training [Training School]

  • When:
    Thursday, 07 June 2018, 9:00am - 4:15pm
  • Where:
    Venue to be released soon, .
    .
    .
  • Price:
    Member Price: ONE training credit plus RMB 2,200, or RMB 3,000. Non-member Price: RMB 3,800

Online registration for this event is not available.

RSVP: Nathalie.Xu@britishchambershanghai.org (Click here to learn more about the Training Credits)

培训语言 | Training Language: 中文 Chinese

本课程适合有需要系统提升 Excel 使用水平,提高数据处理效率的 Excel 用户(中高级水平培训)。请自备安装Office 2013以上的笔记本电脑。

面对海量的工作数据和繁复的重复工作,我们需要掌握什么样的方法和技巧才能轻松驾驭Excel制作报表?答案将在本次培训课程中得到揭晓。从数据的查找、整理到商务报表的快速制作,其中有很多的秘诀和技巧可以让我们的工作更轻松、更智能。

通过参加此次培训,学员能够:

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

培训安排

9:00 - 9:15 签到、社交
9:15 - 10:45 数据处理基本流程和注意事项、数据的收集和整理
10:45 - 11:00 茶歇
11:00 - 12:15 数据的快速统计与分析
12:15 - 13:15 午餐
13:15 - 15:45 利用函数进行统计分析和报表制作、数据信息的呈现、Excel 报表的发布准备
15:45 - 16:00 茶歇
16:00 - 16:15 Q&A

This course is suitable for people who regularly use Excel for extensive data management. Attendees please prepare a laptop with at least Office 2013.

Data processing can be a huge task, requiring many people to work overtime to complete it. Faced with a huge amount of data and complicated repetitive work, what skills and methods can we use to master this workload? This course will provide you with the answers you are looking for! From data searching, sorting and making complex business reports, many secrets and skills can be found to make our work easier and more manageable.

Attendees on this course will benefit in the following ways:

  • Master the proposed data source formats in data processing,correct the error habit of establishing the data form.
  • Learn and master the practical function of enhance the efficiency of processing data, and operation skills.
  • Master the tools of fast making report and the popular data analysis function, improve the efficiency of data analysis.
  • Find the suitable data presentation and performance practices, highlighting the information of data, improve the work reports quality.

Agenda for the day:

  • The basic data processing flow and the notice, master the ideal data source formats in data processing, correct the bad habit of establishing the data form.
  • Data collection and sorting, learn and master the practical function to enhance the efficiency of processing data.
  • Analysing data by using Pivot Table.
  • Statistical analysis and report making with Excel functions. Master the tools and functions of data processing, improve the efficiency of data analysis.
  • Preparing your Excel report to present the data information, find the suitable data presentation format, highlighting the information of data, to improve the quality of your report.

excel 2018.jpg

RSVP: Nathalie.Xu@britishchambershanghai.org (Click here to learn more about the Training Credits)

Speaker Introduction

裴胜韬 Pasta Pei

微软 Office 最有价值专家(MVP)、微软认证技术专家(MCP)、易迪思 Office 金牌讲师、微软(中国)内训计划专职讲师

裴老师长期从事企业级Office培训咨询及讲授工作,有培训授课经验六年,且具有丰富的企业级IT技术及高效办公系列课程培训经验。服务对象涉及诸多外资合资企业、政府部门、院校团体,如:微软(中国)有限公司,惠普中国有限公司,施耐德电气有限公司,爱立信中国有限公司,奥美广告有限公司,智威汤逊广告有限公司,中国科学院,中国中铁股份有限公司,中国石化,中国石油,清华大学等等。

Microsoft Most Valuable Professional (MVP), Microsoft Certified Professionals (MCP)
Microsoft Office Professional Trainer, Microsoft Certified Partner for Learning Solution

Mr Pei has more than six years ’extremely rich training experience on corporate IT techniques training and high efficient Office series courses training. Understand the subtleties of customers’ need, also tailor to their requirements on IT system software applications and training solutions to help improve their work efficiency.

Mr Pei has served for many MNCs, GOVs, colleges and universities which include: China Microsoft, China Hewlett-Packard, Schneider Electric (China), Ericsson ,Ogilvy & Mather, J. Walter Thompson China, Chinese Academy of Sciences, China Railway Group Limited and etc. 

Event contact

Nathalie Xu
+862162185022
Nathalie.Xu@britishchambershanghai.org