Home
This training course is for people who use Excel on a daily basis and would like to learn more about advanced data processing. During this training, you will touch on a wide range of topics such as: logical structural designs for data, data collection and analysis skills, effective presentation of data using charts, data security and protection methods, and much more.
ๆฌ่ฏพ็จ้ๅๆ้่ฆ็ณป็ปๆๅ Excel ไฝฟ็จๆฐดๅนณ๏ผๆ้ซๆฐๆฎๅค็ๆ็็ Excel ็จๆท๏ผไธญ้ซ็บงๆฐดๅนณๅน่ฎญ๏ผใ
้ขๅฏนๆตท้็ๅทฅไฝๆฐๆฎๅ็นๅค็้ๅคๅทฅไฝ๏ผๆไปฌ้่ฆๆๆกไปไนๆ ท็ๆนๆณๅๆๅทงๆ่ฝ่ฝปๆพ้ฉพ้ฉญExcelๅถไฝๆฅ่กจ๏ผ็ญๆกๅฐๅจๆฌๆฌกๅน่ฎญ่ฏพ็จไธญๅพๅฐๆญๆใไปๆฐๆฎ็ๆฅๆพใๆด็ๅฐๅๅกๆฅ่กจ็ๅฟซ้ๅถไฝ๏ผๅ ถไธญๆๅพๅค็็ง่ฏๅๆๅทงๅฏไปฅ่ฎฉๆไปฌ็ๅทฅไฝๆด่ฝปๆพใๆดๆบ่ฝใ
Course Objectives:
1. Master data source formats and correct errors when establishing data forms
2. Learn and master practical functions to enhance the efficiency of processing data and operational skills
3. Master the tools for quickly making reports and the popular data analysis function, and improve the efficiency of data analysis
4. Find suitable data presentation and performance practices, highlight information among your data, and improve the quality of your work reports
้่ฟๅๅ ๆญคๆฌกๅน่ฎญ๏ผๅญฆๅ่ฝๅค๏ผ
Topics Covered:
Please Note:
1. This training will be conducted in English with support in Chinese
2. All attendees must bring their own laptop, with Office 2010 software or above installed
่ฏทๆณจๆ๏ผ
1. ๆญคๆฌกๅน่ฎญๅฐไปฅ่ฑๆๅ็ฐ๏ผไฝ่ฎฒๅธๅฏไปฅไปฅไธญๆๅๅฉ
2. ่ฏท่ชๅค็ต่๏ผ้่ฆ็จๅฐOffice 2010 software ๆๆๆฐ็ๆฌ
ๆฌ่ฏพ็จ้ๅๆ้่ฆ็ณป็ปๆๅ Excel ไฝฟ็จๆฐดๅนณ๏ผๆ้ซๆฐๆฎๅค็ๆ็็ Excel ็จๆท๏ผไธญ้ซ็บงๆฐดๅนณๅน่ฎญ๏ผใ
้ขๅฏนๆตท้็ๅทฅไฝๆฐๆฎๅ็นๅค็้ๅคๅทฅไฝ๏ผๆไปฌ้่ฆๆๆกไปไนๆ ท็ๆนๆณๅๆๅทงๆ่ฝ่ฝปๆพ้ฉพ้ฉญExcelๅถไฝๆฅ่กจ๏ผ็ญๆกๅฐๅจๆฌๆฌกๅน่ฎญ่ฏพ็จไธญๅพๅฐๆญๆใไปๆฐๆฎ็ๆฅๆพใๆด็ๅฐๅๅกๆฅ่กจ็ๅฟซ้ๅถไฝ๏ผๅ ถไธญๆๅพๅค็็ง่ฏๅๆๅทงๅฏไปฅ่ฎฉๆไปฌ็ๅทฅไฝๆด่ฝปๆพใๆดๆบ่ฝใ
Course Objectives:
1. Master data source formats and correct errors when establishing data forms
2. Learn and master practical functions to enhance the efficiency of processing data and operational skills
3. Master the tools for quickly making reports and the popular data analysis function, and improve the efficiency of data analysis
4. Find suitable data presentation and performance practices, highlight information among your data, and improve the quality of your work reports
้่ฟๅๅ ๆญคๆฌกๅน่ฎญ๏ผๅญฆๅ่ฝๅค๏ผ
- ๆๆกๆฐๆฎๅๆไธญ็็ๆณๆฐๆฎๆบๆ ผๅผ๏ผๆนๅๅปบ็ซๆฐๆฎ่กจๆ ผ็้่ฏฏไน ๆฏใ
- ๅญฆไน ๅนถๆๆก่ฝๆๅๆฐๆฎๅค็ๆ็็ๅฎ็จๅ่ฝๅนถๆๆกๆไฝๆๅทงใ
- ๆๆกๅฟซ้่ฟ่กๆฅ่กจๅถไฝ็้่ฆๅทฅๅ ทๅๅธธ็จๆฐๆฎๅๆๅฝๆฐ๏ผๆ้ซๆฐๆฎ็ป่ฎกๅๆๆ็ใ
- ๆพๅฐ้ๅ่ชๅทฑ็ๆฐๆฎๅ็ฐๆนๅผๅ่กจ็ฐๆๆณ๏ผ็ชๅบๆฐๆฎไฟกๆฏ๏ผๆ้ซๅทฅไฝๆฅ่กจ่ดจ้ใ
Topics Covered:
- Basic data processing flows and things to keep in mind
- Data collection and sorting
- Advanced data analysis
- Statistical analysis and report making functions
- Data presentation
- Excel report preparation
- โๆฐๆฎๅค็ๅบๆฌๆต็จๅๆณจๆไบ้กน
- ๆฐๆฎ็ๆถ้ๅๆด็
- ๆฐๆฎ็ๅฟซ้็ป่ฎกไธๅๆ
- ๅฉ็จๅฝๆฐ่ฟ่ก็ป่ฎกๅๆๅๆฅ่กจๅถไฝ ใ
- ๆฐๆฎไฟกๆฏ็ๅ็ฐ
- Excel ๆฅ่กจ็ๅๅธๅๅค
Please Note:
1. This training will be conducted in English with support in Chinese
2. All attendees must bring their own laptop, with Office 2010 software or above installed
่ฏทๆณจๆ๏ผ
1. ๆญคๆฌกๅน่ฎญๅฐไปฅ่ฑๆๅ็ฐ๏ผไฝ่ฎฒๅธๅฏไปฅไปฅไธญๆๅๅฉ
2. ่ฏท่ชๅค็ต่๏ผ้่ฆ็จๅฐOffice 2010 software ๆๆๆฐ็ๆฌ
