Search: "Excel report"

#Excel #formulas #automation

Excel Intermediate

Excel Formula Generator

Create Excel formulas for: [DESCRIBE TASK]. Include: the formula, explanation of...

excel intermediate

Excel XLOOKUP Advanced Techniques Guide

You are an Excel expert. I need to use XLOOKUP for complex data retrieval tasks....

#excel #xlookup #lookup

#data #storytelling #presentation

data intermediate

Data Storytelling Report and Narrative Structure Framework

You are a data storytelling expert and communications consultant. I have analyze...

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

#dynamic arrays #FILTER #SORT

Excel Dynamic Arrays: FILTER, SORT, and UNIQUE Functions Mastery

Help me master Excel dynamic array functions to replace my manual filtering and ...

#stakeholder management #communication plan #project management

business Intermediate

Stakeholder Management Communication Plan Template

Help me create a comprehensive stakeholder management and communication plan for...

excel advanced

Excel Power Pivot Data Model for Cross-Table Business Analysis

Build a complete Excel Power Pivot data model for multi-table business analysis....

#excel #power-pivot #dax

#excel #lambda #custom-functions

excel advanced

Excel LAMBDA Function Custom Formula Library Creation Guide

Design a library of reusable custom Excel functions using the LAMBDA function fo...

excel beginner

Excel Formula Troubleshooter and Optimizer

I have an Excel formula that is not working correctly or returning unexpected re...

#excel #formula #debug

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

#data #ab-testing #bayesian

data Advanced

A/B Test Results Analysis With Bayesian Probability of Winning

Analyze the A/B test results below using a Bayesian approach. Output: probabilit...

#finance #financial-model #saas

finance Advanced

Three-Statement Financial Model for a Bootstrap SaaS Startup

Build a 36-month, monthly three-statement financial model (P&L, cash flow, balan...

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

#fp&a #financial-modeling #drivers

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

#excel #working-capital #finance-model

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

#power query #CSV import #data transformation

excel Advanced

Power Query: Merge and Transform Multiple CSV Files

I have a folder containing monthly CSV files (January.csv, February.csv, etc.) w...

#excel #xlookup #index match

excel Beginner

ChatGPT prompt for fixing broken Excel lookup formulas across multiple sheets

Act as a senior Excel troubleshooting expert. I have a workbook where lookup fo...

#email #data request #stakeholders

email Intermediate

ChatGPT prompt for writing a data request email that gets stakeholders to send the right files

Act as a business analyst who needs clean stakeholder input. I need an email re...

#budget variance report #excel finance analysis #accounting export cleanup

ChatGPT prompt for monthly budget variance report from exported accounting data

I need help turning exported accounting data into a monthly budget variance repo...

Excel Beginner

Budget Tracker Spreadsheet

Create a budget tracker Excel structure with: income categories, expense categor...

#Excel #budget #finance

productivity intermediate

Project Kickoff Planning Checklist: Deliverables, Milestones & RACI

Create a comprehensive project planning and kickoff package. My project: Projec...

#project-management #kickoff #raci

#pivot table #sales analysis #monthly report

Excel Pivot Table Report for Monthly Sales Analysis

Design a step-by-step guide for creating an Excel pivot table report to analyze ...

#xlookup #formulas #excel

Excel XLOOKUP Formula Builder for Multi-Criteria Match

Act as an Excel power user. I need an XLOOKUP-based formula that returns [RETURN...