Essential Skills Training: Better Manage Your Data
8:45 AM - 4:00 PM, Thursday, April 23, 2015 - AmCham China Conference Center
This course will be delivered in Chinese. Attendees must bring their own laptops with at least Office 2007 English version.
Many people keep working overtime just to keep up with data processing. Faced with the rapidly growing amount of data and the complicated, repetitive work involved in managing it, what can you do to control this flood of data? This training course aims to teach just that. From data searching and sorting to making rapid business reports, many secrets and skills within Excel can be unlocked, and make data management work easier and more efficient.
Who should attend?
Mid-to-senior professionals who need to improve their Excel skill level and efficiency with data processing.
1. Master the proposed data source formats in data processing.
2. Learn more efficient data processing and operation skills.
3. Find out how to quickly make reports and use the popular data analysis function, and improve the efficiency of data analysis.
4. Find appropriate data presentation and performance practices, highlighting the information of data, and improving the quality of work reports.
1 The basic data processing flow and the notice
1.1 The data processing flow in the work
1.2 The precondition-prerequisite of data processing
2 Data collection and sorting
2.1 Data collection
2.1.1 Multiple sources of data import
2.1.2 Standard the manual input data
2.2 The sorting of the data
2.2.1 The processing of unqualified data(Data validation)
2.2.2 The processing of repeated data
2.3 Popular tools of data processing
2.3.1 The special usage of sort
2.3.2 The advanced usage of filter
3 Data analysis faster
3.1 Summary data fast with subtotals
3.2 Use the PivotTable to build report
3.2.1 The premise of PivotTable
3.2.2 PivotTable getting start
3.2.3 The adjustment and beautification of PivotTable
4 Statistical analysis and report making with function
4.1 The necessary knowledge of using function
4.2 The learning of popular function
4.2.1 The statistical function (SUM, SUMIF, COUNT, COUNTIF, AVERAG, AVERAGEIF…）
4.2.2 The lookup function (VLOOKUP…）
4.2.3 The logical function (IF, AND, OR…）
4.3 Use the different functions together to solve practical problems with a case study
4.4 Troubleshooting for function error
5 The present of data information
5.1 Professional business chart
5.1.1 The popular chart types and tips
5.1.2 The layout and beautify of chart
5.1.3 The senior skills of chart application
5.2 Use conditional formatting presenting data information
5.2.1 Use default conditional formatting
5.2.2 Use a custom conditional formatting
6 Excel reports preparation
6.1 Excel report typesetting skills
6.1.1 Use hyperlinks in the table
6.1.2 Typesetting skills
6.2 The publish settings of electronic version
6.2.1 Protect the report not to be changed
6.2.2 Set the editing area
About the Trainer
Mr. Xue Zheng, a Microsoft Certified Professional, is the Office Special Trainer for MBA of 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.
AmCham China Conference Center
No. 10 Jintongxi Road, The Office Park, Tower AB 6th Floor
8:45-9:00AM - Registration
9:00-12:00PM - Morning Session
12:00-1:00PM - Lunch
1:00-4:00PM - Afternoon Session
Cardholding members advanced discounted online price: RMB 2,000
Non-cardholding employees of member companies: RMB 2,000
Non-members: RMB 2,500
Special Registration Information:
You must register in advance. Walk-ins will not be accepted; Attendees need to pay by April 15, 2015; Limited spots are available and attendance is given on a first-come, first-served basis.
AmCham China Events:
Events have limited seating so to ensure your attendance we encourage advance online registration and payment for ALL events. We cannot guarantee entry to anyone not registered in advance. All AmCham China events are in English unless stated otherwise. Please also be aware that the Member Advanced Price is only for members who register AND pay online prior to the closing date and time for this event. Members who do not register and pay online will be charged the At-The-Door price.
This event is off-the-record.
For more information, please contact: Caroline Wang, Tel: (8610) 8519-0892, Email: [email protected].
If you cannot attend an event for which you have registered, please cancel your registration no later than one business day prior to the event. If you fail to notify AmCham China of your cancellation in a timely fashion, you will be charged for event costs.
To cancel you can 1) call 8519-0828 and leave a voicemail message including your name, and event title and date, 2) email [email protected], or 3) cancel online if you registered for the event through the website. Thank you for your cooperation and helping AmCham China maintain the quality of its events.
Please note: Requests for official payment receipts for 2013 (fapiao) must be submitted to AmCham China before December 25, 2013. Requests made after that time will not be accommodated. Please contact [email protected].
Visit the original source and full text: The American Chamber of Commerce in the People's Republic of China