◆ Excel · track

Expense Analysis

Identify which expense categories rose this quarter — build a PivotTable showing quarter-over-quarter spend by categor…

2heights
2tasks
1roles do it
See the prompt↓More track workflows

The same job, four prompts

do it · improve it · decide · become
AExecute — “help me do it”Identify which expense categories rose this quarter — build a PivotTable showing…+
Identify which expense categories rose this quarter — build a PivotTable showing quarter-over-quarter spend by category, rank the top 10 increases, and show amounts and percent change so I can instruct managers where to cut discretionary spend.
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed.
BImprove — “do it better”Before I ask managers to cut costs, make this analysis clear for the leadership team: add a…+
Before I ask managers to cut costs, make this analysis clear for the leadership team: add a slicer for department and a timeline for the quarter, flag categories with one-time items, show trend sparklines for the past four quarters and call out top three drivers of each big increase.
when the reply comes backPush once: ask it to sharpen the weakest part, and to say what it assumed.

How to do it

the tool · the steps · what to avoid
The tool
Conditional Formatting

Conditional Formatting in Excel automatically changes the appearance of cells based on criteria you define, helping you highlight important data, trends, and patterns.

  1. 1

    Select the cells or range of rows you want to format.

    NoteThis can be a single cell, a range (e.g., A1:E5), or an entire column.

  2. 2

    On the Home tab, in the Styles group, click Conditional Formatting.

  3. 3

    Click New Rule from the drop-down menu.

  4. 4

    In the New Formatting Rule dialog box, select a rule type.

    NoteCommon types include 'Use a formula to determine which cells to format' or 'Only format only top or bottom ranked values'.

  5. 5

    Enter your specific criteria or formula in the provided field.

    Best practiceFor budget tracking or expense analysis, use formulas to highlight over-budget items or spending anomalies.

  6. 6

    Click the Format button to choose your desired formatting style.

    NoteYou can set background color shading, foreground color shading (fonts), data bars, or icons.

  7. 7

    Click OK to apply the chosen format.

  8. 8

    Click OK again in the New Formatting Rule dialog box to create the rule.

  9. 9

    To manage multiple rules, click Conditional Formatting, then Manage Rules.

    NoteYou can change rule precedence using the up and down arrow buttons.

Use conditional formatting to instantly highlight important data for budget monitoring, financial comparison, and application monitoring thresholds.

Conditional Formatting can be automated and managed programmatically using VBA (Visual Basic for Applications) within Excel, allowing for dynamic rule creation and modification.

Glossary

words on this page
Conditional FormattingApplies specific formats to cells automatically when their values meet certain criteria.ExampleCells with sales figures below target automatically turn red, making underperforming regions easy to spot.
New Formatting RuleA command used to create a specific condition and its corresponding format for cells.ExampleYou can set cells to turn red if their value falls below a certain number.
PivotTableAn interactive table that summarizes and reorganizes selected columns and rows of data to show different views.ExampleYou can quickly see total sales per region by dragging and dropping column headers.

The real tasks

1 of them
Find which expense categories have creeped up this quarter so I can instruct managers to cut discretionary spend.

Who does this

1 roles
Finance Manager

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.