3w1h — Format In Excel New

Suppose we want to analyze sales data for a company with multiple salespeople. We can use the 3W1H format to organize the data as follows:

Using this data, we can create a pivot table to analyze sales revenue by salesperson and quarter: 3w1h format in excel new

| Who | Q1 2022 | Q2 2022 | Q3 2022 | Q4 2022 | | --- | --- | --- | --- | --- | | John Smith | $10,000 | $12,000 | $15,000 | $18,000 | | Jane Doe | $8,000 | $10,000 | $12,000 | $15,000 | Suppose we want to analyze sales data for