Installation and SetupInstallation - Each User Installation - Multi-user Language Translations Personalize Your Templates
Systems2win TrainingQuick Start Initial Training New User Training Training Matrix Systems2win Leadership Training Classes
Lean TrainingLean Training and Coaching Lean Principles Muda 8 Wastes Goal - Lean Flow Roadmap - Lean Journey Value Stream Mapping Standard Work Hansei Lean Thinking Lean Dictionary Online Lean Training Lean Leadership
CustomersOperational Excellence Lean Manufacturing Lean Office and Service Lean Healthcare Customer List
In this video, you will learn how to use your Systems2win FMEA template in ways that allow you to use Excel's powerful features for Filter and Pivot Tables.
Topics in this Video
Primary training page for FMEA template
Cells that look like blank or merged cells - aren't
thereby enablilng Excel Filter and Pivot Table features
1) Scroll down below Print Area to find help for which columns do and do not require Repeat Data
2) For columns that need Repeat Data, Copy the top row of a section, and simply Paste to all other rows in that column for that section. (and notice how the cells get automatically formatted to look to a human eye or a printer like they are merged cells — but they're not
Use the button to 'Fix Row Heights'
In the Function column, if the background color turns pink, then 1 of 2 things is wrong
If you don't yet own a license...
Download Free Trial
Download a dozen free trial
Own Yours Now
Own All 150+ Templates for
Continuous Process Improvement
For Closed Captions translated into any language,
watch this YouTube version of this same FMEA training video
FMEA Magic - Repeat Data