Search: "reporting"

#pivot-table #yoy #analysis

Pivot Table Refactor for Year-over-Year Analysis

Act as a financial analyst. Help me build a pivot table from [DATA RANGE] (colum...

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

#board meeting #board communication #executive reporting

business Advanced

ChatGPT Prompt: Board Meeting Pre-Read Document Structure

Create a structured board pre-read document for [COMPANY] for an upcoming board ...

#budget #variance #reporting

Excel Budget Variance Report with Conditional Logic

Build me a complete Excel budget vs actual variance report. I have monthly budge...

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

#client email #project update #status report

email Beginner

Professional Email Template for Client Project Status Update

Write a professional client-facing email template for weekly project status upda...

#excel #pivot table #sales analysis

Pivot Table Mastery for Multi-Year Sales Data Analysis

Act as an Excel data analyst. I will paste a sales dataset with columns Date, Re...

#legal #credit report #dispute

legal Beginner

Draft a Letter Disputing an Inaccurate Credit Report Item

Help me draft a formal letter disputing an inaccurate item on my credit report u...

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

#burn rate #runway #startup

finance Advanced

Startup Burn Rate Runway Analysis Investor Reporting Framework

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

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

#email #change-management #internal-communication

email Intermediate

Announce a process change people didn't ask for without sounding tone-deaf

We're rolling out a new expense reporting tool next month. The current process w...

#excel #variance-analysis #budget

Excel Variance Analysis Budget vs Actual

Build an Excel variance analysis report comparing Budget vs Actual for revenue a...

#rolling #trend #dynamic-range

Excel: Build a Rolling 12-Month Revenue Trend Without Hardcoded Dates

I want a chart that always shows the last 12 months of revenue — so when I add M...

Build a Weekly KPI Dashboard in Excel That Doesn't Break When Someone Renames a Tab

I'm building a weekly KPI dashboard in Excel for a small operations team. The so...

#excel #dashboard #kpi

#excel #dashboard #formulas

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

finance Advanced

Translate the P&L into a one-page story a non-finance executive will read

Act as a controller. Translate our [PERIOD] P&L into a one-page narrative for no...

#finance #reporting #pnl

Excel: Write a VBA Macro That Emails a Filtered Report to Each Manager

I have a master sheet with sales data tagged by manager. I want a VBA macro that...

#excel #vba #automation

#excel #pivot-tables #executive-reporting

Excel: Turn a Pivot Table Into Something an Executive Will Actually Read

I built this pivot table: [PASTE STRUCTURE OR SCREENSHOT DESCRIPTION]. It's accu...

#pivot tables #dashboard #monthly report

excel Beginner

Turn a flat sales export into a one-screen monthly summary

I have a sales export with columns: order_id, date, region, sales_rep, product_c...

#cfo #board-update #reporting

finance Advanced

Write a Board-Ready CFO Update in Under 500 Words

Act as a CFO writing the monthly update to the board. Produce a 500-word maximum...

#excel #power-query #office-scripts

Automate a weekly Excel report that pulls from three CSVs and emails itself

You are an automation engineer. I get three CSVs every Monday — [CSV_1], [CSV_2]...

#finance #variance #reporting

finance Intermediate

Explain a budget variance without listing every line that moved

We closed [period]. Spend was [over / under] budget by [%]. Leadership wants an ...