活动详情
This course will be delivered in Chinese. Attendees must bring a laptop with at least Office 2007, English version.
Many people have to work overtime to deal with the data processing. Faced with the huge amount of data and complicated repetitive work, what method and skills do we need to master Excel? We will find out the answer in our course. From data searching, sorting and rapid making business reports, you will learn many secrets and skills to make our work easier and smarter.
Main Content:
Who should attend?
People who need to improve Excel competence and data processing competency (mid-senior level)
Training Objectives
1. Master data source formats.
2. Master the tools of fast report production and the popular data analysis functions.
3. Learn suitable data presentation practices, highlighting important information and improving work reports.
Course Agenda:
1 Basic data processing flow
1.1 The data processing flow
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 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
3 Faster data analysis
3.1 Use the PivotTable to build reports
3.1.1 The premise of PivotTable
3.1.2 Smarter use of PivotTable
3.1.3 The adjustment and beautification of PivotTable
3.2 Learning popular functions
3.2.1 The lookup function（VLOOKUP…）
3.2.2 The logical function（IF, AND, OR…）
3.3 Design a data report by functions
4 Chart Design and data visualization
4.1 Professional business chart
4.1.1 The popular chart types and tips
4.1.2 The layout and beautification of charts
4.1.3 Advanced chart application
4.2 Date visualization——make your data beautiful
4.2.1 How to make your chart clear
4.2.2 How to make the chart more business
4.3 Use conditional formatting presenting data information
4.3.1 Use default conditional formatting
4.3.2 Use custom conditional formatting
Special Registration Information:
You must register in advance. Walk-ins will not be accepted. Attendees need to pay by Apr 14, 2016. 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.
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.
Many people have to work overtime to deal with the data processing. Faced with the huge amount of data and complicated repetitive work, what method and skills do we need to master Excel? We will find out the answer in our course. From data searching, sorting and rapid making business reports, you will learn many secrets and skills to make our work easier and smarter.
Main Content:
- Excel data management tips
- Summarize data quickly. (including PivotTable and useful functions)
- Effective presentation data with charts
Who should attend?
People who need to improve Excel competence and data processing competency (mid-senior level)
Training Objectives
1. Master data source formats.
2. Master the tools of fast report production and the popular data analysis functions.
3. Learn suitable data presentation practices, highlighting important information and improving work reports.
Course Agenda:
1 Basic data processing flow
1.1 The data processing flow
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 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
3 Faster data analysis
3.1 Use the PivotTable to build reports
3.1.1 The premise of PivotTable
3.1.2 Smarter use of PivotTable
3.1.3 The adjustment and beautification of PivotTable
3.2 Learning popular functions
3.2.1 The lookup function（VLOOKUP…）
3.2.2 The logical function（IF, AND, OR…）
3.3 Design a data report by functions
4 Chart Design and data visualization
4.1 Professional business chart
4.1.1 The popular chart types and tips
4.1.2 The layout and beautification of charts
4.1.3 Advanced chart application
4.2 Date visualization——make your data beautiful
4.2.1 How to make your chart clear
4.2.2 How to make the chart more business
4.3 Use conditional formatting presenting data information
4.3.1 Use default conditional formatting
4.3.2 Use custom conditional formatting
Special Registration Information:
You must register in advance. Walk-ins will not be accepted. Attendees need to pay by Apr 14, 2016. 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.
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.
