| ID | What | Why | Who | How | |----|------|-----|-----|-----| | 1 | Reduce monthly software costs | Save 15% of IT budget | Finance lead (John) | Audit current subscriptions; negotiate renewal | | 2 | Launch customer feedback form | Improve product roadmap | Product manager (Sarah) | Use Google Forms; share link via email & app | | 3 | Migrate old files to cloud | Enable remote access | IT team | Move 100 GB to OneDrive; update shortcuts |
Once your structure is ready, This is the single most important step. It will give your table a name (like Table1 ), make it automatically expandable, and ensure all future formulas and references (including Copilot) work seamlessly. 3w1h format in excel new
Now, let's introduce consistency, a key to unlocking Excel's advanced features. | ID | What | Why | Who
A text column for clear, action-oriented descriptions. A text column for clear, action-oriented descriptions
The 3W1H format in Excel offers several benefits:
Next to it, use SUMIF to aggregate "How" (budget or hours) per "Why". This turns your task list into a strategic dashboard.
While you could document this on a whiteboard or a Word document, Excel provides several compelling advantages for modern problem management: