MS Excel is a great tool to create basic or very well detailed flow charts.
In this video I will show you how to create flow charts from scratch and using a template that can give you a jump start.
All tutorials
In this video we will go over what are Check Sheets, the advantages of using them, what are the most common types of Check sheets, and we will create an example together.
In this video I will show you how to create a simple Check Sheet from scratch and i’ll show you how to use templates that give you a jump start.
What would you do when you have identified defects are coming from different sources and you have limited resources to solve all of them?
That’s a complicated situation. If you have a case like this a Pareto chart will be your best option, this quality tool will help you to focus on the sources or factors that matter the most.
In this video we will cover:
what is a Pareto Chart,
when and why to use a Pareto chart,
what are the steps to build a Pareto chart and
we will create one example together.
Have you ever try to pull data from a spreadsheet using a lookup formula with more than one matching condition and don’t know how to get it to work? Then this video is for you, I will show how to create a lookup formula with multiple conditions using Index and Match functions
#exceltutorial #exceltips