****This online training is conducted in Chinese****

Mark your calendar for our Excel training on August 16th! You will become a master through our one-day training session!

What you will learn from this training?

  • Master the higher-level functions to process more complex data statistics and analysis;
  • Master the relevant tools of data analysis and find the value of data effectively;
  • Master data table production methods, make data analysis results more comprehensive, systematic and efficient;
  • Master the drawing methods of high-level business chart types to make the forms of data transmission more novel and diversified;

Who should attend?

  • Suitable for employees who want to improve their work efficiency and master data analysis methods.

Event Details:

  • Event format: online
  • Time & Date: 9:00-12:00, 13:00-16:30, Aug. 16th
  • Language: Chinese
  • Contact: Lina, lwang@amchamchina.org


  • Registration is required and the event link will be provided for verified registrants to access the meeting the day before the event. Registration closes at August 15th, 18:00
  • This training is held by Zoom
  • The E-fapiao will be issued three days after the training is finished.

Course Outlines

Table Basis: Advanced Skills

1. Smart form

2. Conditional format

3. Sorting and fast filling

4. Data protection of workbooks, worksheets and cells

5. Mail merge

Soul of Table: The Charming of Formulas

1. Formula and basic function

2. Sum, SUMIF, SUMIF, Count, CountIF, CountIFS

3. Solve difficult problems - Logic search: Lookup, VLookup, Match

4. Date function: datedif, networkdays

The Weapon of Table: Pivot Table

1. Initial PivotTable

2. Different summary methods for the same syllable

3. Automatic and manual combination of pivot table

4. Slicer use and linkage

5. Dynamic PivotTable settings

Power Query

1. Automatic summarizing of workbook

2. Automatic summarizing of file

The Impression of Table:Business Charts

1. Mini chart, double Y-axis chart, Pie chart

2. Chart beautification: column chart, line chart, pie chart

3. Making contrast: thermometer column chart, column stack chart


  • Grace Yan (Chief Trainer/Microsoft Office Chinese-English Bilingual Trainer at Eddic)

    Grace Yan

    Chief Trainer/Microsoft Office Chinese-English Bilingual Trainer at Eddic

    Grace,Microsoft Certified Trainer, is also the trainer of Microsoft’s golden partner. She is certified as Microsoft Certified Office Master, Microsoft Certified Excel / PPT/ Word(Full mark in Word part) and Microsoft Certified Data Analyst Associate. As a bilingual trainer, she was the internal trainer of G10 multinational enterprise. Grace has been worked in Dell, Chevron and Pernod-Ricard. Having rich experience in office training in global 500 companies, she has helped solving office problems for clients and trainees. Until now, more than 10,000 trainees are benefited from Grace’s training. Grace, with more than 10 years’ experience of Microsoft Office Word/Excel/PPT and Power BI, can meet corporate’s training requirements, and helps students’ office skills quickly. Her professional training is designed in good logic and is delivered in a humor style and being well acclaimed by trainees. She has permanent cooperation with companies for PPT designing and designed PPT for many companies for regular report or public press conference.

    view more


Members and Employees of Member Company
Standard Price RMB 1,098
Standard Price RMB 1,298
Member Group Ticket for 3 People (RMB 998/person)
Standard Price RMB 2,994
Non-member Group Ticket for 3 People (RMB 1098/person)
Standard Price RMB 3,294

Cancellation Policy

If you cannot attend a training for which you have registered, please cancel your registration no later than five business days prior to the training. If you fail to notify AmCham China of your cancellation in a timely fashion, you will be charged for training costs.

To cancel you can: 1) email lwang@amchamchina.org, or 2) cancel online if you registered for the training through the website.

Your cooperation in this matter supports AmCham China in maintaining the quality of its trainings and is appreciated by your fellow members and the organization.