Search: "Excel analysis"

#finance #cash-flow #forecasting

finance Advanced

Build a 13-Week Cash Flow Forecast With Scenario Toggles

Walk me through building a 13-week cash flow forecast for a small business. Outp...

#excel #inventory #reorder-point

Excel Inventory Reorder Alert with Lead Time and Safety Stock

Build an Excel reorder-alert sheet for a small warehouse. Inputs (one row per SK...

#excel #loan #amortization

Excel Loan Amortization Schedule with Extra Payment Scenarios

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

Forecast Monthly Revenue with Seasonality Using FORECAST.ETS

Act as a financial analyst. I have 36 months of revenue history. Show me how to ...

#excel #forecasting #ets

#marketing #funnel #conversion

marketing Advanced

Audit a Marketing Funnel for Where Money Is Leaking

I'll share funnel data. Identify the worst-performing stage and propose the 3 mo...

#dates #iso #data cleaning

Convert Messy Excel Date Formats to Standardized ISO

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

#npv #irr #investment analysis

finance Advanced

Investment Decision Analysis Using NPV and IRR

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

#excel #reconciliation #bank

Reconcile Bank Statements with Ledger in Excel

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

#education #assessment #blooms-taxonomy

education Intermediate

Education: Write Test Questions That Measure Thinking, Not Recall

I need to write assessment questions for a unit. Make them measure understanding...

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

#exit-interview #turnover #retention

hr intermediate

Employee Exit Interview Framework to Reduce Turnover

Design an employee exit interview program for [company] to extract actionable tu...

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

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

#UX design #design brief #product redesign

design Intermediate

UI/UX Design Brief Template for Product Redesign Projects

Create a comprehensive UI/UX design brief for redesigning [product/feature, e.g....

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

#net-worth #personal-finance #balance-sheet

finance Beginner

Personal Net Worth Statement Template

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

#excel #pivot-table #calculated-field

ChatGPT Prompt: Excel Pivot Table Calculated Field for Custom Metrics

You are an Excel pivot table expert. Help me add a calculated field to my pivot ...

#net worth #personal finance #financial tracking

finance Beginner

ChatGPT Prompt: Personal Net Worth Statement Builder with Trend Analysis

Help me build a personal net worth statement and track changes over time. Here's...

#pivot tables #excel #data analysis

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

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

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

#excel #pivot-table #calculated-field

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 #dynamic-arrays #textsplit

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

#marketing #seo #content-brief

marketing Advanced

SEO Content Brief for a Bottom-of-Funnel Comparison Article

Write a complete SEO content brief for an article targeting '[Brand A] vs [Brand...