Microsoft Excel is the most commonly used spreadsheet application in the world. Excel can play a crucial part in your business, and is essential for producing accurate numeric data. The vast majority of businesses use Microsoft Excel every day to produce accounting and financial reports, budgets, and many more crucial numeric data tasks, but few appreciate the extent of the features and functions within the software. Excel holds hidden power for high-level analysis and complex reporting – it just has to be drawn out.
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.
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.
Workshop topics to be covered:
1. Developing and Working with Different Hands-on Dynamic Excel Templates
2. Reiterating the essential Excel basics
• Date Concept, Mysteries and Short-cuts
• Sum, SumIF, SumProduct, Countif, IF, VLOOKUP
• Format data cells
• Linking Worksheets and Workbooks
• Sort and filter columns of data
• Name cell ranges for easy access
• Translate text to columns
• Perform data validation
• Use of $ sign in formula
3. Conditional Formatting
4. Import External Data into your Excel Spreadsheet or Report
5. Pivot Table for Re-scrambling your Data Instantly
6. Create Scatter Diagrams and Trend Lines
7. Build an Statistical Process Chart for Process Control
8. Construct a Pareto Chart
9. Collaboration with MS Project Professional
10. PERT and Monte Carlo Analysis
The PERT estimation process is only a point estimate. This lecture will show you how to use the PERT as part of a Monte Carlo analysis to build a model of your probabilities. Based on the organization’s risk tolerance, the Monte Carlo will give a much more accurate risk picture than the PERT alone.