Excel New _top_ — 3w1h Format In

Make the "When" column visually alert you if a deadline is approaching or passed.

You’ve probably heard of the 3W1H framework (What, Why, Where, How). It’s a powerful tool used in project management, incident reporting, and strategic planning. But did you know you can supercharge it with new Excel features like dynamic arrays, Power Query, and linked drop-downs? 3w1h format in excel new

| Who | What | When | How | | --- | --- | --- | --- | | John Smith | Sales Revenue | Q1 2022 | Online Sales | | Jane Doe | Units Sold | Q2 2022 | In-Store Sales | | John Smith | Sales Revenue | Q3 2022 | Online Sales | | Jane Doe | Units Sold | Q4 2022 | In-Store Sales | Make the "When" column visually alert you if

Here’s a feature for Excel (Microsoft 365 / Excel for web) that introduces a smart insight panel for data analysis. But did you know you can supercharge it

Chris Whitehead

Chris Whitehead is a tape drive repair and data storage expert based in Reading, Berkshire, providing tape drive repair and data storage solutions across the UK.