文章
  • 文章
Search
Home >> Training >>BritCham Training >> Aug 22: Better Manage Your Data - Excel Data Management & Skills (Full Day)
Details

Aug 22: Better Manage Your Data - Excel Data Management & Skills (Full Day)

Britcham Training Series: 

Better Manage Your Data - 

Excel Data Management & Skills  

职场精英必会EXCEL数据处理技巧    

132982_e37d_5.jpg

A Full-Day Workshop in Chinese 全天中文公开课 

22nd August, 9:00-17:00, Guangzhou

Learning Objective

Every day many of us spend hours trawling  through data for analysis purposes or to  find some key information.  This means that  we limit our productivity during office  hours and end up doing more overtime than we  need to.  Faced with huge amounts of data  and a repetitive work cycle, what methods  and skills can we develop to help us master  Excel freeing up time to send on other tasks  and projects? 

很多人都在为了处理工作数据而加班。面对海量的工作数据和繁复的工作,我们需要掌握什么样的方法和技巧才能轻松驾驭Excel制作报表?答案将在本次课程中得到揭晓。

  

Head along to this seminar where we will  learn many skills ranging from data searches  to making rapid reports highlighting the  information needed by others.  This  training is ideal for those who work with Excel on a  daily basis and would like to improve their  efficiency. 

从数据的查找、整理到商务报表的快速制作,其中有很多很多的秘密和技巧可以让我们的工作更轻松、更智能。本课程适合有需要系统提升Excel使用水平,提高数据处理效率的Excel用户。 


Content


What will this course include? 我们将在课堂中学习:

 

•   Data Management and Preprocessing Skills (40 min)

      数据整理及预处理技巧 (40分钟)

 

•   Data Security Control (30 min)

     数据安全性控制(30分钟)

 

•   Basic Data Editing Tools (50 min)

     数据统计基础工具应用 (50分钟)

 

•   EXCEL Charts (90 min)

     EXCEL 数据可视化图表 (90分钟)

 

•   PivotTables (60 min)

     数据分析利器-透视表(60分钟)

 

•   EXCEL Functions (90 min)

     EXCEL 中不可不学的函数(90分钟)

 

This course will help  you to 本次课程将着重于:

 

•   Master all formats of data processing and correct old, inefficient  data input processes.
     掌握数据分析中的理想数据源格式,改变建立数据表格的错误习惯。
 

•   Master practical functions and enhance operation skills.
     学习并掌握能提升数据处理效率的实用功能并掌握操作技巧。
 

•   Master tools to assist with fast report making. Learn skills to  analysize data at a glance. 
     掌握快速进行报表制作的重要工具和常用数据分析函数,提高数据统计分析效率。析效率。
 

•   Improve presentations containing high levels of data to make sure  your audience receives key  information easily.

     找到适合自己的数据呈现方式和表现手法,突出数据信息,提高工作报表质量。
 

What will you  acquire?   实用的课程将让你掌握:

 

   •  Designs of Excel data structures    

       合理的Excel数据结构设计

   •  Methods to protect and secure data   

       数据的安全和保护方法

   •  Manage commonly functions    

       常用函数的使用

   •  Effective presentation data with  charts   

       利用图表有效呈现数据

   •  Master the skill of Excel Pivot table and Pivot chart   

       熟练掌握利用数 据透视进行数据分析和报表制作的方法和技巧


Speaker


王文雯- 易迪思金牌讲师  

微软MOS大师级认证讲; 

微软资深办公件专家; 

国家二级人力资源师; 

从事企业级Office 培训咨询及授课工作超过5年; 

服务对象涉及诸多外资合企业、政府部门院校团体; 

具有丰富的企业级Office 系列高效办公课程培训经验。

Reserve your seat via chris.chen@britchamgd.com

or call (020) 8331 5013


Programme

Date:  Thursday, 22nd August, 2019

Time:  9:00-17:00

Language:  Chinese

Price:  RMB 1,000 for Members / RMB 1,300 for Non-members

Facility: Attendee needs to bring their own laptop with Office 2010 or  2013 in Windows system.

Address:  The British Centre, 22/F, Guangzhou International Finance  Centre, No. 5 Zhujiang Xi Road, Tianhe District, Guangzhou

广州市天河区珠江西路5号广州国际金融中心22层英国中心


About  the chamber  |  Events   | Member  News  | Join  us   Contact  us

Your Business Link between the UK and South China.





Telephone
Feedback
E-MAIL
Contact Us:
020 8331 5013
No content
Word 200(limit 200 Character)
Technical Support: 本站由 “炎汉建站” 提供搭建 | Admin Login