COURSE 4785 | 2-DAY SESSION
Power Excel

---

Course Details:

Many attempt to use the Help screens supplied with Excel to understand and utilize the statistical functions in Excel only to discover they are more confused after reading Help!

We eliminate the confusion and provide simple yet effective method for achieving results immediately.

Quickly identify and correctly use Excel statistical functions

There are a number of statistical functions in Excel that are explained in the
Excel Help Guide, but the help is only useful if you already know how the functions
work and what they mean!! This course outlines these critical functions
and allows you to instantly grasp what the functions do and how to put them to
use. No math or statistical pre-reading knowledge is required - let Excel do the
crunching for you. All you need to learn is how to put the functions to use.

Learn how to use, apply and create statistical process charts to accurately measure your project processes

Most projects require that data is collected so that accurate metrics can be charted and analyzed to determine if the project;

• Is on track
• Is delivering the expected result and meeting user requirements
• Is in danger of becoming over budget and/or behind schedule
• Can be remediated if there are variances in timeline, budget or quality
  

Most, if not all of these process charts are not included in the Excel chart wizard - they have to be created from scratch. This course provides standard templates for all standard Statistical Process Control charts that can be customized by the user for any situation. Simple instructions and practice exercises on how to customize and make chart modifications are included in the course.

Practice the use of Excel tools and techniques to become immediately productive

You will get hands-on experience in using the functions in Excel that will help you and your team become productive immediately. Discover how to:

• Protect elements in a worksheet
• Use the formula auditing bar
• Master the Goal Seek function
• Effectively use the Data Analysis Toolbox
• Add VBA functions to your spreadsheets and presentations
• Use Smart Tags capability to add sizzle to your reports
• Apply the Auto format function for ‘instant’ report formatting
• Master the use of statistical functions such as: BETADIST, BINOMDIST, CHIDIST, CHIINV, CHITEST, EXPONDIST, FTEST, FINV, NORMDIST, NORMINV, NORMSDIST, NORMSINV, HYPGEOMDIST, STDEV, TDIST, TINV, VAR, ZTEST
• Instantly perform complex data sorts using the AutoFilter function
• Dynamically rearrange and sort large data set for analysis using PivotTables

In-Class Workshops and Exercises:

• Practice how to set up Excel formulas quickly
• Explore how to correctly use the Data Analysis tool
• Practice how to customize charts
• Instantly learn how to set up Monte Carlo functions from scratch
• Identify and implement the functions that accurately define your project timeline
• Improve your project estimation skills
• Understand and mitigate project risks consistently and effectively
  
• Mitigate cross functional impacts on your project
  
• Instantly compute project schedule ‘Merge Bias’
  
• Improve your decision making process through the correct use of statistical tools
  
• Focus your project team on the essential data and facts that will ensure project success
  
• Discover how to use probability functions to realistically estimate project success
  
• Utilize the proper analysis tools to deliver accurate and timely estimates to management