Search: "excel finance model"

#pivot-table #debugging #totals

Diagnose Why a Pivot Table Is Showing the Wrong Totals

Help me diagnose why my Excel pivot table is showing wrong totals. Source data r...

#excel #pivot-tables #reporting

excel Beginner

Excel: Build a Pivot Table That Answers the Question Your Boss Actually Asked

I have a dataset and a vague question from leadership. Help me design a pivot ta...

#email #sales #cold-outreach

email Intermediate

Follow Up With a Prospect Who Ghosted After a Promising First Call

I had a great first sales call with a prospect three weeks ago. They were enthus...

#reconciliation #budget #fuzzy-match

Reconcile two versions of a budget when the row labels don't match

You are an Excel modeler. I'll paste two budget extracts from different teams. T...

#scenarios #modeling #choose

excel Advanced

Build a flexible scenario model without nesting IF statements ten layers deep

Act as a financial modeler reviewing my workbook. I have a model that runs base/...

#debugging #audit #trace-precedents

Find which formula in a 12-tab workbook is wrong without checking every cell

You're an Excel auditor. A summary total on my Dashboard tab is off by $4,200 fr...

#payment-terms #working-capital #negotiation

Decide whether to extend payment terms for a large customer asking for them

Act as a CFO. A large customer is asking us to extend payment terms from net 30 ...

#formulas #validation #helper-column

Build a formula that flags rows where two columns disagree

Act as an Excel expert. I have a spreadsheet where two columns should always agr...

#power-query #data-cleaning #pivot

Turn a messy exported report into a clean pivot-ready table

You're an Excel power user. I pasted in an export from another system and it's a...

#xlookup #index-match #robust

Write a lookup that survives someone reordering the columns

Act as an Excel expert. My VLOOKUPs keep breaking because colleagues insert and ...

#textjoin #reporting #plain-english

excel Beginner

Make a one-cell formula that summarizes a whole row in plain words

You're an Excel helper for non-technical users. I want a single formula that rea...

#budgeting #personal-finance #realistic

finance Beginner

Build a simple budget that survives contact with a real month

Act as a practical financial coach, not a strict one. Help me build a budget I w...

#excel #formulas #automation

excel beginner

Write Excel Formulas from Plain English

Act as an Excel formula assistant. I will describe what I want to calculate in p...

#excel #data cleaning #power query

excel intermediate

Clean Messy Excel Data Step by Step

Act as a data cleaning specialist. My Excel sheet has these issues: [list proble...

#excel #duplicates #countifs

Build an Excel formula that flags duplicates across multiple columns

In Excel I need to find rows that are duplicates based on a *combination* of col...

#finance #budgeting #personal finance

finance Beginner

Build a simple budget that survives a real month

Help me build a budget that doesn't fall apart the first time life happens. I'll...

#finance #decisions #comparison

Compare two financial options by the questions that matter

I'm deciding between two financial options (I'll describe them — could be lease ...

#finance #pricing #strategy

finance Advanced

Create a Simple Pricing Strategy for a Product or Service

Act as a pricing strategist for small businesses and freelancers. Help me set a ...

#excel #pivot-table #sales

Design a Pivot Table for Monthly Sales Analysis

You are an expert Excel reporting analyst. Guide me through building a pivot tab...

#hr #feedback #performance

hr Intermediate

Draft Constructive Performance Feedback

Act as an HR coach. Help me give feedback to a team member about [SITUATION]. Us...

#finance #financial-statements #ratios

Explain a Financial Statement in Plain Terms

Act as a finance tutor (informational only). I'll paste figures from a [income s...

#finance #comparison #decision-making

Compare Financial Options Side by Side

You are a finance educator (not giving advice). Help me compare these options: [...