Member Login         Join Us

Home >> Trainings >>BritCham Training >> Aug 16: Effectively Data Report Design - Excel Pivot Table Training EXCEL快速搞定自动化报表设计
Details

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

1517974842361785.png

Date: Thursday, 16th Aug, 2018

Time: 9:00-17:00

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

Language: English

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

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

What will I learn?  我能学到些什么呢?


•    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的数据可以随时更新


In this practical workshop you will learn: 实用的课程将让你掌握

 

 Reasonabal data preparation

数据的预处理技巧

• Master the skill of Excel Pivot table and Pivot chart

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

• 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 用户(中高级水平培训)

 


Trainer Introduction

1502790624285999.jpg

王文雯- 易迪思金牌讲师


 


微软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
×