This project management training course teaches you:
- Using pivot tables
- Automating Function Keys
- Regression and trend analysis
- Statistical Process Charts
- Sophisticated data analytics
- Scatter Diagrams
- Using data analysis add-in
- PERT and Monte Carlo Analysis
- Using Ppk and Cpk
- Creating Pareto Charts
- Calculating process control limits
Bonus CD: Those attending will receive an instructor-developed CD loaded with analytical tools, resources and customized templates .
Unleash the Power of Excel — Create High Performance Tools to Ensure Your Success as a Project Manager
Excel has long been a well established tool, used by most for rudimentary functions, not much more than simple spreadsheets and basic calculations. Excel holds hidden power for high-level analysis and complex reporting – it just has to be drawn out. As a Project Manager you have the capability of using Excel to easily help you in your day to day decision making on many levels. This hands-on workshop will help you create those tools, charts, graphs and projections that will become a key factor in your continued success.
The sophisticated reporting you need made simple
In two days, Project Managers will have the ability to create the customized charts, analytic tools and projection systems you need for any short and long range management objectives. You will get right to the good stuff – covering in detail the commands and capabilities that are available to you in Excel. You'll understand how function keys and tool bars can do much more than you thought and how simple setup and construction options can help you easily create complex tables, charts and projections. You'll also see how Excel can help simplify tasks such as sorting large volumes of data with accuracy and importing outside data with ease. You will know how to create formats and data sorts that fit your needs as a Project Manager— the reliable tools to make your job a bit easier.
Reliable Tools and Analysis — Excel does the work!
From constructing a Monte Carlo analysis and statistical process charts to using pivot tables, you'll create and use the reporting and analysis functions you need for any type of sophisticated reporting and analysis. What's more, you'll have dozens of practical options at your disposal and know the best analytical tool to use for your environment. As a project manager, you have enough on your plate, let Excel do the work!
Create the Management Tools and Build Excel Skills!
In this project management training course, 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 project management training course ready to get hands-on with Excel
This project management training 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 project management training 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 Project Management Training Course
- Discover trends in data and reports for risk analysis and forecasting by creating a regression/trend analysis
- Identify key process/product improvement opportunities as well as perform root cause analysis
- Determine and manage risks in project schedules and define confidence factors
- 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
- Model key business processes and be able to perform sophisticated optimization analyses
- Calculate process control limits and superimpose customer specification limits, determine if process is meeting customers needs
- Identify potential issues or showstoppers in data and be able to identify potential risk triggers
- Know the ins and outs of pivot table creation, validate, consolidate, convert, sort and filter your data
- Automate your repeatable processes, using macros to create reports and data analysis charts, instantly
- Trace Precedents and Dependents to analyze cascading formulas and troubleshoot spreadsheet issues
- Quickly analyze data and create reports using the key financial, math and statistical functions of the Function Library
- Easily format external data using "Get External Data" Functions, automate this function for repeatable processes
- Create sophisticated data analytics through the use of one- and two- way ANOVA
- Secure workbooks and cells, know how to lock down critical formulas to prevent altering of key computation or data fields
- Determine needs, causes, effects and anticipated results of a project, implement the most cost effective process improvement actions, using analysis charts
- Learn to quickly and accurately audit formulas through your complex spreadsheets, troubleshoot precedents and successor processes
- Build a customized analysis model based on your firms probabilities and risk tolerance, gain an accurate tool to determine your companies risks
- Modify report formats to meet the needs of specific management and department heads using the multitude of data formatting options in Excel
