More details about this course:
Create the Management Tools and Build Excel Skills!
In this class, you'll cover..

• Regression and trend analysis
  
• Pareto Chart
  
• PERT and Monte Carlo Analysis
  
• Computing Process Capability
  
• Probability Density and Cumulative Distributions
  
• Statistical Process Charts
  
• Automating Macros
  
• Conditional Probability

Come to this class ready to get hands-on with Excel
This course is a fast-paced, hands-on workshop. Every student will be provided with a computer running Excel. Become comfortable interpreting trends, combining data sources, spotting problems areas and more. Guided by an expert instructor, you'll leave this course with the real-world experience you need to fully harness the powerful tools Excel has to offer back in your workplace.


Immediate Benefits of Attending This Class

1. Discover trends in data and reports for risk analysis and forecasting by creating a regression/trend analysis
   
2. Identify key process/product improvement opportunities as well as perform root cause analysis
   
3. Determine and manage risks in project schedules and define confidence factors
   
4. Know the specific process capability of project processes utilizing Ppk and Cpk metrics: a key tool used in measuring process effectiveness for Six Sigma projects
   
5. Model key business processes and be able to perform sophisticated optimization analyses
   
6. Calculate process control limits and superimpose customer specification limits, determine if process is meeting customers needs
   
7. Identify potential issues or showstoppers in data and be able to identify potential risk triggers
   
8. Know the ins and outs of pivot table creation, validate, consolidate, convert, sort and filter your data
   
9. Automate your repeatable processes, using macros to create reports and data analysis charts, instantly
   
10. Trace Precedents and Dependents to analyze cascading formulas and troubleshoot spreadsheet issues
    
11. Quickly analyze data and create reports using the key financial, math and statistical functions of the Function Library
    
12. Easily format external data using “Get External Data” Functions, automate this function for repeatable processes
    
13. Create sophisticated data analytics through the use of one- and two- way ANOVA
    
14. Secure workbooks and cells, know how to lock down critical formulas to prevent altering of key computation or data fields
    
15. Determine needs, causes, effects and anticipated results of a project, implement the most cost effective process improvement actions, using analysis charts
    
16. Learn to quickly and accurately audit formulas through your complex spreadsheets, troubleshoot precedents and successor processes
    
17. Build a customized analysis model based on your firms probabilities and risk tolerance, gain an accurate tool to determine your companies risks
    
18. Modify report formats to meet the needs of specific management and department heads using the multitude of data formatting options in Excel

For the Project Manager, Data Analyst or Project Professional:

This high-level hands-on program is specifically developed and delivered to help you, as a Project Professional, in your day to day tasks by using the sophisticated and advanced decision making tools that Excel has available to you. Once up to speed, you’ll let Excel do the work, helping you manage and deliver projects on-time and in budget. Projections, trends, problem areas become more obvious, easy to track, easy to report and easier to correct, all with Excel’s ability— and it’s at your disposal.