This is a past event. Registration is closed. View other DUSA European Association Suzhou events.

Event Details

Although Excel is one of tools which are most frequently used by HR and finance practitioners and other managers, most people only master about 20% of Excel functions. Therefore, effective skills training helps you significantly increase the work efficiency of data analysis and reporting, save a large part of your working hours and improve yourself.

Excel是HR、财务等管理者使用最为频繁的工具之一,但很多人平时仅掌握了Excel中20%左右的应用功能,进行一次有效的技能培训可以大幅度地提高HR、财务等管理者在数据分析和报告中的工作效率,节约大量工作时间,并提升您自身价值。

Considering that those who frequently use Excel may also encounters technical bottlenecks and impossibly exert his/her huge potential of Excel, our courses are to help you solve those problems, help you improve Excel skills and significantly increase your work efficiency.

即使经常使用Excel的用户有时也会遇到技术瓶颈,而无法发挥Excel工具的巨大潜力。我们精心编排的课程就是解决大家在工作汇报中的那些瓶颈,帮助大家在实际工作中的Excel应用技能更上一层楼,极大提高您的工作效率。


Major Contents:

主要内容:

To rapidly collect and arrange data so as to significantly increase your efficiency in collecting and arranging non-standard data

数据的快速收集与整理,极大提高您的收集和整理不规范数据的效率;

To protect data so as to avoid mis-operation and data leakage

数据保护、避免误操作和数据泄露;

To rapidly improve the data analysis capability via pivot table and make a rapid response to data requirements proposed by superior

应用透视表快速提高数据分析能力,快速响应上级提出的数据要求。


Please bring your own laptop.

请自带笔记本电脑。

软件版本为 Office2016、2013 或 2010

Software version: Office 2016, 2013 or 2010


Course:

课程大纲:

  • Rapidly Collecting and Arranging HR basic data
  • HR基础数据快速收集整理

1. To rapidly find what you want from mass data

快速从海量的数据中找到您想要的

2. To learn some paste functions which you possibly do not know

粘贴的这些功能你可能还不会

3. To split and merge data

数据的分分合合

4. To verify data so as to avoid incorrect dataentry whichever possible

数据验证最大限度避免数据错误录入

5. To increase the data entry efficiency exponentially

成倍提高数据录入技巧

6. To apply screening and sorting functions during data arrangement and analysis

筛选排序在数据整理分析中的应用

7. To display your reports by levels for a clear structure

分级显示让您的报告层次分明


  • Protecting Your Results – Data Protection
  • 保护您的劳动成果——数据保护

1. To prevent from modifying report data

防止报告数据被修改

2. To give different permissions to different persons

给不同的人不同的权限

3. To protect your report structure

保护您的报告结构

4. To protect workbook files-lock sensitive data

保护工作簿文件——给敏感数据加把锁


  • Instantly Obtaining HR and Financial Analysis Reports - Data Perspective Analysis
  • 瞬间得到HR、财务分析报告——数据透视分析

1. To rapidly understand the powerful pivot table

快速了解强大的透视表

2. To instantly know various analysis scenarios via pivot table

透视表瞬间搞定各种分析场景

3. To perform better group analysis

技高一筹的分组分析

4. To easily provide dynamic reports via pivottable

透视表轻松实现动态报告

5. To switch your reports as you want by using a slicer

切片器让您的报告随心而动

Menu