Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "formulas"

186 prompts matching "formulas"

"formulas" ✕ Clear all ✕
excel Intermediate

Forecast Monthly Revenue With Excel's FORECAST.ETS

I have 36 months of revenue data (column A: month-end dates, column B: revenue)....

#excel #forecasting #revenue
👁 14 views
excel Intermediate

Build a Reusable Excel Template With Input Validation Built In

Help me design a reusable Excel template for [USE CASE: e.g. expense report, pro...

#template #data-validation #conditional-formatting
👁 14 views
excel Advanced

Excel: Build a Capacity Model That Doesn't Pretend Everyone Works 40 Hours

I'm modeling team capacity in Excel for the next quarter: [TEAM, ROLES, HOLIDAYS...

#excel #capacity-planning #modeling
👁 14 views
excel Intermediate

Replace nested IFs with a lookup table you can actually maintain

I have a worksheet with nested IF formulas like: =IF(A1="Bronze",0.05,IF(A1="Sil...

#excel #formulas #xlookup
👁 14 views
excel Intermediate

Turn a wide budget sheet into a flexible pivot-ready long format

I have a budget spreadsheet in wide format: one row per account, then 12 columns...

#excel #power-query #unpivot
👁 14 views
excel Advanced

Invoice Generator with Auto-Numbering VBA

Create an Excel invoice generator with automatic invoice numbering using VBA. B...

#invoice #VBA #automation
👁 13 views
excel intermediate

Excel Pivot Table Sales Trend Analysis

I have a sales dataset with columns: [Date, Region, Sales Rep, Product, Units So...

#excel #pivot-table #sales
👁 13 views
finance Advanced

Cash Flow Forecast 13-Week Rolling Model Small Business

You are a fractional CFO. Build a 13-week rolling cash flow forecast for [BUSINE...

#cash flow #forecasting #cfo
👁 13 views
education Beginner

Concept Map Builder for Difficult Topic

Act as a learning coach. Help me build a concept map for [TOPIC]. Produce: (1) t...

#concept-map #study #visualization
👁 13 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
excel Intermediate

ChatGPT Prompt: Excel Pivot Table with Calculated Fields and Slicers Setup

Help me build a comprehensive pivot table report for [DATA TYPE]. Data context:...

#pivot tables #excel #data analysis
👁 13 views
excel Intermediate

Build a Dynamic Commission Calculator With Tiered Rates in Excel

I need an Excel commission calculator that supports tiered rates (e.g. 5% on the...

#excel #formulas #commission
👁 13 views
excel Intermediate

Excel Loan Amortization Schedule with Extra Payment Scenarios

Create an Excel amortization schedule for a fixed-rate loan with these inputs at...

#excel #loan #amortization
👁 13 views
excel Intermediate

Build a Dynamic Dashboard Using INDEX-MATCH and Slicers

Act as an Excel power user. I have a sales dataset with columns: Date, Region, P...

#excel #dashboard #index-match
👁 13 views
finance Advanced

DCF Valuation Walkthrough for a Mid-Size Company

Walk me through a 5-year discounted cash flow valuation of [COMPANY] with curren...

#finance #dcf #valuation
👁 13 views
excel Intermediate

Build a Dynamic Project Burn-Down Chart in Excel

Act as an Excel expert. I need to build a project burn-down chart that automatic...

#excel #burn-down #project management
👁 13 views
finance Advanced

Build a Driver-Based Financial Model from Scratch

Act as a senior FP&A modeler. Walk me through building a driver-based financial ...

#fp&a #financial-modeling #drivers
👁 13 views
excel advanced

Build a working capital model from a P&L extract without manual joins

Act as a finance analyst. I will paste a monthly P&L extract plus a trial-balanc...

#excel #working-capital #finance-model
👁 13 views
finance advanced

13-Week Rolling Cash Flow Forecast Model Template

You are a CFO advisor and financial modeling expert. I need to build a 13-week r...

#finance #cash-flow #forecast
👁 12 views
writing intermediate

LinkedIn Thought Leadership Post Writing Framework and Templates

Create a complete LinkedIn thought leadership content system for executives and ...

#writing #linkedin #thought-leadership
👁 12 views
excel Advanced

Excel Dynamic Array Formula to Split Comma-Separated Tags into Columns

I have column A filled with comma-separated tags like 'urgent, vip, refund, bill...

#excel #dynamic-arrays #textsplit
👁 12 views
finance Advanced

Investment Decision Analysis Using NPV and IRR

Analyze this investment opportunity using NPV and IRR: - Initial investment: [AM...

#npv #irr #investment analysis
👁 12 views
excel Intermediate

Reconcile Bank Statements with Ledger in Excel

I have two Excel sheets: my bank statement transactions and my internal accounti...

#excel #reconciliation #bank
👁 12 views
excel Intermediate

Build a Sales Pipeline Velocity Tracker in Excel

Act as an Excel expert. I want a single-sheet pipeline velocity tracker. My deal...

#excel #sales #pipeline
👁 12 views
excel Advanced

Excel: Two-Way Sensitivity Table Without the Data Table Feature

Excel's built-in Data Table feature recalculates the whole workbook and freezes ...

#sensitivity #what-if #modeling
👁 12 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval