◆ Excel · forecast

Variance Checking

Run a monthly sensitivity check on payroll entries: compare this month's payroll to prior three months using SUMPRODUC…

2heights
2tasks
1roles do it

The same job, four heights

do it · improve it · decide · become
AExecute — “help me do it”Run a monthly sensitivity check on payroll entries: compare this month's payroll to prior three…+
Run a monthly sensitivity check on payroll entries: compare this month's payroll to prior three months using SUMPRODUCT to flag variances over 5% and trace precedents on any flagged formulas so unusual items are caught before payroll runs.
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed.
BImprove — “do it better”Prepare the sensitivity report for the payroll manager: present a variance table with…+
Prepare the sensitivity report for the payroll manager: present a variance table with department-level drill-down, list the top five changes with suspected causes, include a sensitivity matrix showing headcount versus rate changes, and mark items needing manual verification before approval.
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
Run a monthly sensitivity check on payroll entries to catch unusual variances before payroll is processed.

Who does this

1 roles
Executive Assistant

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.