◆ Excel · formulas

Decision Table

Design a decision table that maps proposed product changes to required notification type using nested logic, INDEX/MAT…

2heights
2tasks
1roles do it

The same job, four heights

do it · improve it · decide · become
AExecute — “help me do it”Design a decision table that maps proposed product changes to required notification type using…+
Design a decision table that maps proposed product changes to required notification type using nested logic, INDEX/MATCH lookups and a named range so reviewers can determine the correct regulatory path quickly.
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed.
BImprove — “do it better”To reduce reviewer hesitation, create a decision table with clear inputs and outputs: map…+
To reduce reviewer hesitation, create a decision table with clear inputs and outputs: map change type, impact and region to the notification category using INDEX/MATCH, include an explanation column citing the regulation paragraph, highlight ambiguous cases for legal review, and add example scenarios to guide users.
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed.

The real tasks

1 of them
Design a decision table that tells reviewers which type of regulatory notification is required when a product change is proposed.

Who does this

1 roles
Regulatory Affairs Analyst

Questions people ask

honest answers

Because you rarely think 'I want the redaction tool'. You think 'I have to share this without leaking the client's details'. Start from the need, and the feature finds you.

Real. Every job here was drawn from what people in real roles were actually seen doing in Excel — not a feature checklist.

No. Each page gives you a ready prompt you can paste into an AI assistant, plus the plain steps to do it yourself. Start with either — the goal is the finished job, not the tool.