Excel Training: Automatic Data Report Quick Design

This course will be delivered in Chinese. Attendees must bring a laptop with at least Office 2007, English version.

Do you feel upset when you work on the monthly or yearly work report?
How can we efficiently sort out all the data in hand and finish the report in the shortest time?
How to present a large amount of information and data in the clearest way?
And how can we say goodbye to overtime work?

Come and join our course! Experience the excitement of completing the data report within 1 minute and learn how to build automatically updated reports. You will find that report making could be easier than you ever thought!

Main Content:

1. How to build an Excel Pivot table
2. Make Professional charts and reports with the help of the pivot chart
3. Let the PivotTable data update at any time

Who Should Attend?

This course is designed for people who often make data reports with Excel and want to study Pivot table and Pivot chart in depth. (Mid-Senior level course)

Course Objective:

1. Master Excel Pivot table and Pivot chart.
2. Learn how to do growth analyses, profit analyses and progress report charts with Excel.
3. Learn how to make auto updating report with Excel and PowerPoint.

Course Agenda:

1 The challenges in our work report
1.1 Possible problems about our data report
1.2 How to design a professional report

2 Tips for data pre-processing
2.1 Standard data format
2.2 Multi-table data matching

3 Make data report in 1 min with Pivot table
3.1 The important prerequisite for Pivot table
3.2 Build up a Pivot table
3.3 Tips in using Pivot table

4 Use Pivot chart to design professional reports
4.1 How to make an annual report
4.2 How to make a year-on-year growth report
4.3 How to make a work progress report
4.4 How to make a profit analysis report
4.5 How to present the year-on-year growth

5 Let the report update automatically
5.1 Tips for copying data to PowerPoint
5.2 Automatic data update Coffee, lunch and light refreshments will be provided during breaks.

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

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 cancel@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.