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

  • When:
    Friday, 25 August 2017, 9:00am - 5:00pm
  • Where:
    TBC, .
  • Price:
    Member Price: RMB 1,400 plus one training credit, or RMB 2,200. Non-member Price: RMB 3,600. Inclusive of lunch, coffee & tea. (This is a pre-paid event.)

Online registration for this event is not available.

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

This is a Chinese language course.

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

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

课程大纲

  • 数据处理基本流程和注意事项
  • 数据的收集和整理
  • 数据的快速统计与分析
  • 利用函数进行统计分析和报表制作
  • 数据信息的呈现
  • Excel 报表的发布准备

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

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

This course is suitable for people who regularly use Excel for extensive data management.

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.

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.

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.

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

Cancellation Policy: Please note that if you need to cancel this booking, we must receive your cancellation by email no less than 48 hours in advance of an event. If we do not receive the cancellation notice by this time, the Chamber will have to charge you the full-price for the event, as this is necessary to cover costs automatically incurred by the Chamber on the registered attendees’ behalf.

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

Joanna Zhang
+86 21 6218 5022
joanna.zhang@britishchambershanghai.org