Search: "Excel report"

Auto-Send Email Report VBA

Write an Excel VBA macro that: 1) Takes data from the active sheet, 2) Creates a...

#excel #VBA #macro

#excel cash flow forecast #13 week cash flow #excel formulas

ChatGPT prompt for Excel cash flow forecast from messy exports

You are an Excel analyst helping me build a 13-week cash flow forecast from mess...

#excel inventory tracker #reorder point #stock management

ChatGPT prompt for Excel inventory reorder tracker with lead times

Act as an Excel operations specialist. I need an inventory reorder tracker for a...

#excel #cash flow #forecast

ChatGPT Prompt for Excel Monthly Cash Flow Forecast with Collections Delay

I need a monthly cash flow forecast in Excel for a business with uneven customer...

#scenario model #financial modeling #excel planning

ChatGPT Prompt for Excel Scenario Model Comparing Best Base and Worst Cases

Help me build an Excel scenario model that compares best case, base case, and wo...

#finance #financial-model #startup

finance advanced

Financial Model for Startup Revenue Projections

Build a 3-year financial model for a [business type — SaaS / e-commerce / market...

#dynamic array #FILTER #SORT

excel intermediate

Excel Dynamic Array FILTER SORT UNIQUE Formula Guide

Teach me how to use Excel dynamic array functions (FILTER, SORT, UNIQUE, SEQUENC...

#excel #array-formulas #sequence

excel advanced

Excel Dynamic Array Functions SEQUENCE SORT FILTER

You are an Excel expert specializing in modern dynamic array functions. I want t...

excel intermediate

Excel VBA Macro Generator for Repetitive Tasks

I need to automate a repetitive task in Excel. Here is what I do manually every ...

#excel #vba #macro

#data cleaning #CSV #pandas

data Intermediate

Data Cleaning Checklist for Messy CSV and Excel Datasets

Create a systematic data cleaning checklist and workflow for a messy dataset in ...

#excel #cohort #retention

Build a Cohort Retention Heatmap in Excel

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

#conditional formatting #KPI #dashboard

Conditional Formatting Rules for KPI Dashboards

I need to set up conditional formatting in Excel for a KPI dashboard. My spreads...

#coding #bug report #issue ticket

coding Beginner

ChatGPT prompt for turning bug reports into a developer-ready issue ticket

Act as a product manager preparing issues for engineering. I will give you a me...

Coding Beginner

Bug Report Template Creator

Create a detailed bug report template that includes: reproduction steps, expecte...

#bug report #QA #testing

#writing #executive-summary #business-report

writing intermediate

Write an Executive Summary for a Business Report

Write an executive summary for the following business report: [paste key finding...

#finance #expense #cost-reduction

finance intermediate

Expense Report Analysis for Cost Reduction

Analyze the following company expense data to identify cost reduction opportunit...

Excel XLOOKUP Formula for Multi-Criteria Search

Help me write an Excel XLOOKUP formula that searches across multiple criteria. M...

#excel #xlookup #formula

#pbl #project-based-learning #high-school

education intermediate

Project-Based Learning Unit Plan for High School Students

Design a 4-week project-based learning unit for [subject and grade]. Include: 1)...

#education #rubric #assessment

education intermediate

Student Writing Rubric Design Criteria-Based Assessment

You are an experienced teacher and assessment design expert. I need to create de...

#data #power-bi #dashboard

data intermediate

Power BI Dashboard Design: Sales Performance Metrics

Act as a Power BI specialist and data visualization expert. Help me design a sal...

#data visualization #chart design #business intelligence

data beginner

Data Visualization Best Practices: Chart Selection and Design Guide

I have the following data and need to visualize it effectively: Data type: [desc...

#XLOOKUP #VLOOKUP #Excel formulas

Excel VLOOKUP to XLOOKUP Migration: Formula Modernization Guide

I have existing Excel spreadsheets that use VLOOKUP formulas and I want to moder...

#executive summary #business writing #report writing

writing Intermediate

Executive Summary Writing: Business Report Structure Guide

Help me write a professional executive summary for a business report. Follow thi...