3w1h Format In Excel New Fixed Access

Instead of manually sorting your Who/What/Why/How, let Excel do the work.

The "What" captures the core event, item, or financial metric being measured. 3w1h format in excel new

┌────────────────────────────────────────────────────────┐ │ 3W1H EXCEL BLUEPRINT │ ├─────────────┬─────────────┬─────────────┬──────────────┤ │ WHO │ WHAT │ WHEN │ HOW │ │ (Entities) │ (Metrics) │ (Timeline) │ (Attributes) │ └─────────────┴─────────────┴─────────────┴──────────────┘ The Four Pillars of 3W1H in Excel 1. Who (The Entities) Instead of manually sorting your Who/What/Why/How, let Excel

| Column A | Column B | Column C | Column D | Column E | Column F | Column G | Column H | | :--- | :--- | :--- | :--- | :--- | :--- | :--- | :--- | | | Date Logged | Reported By | WHAT (Problem) | WHY (Cause) | WHERE (Location) | HOW (Solution) | Status | Who (The Entities) | Column A | Column

In your Excel table, you can now: