Search: "multiple-choice"

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

#excel formulas #dynamic arrays #dashboard

ChatGPT Prompt: Excel Dynamic Array Formulas for Reporting Dashboards

Build a reporting dashboard using Excel 365 dynamic array formulas (FILTER, SORT...

#coding #refactoring #clean-code

coding Intermediate

Refactor a God Function with Multiple Responsibilities

Below is a function that's grown to ~200 lines and does too much. Refactor it. R...

#duplicates #data cleaning #excel

Excel Formula to Detect Duplicate Records Across Columns

I need an Excel formula to detect duplicate records based on a combination of mu...

#nodejs #express #middleware

coding intermediate

Node.js Express Middleware for Request Validation and Logging

Build reusable Express.js middleware for a Node.js API that handles: 1) Request ...

excel intermediate

Excel SUMIF & COUNTIF: Advanced Multi-Criteria Formula Guide

Act as an Excel formula expert. I want to master SUMIF, SUMIFS, COUNTIF, and COU...

#excel #sumif #countif

customer-service intermediate

Customer Complaint Resolution Script Templates Multi-Channel

Create a complete customer complaint resolution script library for multiple chan...

#customer-service #complaints #scripts

#marketing #positioning #messaging

marketing advanced

Product Positioning Statement Writing Framework Differentiation Guide

Create a complete product positioning framework for SaaS and B2B companies. Cove...

#finance #startup #burn-rate

Startup Burn Multiple and Runway Health Check Dashboard

Build a one-page startup health dashboard from monthly P&L and balance sheet dat...

#chatgpt prompt for excel tracker #invoice aging #accounts receivable

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...

#finance #unit-economics #ltv

finance advanced

Unit Economics Analysis: LTV, CAC, and Payback Period

Act as a startup finance advisor and growth analyst with expertise in SaaS and s...

#npv #irr #investment analysis

Investment Decision Analysis Using NPV and IRR

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

#excel #dashboard #slicers

Excel Dashboard with Dynamic Slicers

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

#marketing #landing-page #hooks

marketing Intermediate

Write Three Different Hooks for the Same Landing Page

I have a landing page for [product/service, audience, primary CTA]. Here's the c...

#power query #excel #data combine

Excel Power Query Combine Multiple Sheets Into Master Table

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

👁 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

#burn rate #runway #startup

Startup Burn Rate Runway Analysis Investor Reporting Framework

You are a startup CFO. Build a burn rate and runway analysis for [STAGE / FUNDRA...

👁 7 views

#excel #goal-seek #solver

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

excel Advanced

Excel Goal Seek Alternative for Multi-Variable What-Ifs

I have an Excel model where multiple inputs affect one output and Goal Seek only...

#excel #data-cleaning #power-query

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

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

#excel #capacity-planning #modeling

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...

data Advanced

Write a Cohort Retention Query That Doesn't Secretly Double-Count Users

I need a SQL cohort retention query that groups users by their signup week and s...

#data #sql #cohort