Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "formulas"

186 prompts matching "formulas"

"formulas" ✕ Clear all ✕
excel Intermediate

Reconcile two Excel sheets that almost match but disagree on a few rows

You are an Excel reconciliation specialist. I have two sheets — Sheet A (System ...

#excel #reconciliation #xlookup
👁 12 views
marketing Intermediate

Email Marketing A/B Testing: Subject Line Optimization Guide

Help me design and run effective A/B tests for my email marketing campaigns. I n...

#email marketing #A/B testing #subject lines
👁 11 views
excel Advanced

Excel VBA Macro to Automate Repetitive Report Formatting

Write an Excel VBA macro that automates the formatting of a weekly report I rece...

#VBA #macro #automation
👁 11 views
finance Intermediate

Personal Cash Flow Forecast for Next 12 Months

Build a 12-month personal cash flow forecast. Inputs: - Monthly net income: [AMO...

#cash flow #personal finance #budgeting
👁 11 views
excel Advanced

Reconcile Two Bank Statements with Fuzzy Matching in Excel

I have two sheets: 'Bank' with columns Date, Description, Amount and 'Books' wit...

#excel #reconciliation #fuzzy match
👁 11 views
excel Intermediate

Excel: Untangle a Column Where Multiple Fields Got Stuffed Into One

I have one column containing several fields concatenated together (name, email, ...

#excel #data-cleaning #power-query
👁 11 views
excel Intermediate

Build a self-updating sales dashboard using only formulas (no PivotTables)

I want to build a sales dashboard in Excel that updates automatically when I pas...

#excel #dashboard #formulas
👁 11 views
excel Intermediate

Build a Rolling 12-Month Cash Flow Forecast in Excel

You are an Excel financial modeling expert. Help me build a rolling 12-month cas...

#excel #cash flow #forecast
👁 11 views
excel Intermediate

ChatGPT Prompt for Building an Excel Cash Collection Tracker from Invoices

Act as an expert Excel analyst for accounts receivable. Help me build a cash col...

#chatgpt prompt for excel tracker #invoice aging #accounts receivable
👁 10 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
excel Beginner

Excel Personal Budget Tracker: Monthly and Annual Template

Help me build a comprehensive personal budget tracker in Excel from scratch. I n...

#budget tracker #personal finance #Excel template
👁 10 views
finance Intermediate

Build a Runway Calculator With Burn Sensitivity

Help me build a runway calculator with sensitivity analysis. Inputs: current cas...

#finance #runway #burn rate
👁 10 views
excel Advanced

Audit a Workbook for Broken Formulas and Hidden Dependencies

I inherited a 30-sheet Excel workbook and it gives slightly wrong totals. Walk m...

#excel #audit #formulas
👁 10 views
excel Intermediate

Excel: Convert a Messy Paste-from-PDF Table Into a Clean Dataset

I pasted a table from a PDF and Excel split it badly — values are stuck together...

#excel #power-query #data-cleaning
👁 10 views
excel Intermediate

Build a Running Total in Excel That Resets Every Month Without a Pivot Table

I'm working in Excel with a table that has a Date column and an Amount column. I...

#excel #formulas #running-total
👁 10 views
excel Intermediate

Clean up a sheet where dates are stored in five different formats

I inherited a spreadsheet where the 'Date' column has dates entered as '3/5/26',...

#excel #data cleaning #dates
👁 10 views
excel Intermediate

Decide when to use Power Query vs formulas vs a real database

I keep solving the same data problem three different ways across my team's sprea...

#excel #power query #decision
👁 10 views
excel Intermediate

Reconcile two lists that should match but somehow never do

You are an Excel power user. I have two lists in Excel that are *supposed* to be...

#excel #vlookup #reconciliation
👁 10 views
excel Intermediate

Replace nested IFs with a clean LET formula that future-you can read

You are an Excel formula refactorer. Here is a nested IF formula that works but ...

#excel #let-function #formulas
👁 10 views
finance intermediate

Financial KPIs Dashboard for Startup Founders

You are a startup CFO advisor. I need to build a financial KPIs dashboard that g...

#finance #kpis #startup
👁 9 views
excel Intermediate

Excel: Replace a Wall of Nested IFs With One Clean SWITCH or IFS

I have a nested IF formula that's grown unmaintainable. Rewrite it using SWITCH,...

#excel #formulas #switch
👁 9 views
excel Intermediate

Excel: Diagnose Why a Slow Workbook Takes 30 Seconds to Recalc

My Excel workbook recalculates painfully slowly and I don't know which sheet or ...

#excel #performance #formulas
👁 9 views
excel Intermediate

Excel: Fix the Formula That Works Until It Doesn't

Here's a formula that works on most rows but breaks on a few: [PASTE FORMULA AND...

#excel #formulas #debugging
👁 9 views
excel Intermediate

Excel: Clean a Messy Address Column Without Losing Edge Cases

I have a column of free-text addresses scraped from a form: [PASTE 20 SAMPLES]. ...

#excel #power-query #data-cleanup
👁 9 views
excel Intermediate

Audit a spreadsheet a predecessor built before you trust a single number

I inherited an Excel model from someone who left. I need to know if I can trust ...

#excel #audit #inherited-model
👁 9 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval