Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "excel formulas"

303 prompts matching "excel formulas"

"excel formulas" ✕ Clear all ✕
excel Advanced

Build a Cohort Retention Heatmap in Excel

I have customer signup and activity data in Excel. Help me build a monthly cohor...

#excel #cohort #retention
👁 10 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
👁 10 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
👁 9 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
👁 9 views
finance Beginner

Personal Net Worth Statement Template

Act as a personal finance planner. Build me a structured net worth statement tem...

#net-worth #personal-finance #balance-sheet
👁 9 views
excel Beginner

ChatGPT Prompt: Excel SUMIFS Formula Builder for Multi-Condition Aggregation

You are an Excel formula expert. I need to build a SUMIFS formula that totals va...

#excel #sumifs #formulas
👁 9 views
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
👁 9 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
👁 9 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
👁 9 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
excel Intermediate

Convert Messy Sales Data into a Pivot Table Report

You are an Excel expert. I will paste a messy sales dataset with columns for dat...

#excel #pivot tables #data cleaning
👁 9 views
excel Intermediate

Excel Dashboard with Dynamic Slicers

Help me design a single-page Excel dashboard for KPIs (revenue, orders, conversi...

#excel #dashboard #slicers
👁 9 views
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
👁 8 views
excel Intermediate

Excel Power Query Combine Multiple Sheets Into Master Table

You are an Excel Power Query specialist. Walk me step-by-step through combining ...

#power query #excel #data combine
👁 8 views
excel Advanced

Excel Power Query to Consolidate Monthly Sales Files in a Folder

Generate Power Query M code that consolidates all .xlsx files in a folder into a...

#excel #power-query #etl
👁 8 views
excel Intermediate

Excel Pivot Table Calculated Field for Margin Percentage by Segment

I have a sales table with columns: order_id, date, customer_segment, product, re...

#excel #pivot-table #calculated-field
👁 8 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
👁 8 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
👁 8 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
👁 8 views
excel Intermediate

Excel Sales Commission Tiered Calculator

Create an Excel formula that calculates sales commission using tiered rates: 5% ...

#excel #commission #sales
👁 8 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
👁 8 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
👁 7 views
finance Advanced

Financial Model Template for SaaS Business Unit Economics

Build a financial model framework for a SaaS business covering unit economics an...

#SaaS metrics #financial model #unit economics
👁 7 views
excel Intermediate

Convert Messy Excel Date Formats to Standardized ISO

I have a column of dates in Excel with inconsistent formats: '03/15/2024', '15-M...

#dates #iso #data cleaning
👁 7 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
👁 7 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval