Home

In this training session you will learn about:
Reasonable design of Excel data structure
Data collection and analysis skills๏ผˆContaining PivotTable and other popular functions๏ผ‰
Effective presentation data with chart
The method of data security and protection

ไธป่ฆๅ†…ๅฎน
ๅˆ็†็š„ Excel ๆ•ฐๆฎ็ป“ๆž„่ฎพ่ฎก
ๆ•ฐๆฎ็š„ๆ•ด็†ๅ’Œๅˆ†ๆžๆŠ€ๅทง๏ผˆๅซๆ•ฐๆฎ้€่ง†ๅ’Œๅธธ็”จๅ‡ฝๆ•ฐ๏ผ‰
ๅˆฉ็”จๅ›พ่กจๆœ‰ๆ•ˆๅ‘ˆ็Žฐๆ•ฐๆฎ
ๆ•ฐๆฎ็š„ๅฎ‰ๅ…จๅ’ŒไฟๆŠคๆ–นๆณ•่ฝฏไปถ็‰ˆๆœฌไธบ Office 2010 ๆˆ– 2007

Course Objectives
1. Master the proposed data source formats in data processing๏ผŒand correcting errors when establishing data form.
2. Learn and master enhancing the efficiency of processing data, and operation skills.
3. Master the tools of fast-making reports and popular data-analysis functions, and improve the efficiency of data analysis.
4. Pinpoint suitable data presentations and performance practices, highlight the information of data, and improve work report quality

่ฏพ็จ‹็›ฎๆ ‡
1. ๆŽŒๆกๆ•ฐๆฎๅˆ†ๆžไธญ็š„็†ๆƒณๆ•ฐๆฎๆบๆ ผๅผ๏ผŒๆ”นๅ˜ๅปบ็ซ‹ๆ•ฐๆฎ่กจๆ ผ็š„้”™่ฏฏไน ๆƒฏใ€‚
2. ๅญฆไน ๅนถๆŽŒๆก่ƒฝๆๅ‡ๆ•ฐๆฎๅค„็†ๆ•ˆ็Ž‡็š„ๅฎž็”จๅŠŸ่ƒฝๅนถๆŽŒๆกๆ“ไฝœๆŠ€ๅทงใ€‚
3. ๆŽŒๆกๅฟซ้€Ÿ่ฟ›่กŒๆŠฅ่กจๅˆถไฝœ็š„้‡่ฆๅทฅๅ…ทๅ’Œๅธธ็”จๆ•ฐๆฎๅˆ†ๆžๅ‡ฝๆ•ฐ๏ผŒๆ้ซ˜ๆ•ฐๆฎ็ปŸ่ฎกๅˆ†ๆžๆ•ˆ็Ž‡ใ€‚
4. ๆ‰พๅˆฐ้€‚ๅˆ่‡ชๅทฑ็š„ๆ•ฐๆฎๅ‘ˆ็Žฐๆ–นๅผๅ’Œ่กจ็Žฐๆ‰‹ๆณ•๏ผŒ็ชๅ‡บๆ•ฐๆฎไฟกๆฏ๏ผŒๆ้ซ˜ๅทฅไฝœๆŠฅ่กจ่ดจ้‡ใ€‚

Session Outline

1 Basic data processing flow
  • Data processing workflow
  • Prerequisites of data processing

2 Data collection and sorting
  • Data collection
  • Data sorting
  • Popular tools of data processing
  • Advanced usage of filter
 
3 Faster data analysis
  • Fast data summary
  • Use the Pivot Table to build reports

4 Statistical analysis and report making with function
  • The necessary knowledge of using function
  • The learning of popular function
  • Use the different functions together to solve practical problems——case study
  • Troubleshooting for function error
 
5 The present of data information
  • Professional business chart
  • Use conditional formatting presenting data information

6 Excel reports preparation
  • The Excel report typesetting skills
  • The publish settings of electronic version

1 ๆ•ฐๆฎๅค„็†ๅŸบๆœฌๆต็จ‹ๅ’Œๆณจๆ„ไบ‹้กน
  • ๅทฅไฝœไธญ็š„ๆ•ฐๆฎๅค„็†ๆต็จ‹
  • ๆ•ฐๆฎๅค„็†็š„ๅฟ…่ฆๅ‰ๆ
  
2 ๆ•ฐๆฎ็š„ๆ”ถ้›†ๅ’Œๆ•ด็†
  • ๆ•ฐๆฎ็š„ๆ”ถ้›†
  • ๆ•ฐๆฎ็š„ๆ•ด็†
  • ๅธธ็”จๆ•ฐๆฎๅค„็†ๅทฅๅ…ท

3 ๆ•ฐๆฎ็š„ๅฟซ้€Ÿ็ปŸ่ฎกไธŽๅˆ†ๆž
  • ๅˆฉ็”จๅˆ†็ฑปๆฑ‡ๆ€ปๅฟซ้€Ÿ็ปŸ่ฎกๆ•ฐๆฎ
  • ็ตๆดป่ฟ็”จๆ•ฐๆฎ้€่ง†่กจๆž„ๅปบๆŠฅ่กจ

4 ๅˆฉ็”จๅ‡ฝๆ•ฐ่ฟ›่กŒ็ปŸ่ฎกๅˆ†ๆžๅ’ŒๆŠฅ่กจๅˆถไฝœ
  • ๅ‡ฝๆ•ฐ่ฟ็”จ็š„ๅฟ…่ฆๅ‡†ๅค‡็Ÿฅ่ฏ†
  • ๅธธ็”จๅ‡ฝๆ•ฐ็š„ๅญฆไน 
  • ๅˆฉ็”จๅ‡ฝๆ•ฐ็ปผๅˆ่งฃๅ†ณๅฎž้™…้—ฎ้ข˜——ๆกˆไพ‹ๅญฆไน 
  • ๅ‡ฝๆ•ฐๅธธ่ง้”™่ฏฏ็š„ๆŽ’้™ค

5 ๆ•ฐๆฎไฟกๆฏ็š„ๅ‘ˆ็Žฐ
  • ไธ“ไธšๅŒ–็š„ๅ•†ๅŠกๅ›พ่กจๅบ”็”จ
  • ไฝฟ็”จๆกไปถๆ ผๅผๅ‘ˆ็Žฐๆ•ฐๆฎไฟกๆฏ

6 Excel ๆŠฅ่กจ็š„ๅ‘ๅธƒๅ‡†ๅค‡
  • Excel ๆŠฅ่กจๆŽ’็‰ˆๆŠ€ๅทง
  • ็”ตๅญ็‰ˆๆœฌ็š„ๅ‘ๅธƒ่ฎพ็ฝฎ
Who should attend?
For people who need to improve their Excel skills, as well as improve their efficiency of data processing๏ผˆMid-Senior level course๏ผ‰

ๆœฌ่ฏพ็จ‹้€‚ๅˆๆœ‰้œ€่ฆ็ณป็ปŸๆๅ‡ Excel ไฝฟ็”จๆฐดๅนณ๏ผŒๆ้ซ˜ๆ•ฐๆฎๅค„็†ๆ•ˆ็Ž‡็š„ Excel ็”จๆˆท๏ผˆไธญ้ซ˜็บงๆฐดๅนณ ๅŸน่ฎญ๏ผ‰

Speakers

  • Pasta Pei (Professional Trainer at Microsoft)

    Pasta Pei

    Professional Trainer at Microsoft

    Pasta Pei has more than 6 years of training experience on corporate IT techniques training and highly efficient Office series course training. He understands the subtleties of customers’ needs, and tailors to their requirements on IT system software applications and training solutions to help improve their work efficiency.

    Pei has intensively researched topics on corporate training and adult education which he uses in his training courses.

    Pei teaches in a simple but profound way; his course structures are logical and coherent. He motivates his attendees with a humourous teaching style that has been well-received in the past.

    view more

Agenda

08:45 Registration & Networking
09:00 Morning Session
10:30 Morning Session Coffee Break
10:45 Morning Session
12:00 Lunch
13:00 Afternoon Session
15:30 Afternoon Session Coffee Break
15:45 Afternoon Session
17:00 Session Ends

Tickets

A prepayment is required when choosing 'Members only price' or 'Standard Price'.

“ไผšๅ‘˜็ฅจไปท”ๅŠ“ๆ ‡ๅ‡†็ฅจไปท”่ฆๆฑ‚ๆ‚จๅœจๆไบคๆณจๅ†ŒไฟกๆฏๅŽๅณๅˆปๅฎŒๆˆๅœจ็บฟ้ข„ไป˜๏ผŒ่‹ฅๆ‚จๅธŒๆœ›ๅœจๆดปๅŠจ็Žฐๅœบๆ”ฏไป˜้—จ็ฅจ๏ผŒ่ฏท้€‰ๆ‹ฉ“็Žฐๅœบ็ฅจไปท”ใ€‚
Member Ticket
Member Price RMB 2,650
Member Company Employee Ticket
Standard Price RMB 3,650
Non-Member Ticket
Standard Price RMB 4,650

Registration

  • All registrations shall be made online before the session. For full-day sessions, payment also shall be made before the session.
  • For half-day sessions, AmCham Shanghai members are eligible to attend free of charge with Training Credit*; AmCham Shanghai members without Training Credit are eligible to attend at “Member Rate”; Employees who work at AmCham Shanghai member companies are eligible to attend at "Employee Rate".
  • For full-day sessions, AmCham Shanghai members are eligible to attend at “Member Rate”; Employees who work at AmCham Shanghai member companies are eligible to attend at “Employee Rate”; Non-members are eligible to attend at “Non-Member Rate”.
  • Limited spaces are available and attendance will be given on a first-come, first-served basis.
  • Members please bring your membership card and non-members bring your business card upon check-in at the training session.
Walk-in and Cancellation Policy
  • This session requires confirmation of attendance in advance. If you attend this session without prior registration, you will be charged an RMB50 "walk-in" fee as member and RMB100 as employee.
  • Cancellation: If you need to cancel your registration for a half-day session, please notify Ivette Corominas at (86 21) 6279 7119 ext. 5671 or email ivette.corominas@amcham-shanghai.org no less than 24 hours in advance. If you need to cancel your registration for a full-day session, please notify Ivette Corominas at least two weeks prior to the session for a full refund. Cancellation made within two weeks before the session will not be refundable.
  • To ensure that you have a seat, please come to the session on time. Open seats will be released to other guests 15 minutes after the session starts.