Advanced analysis tools for maximum performance: Achieve the best results with less resources through better planning, management and decision making. Become a turbocharged project manager! This course will teach you immediate skills for:

• 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

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!