Event Details
This course will be delivered in Chinese. Attendees must bring a laptop with at least Office 2010, English version.
Course description:
What is the best price? How do you determine the wages and performance of the sales team? How can we maximize profit? Solving such problems needs not only experience, but also a set of data-based decision-making methods. For managers or directors, with the assistance of Excel’s advanced functions, this course will help you find the internal relationships between existing business data, estimate the impact of changes and make the right decisions. Excel can also create data models to help you make wise business decisions. Business modeling is a compulsory content in MBA programs, as it can help you understand the real role of data in enterprise management, and replace traditional experience management with data management. To master your business management skills, this course is your best choice.
Course Objective:
1. Learn the methods of data estimation.
2. Master the skill of estimation functions, "what-if" analysis, regression and Solver.
3. Learn how to design business models and search for the best decision.
Audience:
For those who need to make decisions according to the results of data estimation. Especially suitable for finance professionals, HR directors or senior managers who have good Excel foundation. (Senior Level Training)
Course Agenda:
1 Data estimation overview
1.1 Difference between data estimating and traditional data summarizing.
1.2 How can data estimating and data modeling help us?
2 Use functions to estimate data
2.1 The common functions in data estimating
2.2 Practice: How to choose the best investment plan
3 Make the best plan by "what-if" analysis
3.1 Using Goal seek in the case of single variable
3.2 Using Data table in the case of double variables
3.3 Design a forecasting system with many variables by developing controls
3.4 Practice: Program design to maximize the profit
4 Search the law of data by Regression
4.1 Regression model fitted by charts
4.2 Regression model fitted by data analysis tools
4.3 Practice: Estimating a demand curve
4.4 Choose the right regression equation type
4.5 Make the “Demand-Pricing” decision by regression
4.6 Practice: Find the business “balance point”
5 Make the right decision by Solver
5.1 How to use the Solver tools
5.2 Practice: Search for the best overtime plan
6 Optional content
6.1 Factor analysis: T-test, ANOVA, correlation analysis
6.2 Data estimating under uncertainties: Monte Carlo simulation
6.3 Sensitivity analysis: How to find the sensitivity of each factor
Special Registration Information:
You must register in advance. Walk-ins will not be accepted. Attendees need to pay by July 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.
Course description:
What is the best price? How do you determine the wages and performance of the sales team? How can we maximize profit? Solving such problems needs not only experience, but also a set of data-based decision-making methods. For managers or directors, with the assistance of Excel’s advanced functions, this course will help you find the internal relationships between existing business data, estimate the impact of changes and make the right decisions. Excel can also create data models to help you make wise business decisions. Business modeling is a compulsory content in MBA programs, as it can help you understand the real role of data in enterprise management, and replace traditional experience management with data management. To master your business management skills, this course is your best choice.
Course Objective:
1. Learn the methods of data estimation.
2. Master the skill of estimation functions, "what-if" analysis, regression and Solver.
3. Learn how to design business models and search for the best decision.
Audience:
For those who need to make decisions according to the results of data estimation. Especially suitable for finance professionals, HR directors or senior managers who have good Excel foundation. (Senior Level Training)
Course Agenda:
1 Data estimation overview
1.1 Difference between data estimating and traditional data summarizing.
1.2 How can data estimating and data modeling help us?
2 Use functions to estimate data
2.1 The common functions in data estimating
2.2 Practice: How to choose the best investment plan
3 Make the best plan by "what-if" analysis
3.1 Using Goal seek in the case of single variable
3.2 Using Data table in the case of double variables
3.3 Design a forecasting system with many variables by developing controls
3.4 Practice: Program design to maximize the profit
4 Search the law of data by Regression
4.1 Regression model fitted by charts
4.2 Regression model fitted by data analysis tools
4.3 Practice: Estimating a demand curve
4.4 Choose the right regression equation type
4.5 Make the “Demand-Pricing” decision by regression
4.6 Practice: Find the business “balance point”
5 Make the right decision by Solver
5.1 How to use the Solver tools
5.2 Practice: Search for the best overtime plan
6 Optional content
6.1 Factor analysis: T-test, ANOVA, correlation analysis
6.2 Data estimating under uncertainties: Monte Carlo simulation
6.3 Sensitivity analysis: How to find the sensitivity of each factor
Special Registration Information:
You must register in advance. Walk-ins will not be accepted. Attendees need to pay by July 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.
