| Column | Name | Data Type | Formula Example (New Excel) | | :--- | :--- | :--- | :--- | | A | | Dropdown List | =INDIRECT("Table1[Owner]") | | B | What | Short Text | Manual | | C | Why (Priority Score) | Number (1-5) | =VLOOKUP(D2, PriorityTable, 2,0) | | D | How (Method) | Text with Validation | List: Agile, Waterfall, Ad-hoc | | E | How (Due Date) | Date | =WORKDAY(TODAY(), 14) | | F | How (Progress %) | Percentage | =MIN(1, (TODAY()-B2)/(E2-B2)) |
: In a new Excel sheet, set up your columns based on your preferred 3W1H variation (e.g., Task, Who, When, How ). Apply Formatting : Highlight headers and use Ctrl + B for bolding. 3w1h format in excel new
: Defines the core knowledge point, task, or problem (e.g., "Excel Filter" as an operation to isolate specific content). | Column | Name | Data Type |
78% of the drop is due to Product A’s shipment delay (correlation 0.89 with inventory data). 78% of the drop is due to Product