Prioritization Matrix: Objectivity in Decision Making
Prioritization Matrix is a decision-making tool and is one of the seven management and planning tools used in Six Sigma and Quality Management in general. It is used to determine…
Posted inPower of Microsoft Office Six Sigma
Creating Pareto Chart in Microsoft Office Excel
During the Define step of a Six Sigma project the project team needs to identify the problem or the opportunity that the project is intended to solve. Usually, there would…
Posted inPower of Microsoft Office
Calculate Loan Terms using Goal Seek in Microsoft Excel
Goal Seek feature in Microsoft Office Excel is used to find out the correct input value to a formula in order to get a desired formula result. This video shows…
Posted inPower of Microsoft Office
Summarize your data with PivotTables
A PivotTable report is an interactive way to quickly summarize large amounts of data. In this video I will show you how to create a summary report using PivotTable in Microsoft…
Posted inProject Management
Project Leadership: The Latent Power of Success
Increased complexity in contemporary projects puts a heavy burden on the project management profession. Project Managers do no longer have the luxury to be task-oriented only; they need to evolve…
Posted inProject Management
Work Breakdown Structure Made Easy
“Would you please help me print out this ‘WBS’? It won’t fit in one page. I have a status meeting with the Sponsor in 30 minutes!” a colleague of mine…
Posted inSix Sigma
Organizational Culture: a Six Sigma success driver
Joyce Wycoff in his book “Transformation Thinking” says: ‘When an organization commits to creating an environment which stimulates the growth of everyone in the organization, amazing things start to happen:…
Posted inPower of Microsoft Office
Best practice to VLookup values in Excel
Vlookup is a function that helps you search for a value in a range of cells and return the same or a different value from that range on the same…
Posted inPower of Microsoft Office
Customize Excel Ribbon and make your macros default commands
I believe that efficient use of Microsoft Office Excel has a tremendous effect on office work efficiency. With this blog I start a series of powerful tips and tricks that…
Posted inProject Management
The indispensable Quality couple
Most companies realize the ever-existing conflict between Quality Control and Production functions, but unfortunately, very few have realized or thought of the function that bridges the gap between them, namely…