This is a past event. Registration is closed. View other AmCham China events.
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.
Training Objectives
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.
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.
Training Objectives
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.
Outline
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.
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.
