Event Details

(This training is part of a series focusing on MS Office. See below for more information on discounts.)

This course will be delivered in Chinese. Attendees must bring a laptop with Office 2010 or higher.

Excel isn't just for summarizing data and producing reports. It can help us to mine deeper into the information hidden behind business data and identify the problems in your business, allowing you to make better decisions. If you want to learn about the logical thinking used by the masters of data analysis or get insights into potential problems in your work, then join us to learn about how to leverage Excel for deep analysis and mining into data.

Why you need this training: By taking our course, you will use the three-step screening method to identify problems through data analysis, use pivot tables and other functions to design a business data dashboard, as well as use interactive charts for reporting.

If you are already familiar with Excel but want to stretch your skills to make better decisions, this course is for you.
This course will be conducted in Chinese.

Series Discount

This training is part of a series focusing on MS Office. Register for any two to get a 5% discount, or three to enjoy 10% off. Please contact Cassie Yin for the discount ticket or more information.

Here's the other two MS Office trainings that you don't want to miss:
PPT Training--Perfecting Visual Communication (Advanced Design Course)​
Making Successful Business Presentation with Professional PPT​
 

The Details

Main content:
  • Using advanced tips of Pivot table to lock business problems
  • Using Pivot Table to design data analysis dashboard supporting auto refresh
  • Using charts, functions and controls to make dynamic interactive chart

Course outline: 

1. Data statistics and data mining
1.1 Data analysis technique different from general data summarization
1.2 How does data analysis help with business sector
2. Data mining method to quickly identify business problems 
2.1 Three principles to analyze business problems by Pivot Table
2.2 Routine application and advanced functions of Pivot Table
2.3 Data mining and establishment of problem screening mechanism
2.4 Effectively present problems using Pivot Chart
2.5 Practice : identify core business problems through mass data
3. Establish instant business information feedback mechanism 
3.1 Use Pivot Table and Slicer to design interactive dynamic report
3.1.1 Use slicer to establish dynamic data report
3.1.2 Use charts to effectively represent business situation
3.1.3 Highlight the KPI by conditional formatting
3.1.4 Establish data relationship model among multiple charts
3.2 Use macro to realize automatic data refresh
3.3 Practice : create data dashboard report
4. Function data dashboard design and making (one –day course not including this session)
4.1 Use functions to realize complex data analysis and transferring
4.1.1 Use functions for date processing
4.1.2 Use functions to build relationships between two tables
4.2 Use control development and functions to create advanced interactive report
4.2.1 How to use controls
4.2.2 Develop effective combination of control and function
4.3 Make dynamic interactive chart
4.3.1 Choose the right type of charts
4.3.2 Make dynamic chart data source
4.4 Practice: make business data interactive chart

Special Registration Information:
You must register in advance. Walk-ins will not be accepted. Attendees need to pay by April 10, 2017. Limited spots are available and attendance is given on a first-come, first-served basis.

Coffee, lunch and light refreshments will be provided during breaks.

Feedback from Previous Participants

"The content is very useful and everything was well-planned." (@Bcis)

"The teacher is very flexible in terms of meeting different needs and adjusting to different learning levels." (@Crbard)

"It is very applicable to my daily work and the course contains very clear examples." (@Agilent)

Agenda

8:45 AM - 9:00 AM
Registration
9:00 AM - 12:00 PM
Morning Session
12:00 PM - 1:00 PM
Lunch Break
1:00 PM - 4:00 PM
Afternoon Session

Speakers

  • Zheng XUE

    Zheng XUE

    Zheng XUE, a Microsoft Certified Professional, is the Office Special Trainer for MBA classes at Tsinghua University. He has been given Microsoft MVP (Most Valuable Professional) annual awards since 2010.
    Acted as a trainer and leader of office skills program for Microsoft’s employees, delivering the Microsoft Office‘s application skills and using values. He made a great contribution to design the exact training course with perfect training system for enterprises professionally due to his rich experiences in course designing and teaching.
    Graduated from Beijing Normal University, during the period of university, he had studied courses of pedagogy, psychology, owning professional knowledge background in education and training. Moreover, he had his own unique insights in terms of curriculum design and teaching contents.

    view more

Tickets

Members (Sold Out)

Please pay by Apr.10, 2017.

Standard Price RMB 2,000
Non-Members (Sold Out)

Please pay by Apr.10, 2017.

Standard Price RMB 2,500
5% off Ticket (Sold Out)

Please contact Cassie YIN (cyin@amchamchina.org) if you would like to register 2 MS Office courses.

Standard Price RMB 3,800

Cancellation Policy

If you cannot attend a training for which you have registered, please cancel your registration no later than five business day 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 training@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.