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…)

Excel Absolute and Relative Cell References and Autofill Function【Data Analysis Excel Skill】

You can learn the differences in Absolute and Relative Cell References with case study examples. Mastering Cell References increases your work speed greatly.

 

(Duration: 6:49)

 

<< Related Posts >>

(more…)

For the PDCA Cycle, which one would you use, an Ad Hoc Analysis or a Pre Set Analysis?

Ad Hoc means “for this” or “for this situation” in Latin. Ad Hoc Analysis is an analysis for a temporary and particular situation done without preparation and in a short time. On the other hand, what’s Pre-Set Analysis?

 

(Duration: 5:28)

 

<< Related Posts >>

(more…)

DMAIC: 4 Steps of the Improve Phase – vol. 2 【How to make a transition plan】(Lean Six Sigma)

This post explains DMAIC’s Improve Phase – 2 of 2. Step 3 is “Make a transition plan to move to the new process smoothly.” Useful tools for that are the WBS (Work Breakdown Structure) and Gantt Chart. With an Excel Gantt Chart, by using two Excel functions – ‘Hyperlink’ and ‘Inserting Object’.

(Duration: 5:48)

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

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

 

<< Related Videos >>

(more…)