Excel Macro and VBA: Fundamental Basics (Record Macro Button and VBE)

This article is about Excel Macro fundamental basics and explains how to use the ‘Record Macro’ button, how to edit the codes and save the file with Macros in a step-by-step way.

(Duration: 7:41)

 

<< Related Posts >>

(more…)

How to Use Excel Pivot Table 【Screen Demonstration】

This article explains source data formats for a Pivot Table, each section of the Pivot Table’s work screen – the Field List – and demonstrates the elemental steps needed to make a Pivot Table on the Excel screen. You’ll be able to start making your own Pivot Table after reading this article.

(Duration: 7:11)

 

<< Related Posts >>

(more…)

What’s Toyota’s Jidoka (Autonomation)?

This article introduces about the origin of Jidoka and Andon that was evolved from Jidoka.  It also will explain the difference between Autonomation and Automation and the substance of Autonomation.

 

(Duration: 5:47)

 

<< Related Posts >>

(more…)

How to brainstorm effectively and summarize results【Excel Template】

This article is about how to brainstorm effectively and summarize the generated results. You can have successful brainstorming by practicing the 4 Guidelines in this article. It also introduces Osborne’s checklist that expand the generated ideas.

 

(Duration: 6:41)

DOWNLOAD  ← Click this to download the “Brainstorming” template file.

 

<< Related Posts >>

(more…)

How to Prevent Human Errors that Poka Yoke doesn’t affect

This article is about how to prevent Human Errors that Poka Yoke doesn’t affect. People’s actions always go through ‘Perception’, ‘Judgement’ and ‘Action’. This post explains major causes and solution ideas in each stage.

 

(Duration: 8:06)

 

<< Related Posts >>

(more…)

What is Standard Deviation? There are too many Excel functions for Standard Deviation!

This article explains ‘What Standard Deviation is’, ‘Why it’s needed’, and differences between ‘Population’ and ‘Sample’. Also, there are several Standard Deviation Excel functions. You can learn which one you should use.

 

(Duration: 8:52)

 

<< Related Posts >>

(more…)