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
ๅ็ๅจ่ฎฉๆจ็ๆฅๅ้ๅฟ่ๅจ
