All tutorials

MS Excel: How to format PivotTable and re-use with new files

In this video I will show how you can give format to your PivotTable. And how you can re-use that pivot table in other files. For example, if you have a weekly or monthly report this can help you reduce the time you spend formatting your pivottable from scratch.

MS Excel: How to create a re-usable template

In this video I will show you how to create a reusable template using two applications: Microsoft Word or Microsoft Excel. We will see the differences between the two applications and you can decide which works best for you.

MS PowerPoint: How to use the slide master

In this video i will show you how to use the slide Master in Power Point. The slide master helps you to define your own format for different types of slides that you can use in your presentations.

MS Excel: How to add up values from text strings

In this video I want to show you a solution that i put together for a user request. This user had data for years and months but were type in the same cell as a text string. The request was to come up with a formula to add up the years and the months.
7 quality tools of quality

The Seven Basic Tools of Quality

In this video I will introduce you to the seven basic tools of quality. These tools were first introduce by Kaoru Ishikawa , a professor of engineering at the Tokio university who was the father of what we know as “quality circles” Ishikawa sustained that 95% of quality problems can be solve with seven fundamental tools.

What is a Flow Chart?

In this video I will give an overview of what are flow charts, why they are important, what are the symbols of basic elements of a flow chart, how do we create a flow chart and we will create an example together.