Member Login         Join Us

Home >> Trainings >>BritCham Training >> Mar 28: Excel - Data Visualisation EXCEL数据可视化
Details

Mar 28: Excel - Data Visualisation EXCEL数据可视化

Excel - Data Visualisation EXCEL数据可视化

1517974842361785.png

Date: Wednesday, 28th March, 2018

Time: 09:00-17:00

Venue: The British Centre, 22/F, Guangzhou International Finance Centre, No. 5 Zhujiang Xi Road, Tianhe District, Guangzhou 广州市天河区珠江西路5号广州国际金融中心22层英国中心

Language: Chinese

Fee: RMB 980 for member / RMB 1,280 for non-member

Learning Objective


In modern enterprises, the demand for data management and analysis is  increasing. EXCEL, as an important OFFICE software tool,  has been applied more and more widely and deeply in people's daily work due to  its powerful data processing function.

在现代企业中涉及数据管理、分析的需求日趋增强,EXCEL做为办公自动化软件OFFICE中的重要成员,凭借其强大的数据处理功能,在人们日常工作中的应用也越来越广泛和深入。


With a large number of practical cases, it explains the problems, common needs  and the short board and blind area of EXCEL related applications in the  workplace. It enables attendees to understand  and master functions and practical skills of EXCEL in an all-round way, which can meet the diverse data processing needs in daily work  and improve employees work efficiency and data processing quality.

本课程模拟人们的工作场景,采用大量的实际案例,对职场人士在应用EXCEL进行数据处理中所面临的问题、常见的使用需求,以及对EXCEL相关应用的短板和盲区进行有针对性的讲解和训练。促使学员全方位的了解及掌握EXCEL的功能及应用技巧,更大的满足日常工作中多样化的数据处理需求,并能极大提升办公效率和数据处理的质量


Content


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

 

• The data collection and sorting

了解EXCEL数据规范性要求,掌握数据整理的快捷方法

 

•  Master the skill of using excel shortcut key combinations

学会EXCEL常用快捷组合键的应用

 

•   Data visualisation and optimisation

了解EXCEL表格的可视性美化方法

 

•   Master the skill to improve data analysis

熟练掌握EXCEL数据统计分析工具

 

•  Learn the method  to build up different data  charts

掌握多种常用数据图表的制作,包括:

1. 利润分析图的制作-瀑布图

2. 任务完成图的制作-双柱图

3. 同比增长表的制作-组合图

4. 项目进度管理-甘特图

5. 多纬度数据展示-迷你图

6. 细化直观展示数据分额-复合饼图

7. 数据排序-条形图

8. 透视图的应用

 

• Master the skill of Excel Pivot table and Pivot chart

熟练掌握利用数据透视 表进行数据汇总及优化

      

Trainer Introduction

1502790624285999.jpg

王文雯- 易迪思金牌讲师

 


- Microsoft Office Specialist Master Instructor

- Senior Microsoft Office Software Expert

- Professional in Human Resources

- More than 5 years of engaging in Office training, consultation and lecture in enterprises

微软MOS大师级认证讲;
微软资深办公件专家;
国家二级人力资源师;
从事企业级Office 培训咨询及授课工作超过5年;
服务对象涉及诸多外资合企业、政府部门院校团体;
具有丰富的企业级Office 系列高效办公课程培训经验。


Registration

Reserve your seat via chris.chen@britchamgd.com or call (020) 8331 5013





Telephone
Feedback
E-MAIL
Contact Us:
020 8331 5013
No content
Word 200(limit 200 Character)
Technical Support: 易橙互联 | Admin Login
×