Home

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


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.


******Notes*****

  • This training is held by Zoom, from 9:00-12:00๏ผŒ13:00-16:30
  • Links will be sent to all successful registrants one day in advance before the training
  • The E-fapiao will be issued three days after the training is finished.
  • Any question, please contact Lina at lwang@amchamchina.org

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

Speakers

  • Grace Yan (Lecturer at Eddic)

    Grace Yan

    Lecturer at Eddic

    Microsoft Office International Certified Master
    Trainer working experience for the top 10 foreign companies
    Working experience of the world's top 500 companies
    Training experience of the world's top 500 companies
    Bilingual lecturer
    More than 10000 in-house trainees

    view more

Tickets

Members and Employees of Member Company
Standard Price RMB 998
Non-Members
Standard Price RMB 1,098

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.