Member Login         Join Us

HOME >> Trainings >>BritCham Training >> Nov 23: Effectively Data Report Design - Excel Pivot Table Training 快速搞定自动化报表设计
Details

Nov 23: Effectively Data Report Design - Excel Pivot Table Training 快速搞定自动化报表设计

Date:Thursday, 23rd  November 2017


Time: 9:00-12:30


Venue:

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

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


Fee: RMB 650 for Member / RMB 900 for Non-Member


RSVP: email britchamteam@britchamgd.com or call (020) 8331 5013


Learning Objective


Did you mad at making work report at the end of each month or year? How can we rapid making our report within large amount of data? How to present such diverse information and data in the most intuitive way? And for the god sake, who can end the endless overtime?

每逢月底年底的工作汇报,您是否都因为制作工作报告而烦恼?面对大量的数据,怎么能最快速的整理出需要的报表?纷繁的信息和数据怎么才能呈现出最直观的效果?无休止的加班何时才能结束?


Come and join our course, you will find making report can be so easy that you have never thought. Experience the rapid pleasure of completes the data report in 1min. Try the processes of build automatically updated reports and make your work easier than ever before!

快来体验一下玩转工作报告于掌中的感觉,让我们的课程带您来感受1分钟制作出数据报告的急速体验,带您来尝试构建可自动更新报表的过程,带您来改变自己繁忙的工作状态!


Content:


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


•   How to build an Excel Pivot table

    Excel 数据透视构建报表

•   Make Professional report and chart by pivot chart

    使用数据透视图制作具有专业效果的图表报告

•   Let the pivot table refresh at any time

    设置让Excel复制到PPT的数据可以随时更新

 

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


• Master the skill of Excel Pivot table and Pivot chart

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

• Reasonabal data preparation

   数据的预处理技巧

• Understanding how to make the growth analysis, Profit analysis, mission completion analysis report by Excel

  了解工作中常见的业绩增长分析、利润分析、任务完成图等汇报表格、图表的构建方法

• Learning how to make auto updating report by Excel and PowerPoint   

  学习让从Excel 到PPT 数据自动更新的设计流程和注意事项


Target audience 目标听众

For the People who often make data report in daily work and want to study Pivot table and Pivot chart in depth. (Mid-Senior level course)

在工作中经常需要利用Excel 统计数据报告,希望深入学习数据透视表和图表报告制作的Excel 用户(中高级水平培训)


Speaker: 

王文雯- 易迪思金牌讲师

微软MOS大师级认证讲;

微软资深办公件专家;

国家二级人力资源师;

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

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

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


Registration:

Reserve your seat via britchamteam@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
×