This is a past event. Registration is closed. View other AmCham China events.
Faced with an overload of data, how can you quickly turn around a report? Learn tips and tricks that will dramatically alter your work life.
Note: This course will be delivered in Chinese. Attendees needs to bring their own laptops with at lowest Office 2007 English version.
Program Outline:
1. The challenges in our work report
• The problem about our data report
• How to design a professional report
2. Prepare a reasonable data
• Standard data format
• Match data in multi table
3. Make data report in 1 min by Pivot table
• The important prerequisite for Pivot table
• Build up a Pivot table
• Tips in using Pivot table
4. Using Pivot chart to design professional report
• How to make an annual report
• How to make a profit rose report
• How to make an mission completion report
• How to make a profit analysis report
5. Let the report automatic update
• Tips of copy data to PowerPoint
• Set up the updating of report
Note: This course will be delivered in Chinese. Attendees needs to bring their own laptops with at lowest Office 2007 English version.
Program Outline:
1. The challenges in our work report
• The problem about our data report
• How to design a professional report
2. Prepare a reasonable data
• Standard data format
• Match data in multi table
3. Make data report in 1 min by Pivot table
• The important prerequisite for Pivot table
• Build up a Pivot table
• Tips in using Pivot table
4. Using Pivot chart to design professional report
• How to make an annual report
• How to make a profit rose report
• How to make an mission completion report
• How to make a profit analysis report
5. Let the report automatic update
• Tips of copy data to PowerPoint
• Set up the updating of report
Who should attend?
People who make data reports in daily work and want to study Pivot table and Pivot chart in depth (Mid-Senior level course)
Trainer – Xue Zheng
Xue, a Microsoft Certified Professional, is the Office Special Trainer for MBA of School of Economics and Management, Tsinghua University. He has been given Microsoft MVP (Most Valuable Professional) annual awards since 2010.
Coffee, lunch, and light refreshments will be provided during breaks.
People who make data reports in daily work and want to study Pivot table and Pivot chart in depth (Mid-Senior level course)
Trainer – Xue Zheng
Xue, a Microsoft Certified Professional, is the Office Special Trainer for MBA of School of Economics and Management, Tsinghua University. He has been given Microsoft MVP (Most Valuable Professional) annual awards since 2010.
Coffee, lunch, and light refreshments will be provided during breaks.
