📊 Excel & Spreadsheets Prompts

Formulas, reports, pivot tables, charts, VBA macros

79 prompts available

All Excel & Spreadsheets 79 Formulas & Functions 10 Reports & Templates 5 VBA & Macros 4 Financial Modeling 3 Formulas 3 Pivot Tables & Analysis 3 Dashboards & Visualization 2 Excel Formulas & Functions 2 inventory management 2 pivot-tables 2 Automation 2 dashboards 2 Power Query 2 Project Management 2 Financial Modeling & Analysis 1 Power Query & Data Transformation 1 Dashboards & Reporting 1 Array Formulas 1 Lookup & Reference 1 What-If Analysis 1 Scenario Planning 1 Data Validation 1 Finance 1 Operations Scheduling 1 budget analysis 1 financial reporting 1 Templates 1 Scheduling & Planning 1 Revenue Analysis 1 Audit 1 Analysis 1 Financial Planning 1 Data Cleaning 1 Financial Tracking 1 Formatting 1 Charts & Visualization 1 Data Management 1 Operations Planning 1 financial forecasting 1 data reconciliation 1 hr tracking 1 Finance Tracking 1 Analytics 1 sales operations 1 formula troubleshooting 1 VBA & Automation 1 Power Query & Automation 1

Showing 79 prompts

budget analysis Intermediate

ChatGPT prompt for monthly budget variance report from exported accounting data

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

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

👁 3 views Open →

Finance Tracking Intermediate

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

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

👁 3 views Open →

Revenue Analysis Advanced

ChatGPT Prompt for Creating an Excel Subscription Revenue Waterfall

Act as a finance analyst who specializes in subscription businesses. Help me bui...

#chatgpt prompt for MRR waterfall #subscription revenue #excel finance model

👁 3 views Open →

Analytics Advanced

ChatGPT Prompt for Excel Cohort Retention Tracker from Raw Transactions

I have raw transaction data in Excel with columns for customer_id, first_purchas...

#excel #cohort analysis #retention

👁 3 views Open →

Finance Beginner

Budget Tracker Spreadsheet

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

#Excel #budget #finance

👁 3 views Open →

formulas beginner

VLOOKUP vs INDEX-MATCH: Smart Data Lookup Formulas

I need to retrieve data from a lookup table in Excel. My main table has [column ...

#excel #vlookup #index-match

👁 3 views Open →

vba-macros Advanced

Excel Macro to Automate Monthly Report

Write a VBA macro for Excel that automates my monthly reporting process. The mac...

#excel #vba #macro

👁 3 views Open →

Formulas & Functions intermediate

Excel Dynamic Array FILTER SORT UNIQUE Formula Guide

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

#dynamic array #FILTER #SORT

👁 3 views Open →

Financial Modeling & Analysis intermediate

Excel Budget vs Actual Variance Analysis Template

Create a complete Excel budget vs. actual variance analysis template for [depart...

#budget analysis #variance #financial template

👁 3 views Open →

VBA & Macros advanced

Excel VBA Macro Automation for Repetitive Reports

Write a VBA macro for Excel that automates the following repetitive reporting ta...

#vba #macro #automation

👁 3 views Open →

Dashboards & Visualization intermediate

Excel Dashboard with Slicers and Conditional Formatting

Act as an Excel dashboard designer. I want to build an interactive dashboard wit...

#excel #dashboard #slicer

👁 3 views Open →

Pivot Tables & Analysis intermediate

Excel Pivot Table: Advanced Grouping and Summarization Techniques

I have a dataset in Excel with the following columns: [list your columns, e.g., ...

#pivot table #grouping #calculated fields

👁 3 views Open →

Excel Formulas & Functions Intermediate

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

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

#dynamic arrays #FILTER #SORT

👁 3 views Open →

Project Management Intermediate

Excel Gantt Chart: Project Timeline and Milestone Tracker

I want to build a professional Gantt chart in Excel for project management witho...

#Gantt chart #project management #Excel timeline

👁 3 views Open →

dashboards Intermediate

Excel Dashboard for KPI Tracking

Create an Excel dashboard template for tracking key performance indicators (KPIs...

#excel #kpi #dashboard

👁 2 views Open →

pivot-tables Beginner

Excel Pivot Table Sales Analysis from Raw Data

Guide me through creating a comprehensive sales analysis using Excel Pivot Table...

#excel #pivot table #sales analysis

👁 2 views Open →

Power Query & Data Transformation advanced

Excel Power Query Data Transformation Pipeline

Help me build an Excel Power Query transformation pipeline. My raw data source i...

#power query #M code #data transformation

👁 2 views Open →

Dashboards & Visualization intermediate

Excel Conditional Formatting Advanced Rules Dashboard

Help me set up advanced conditional formatting rules in Excel for a [sales / HR ...

#conditional formatting #dashboard #icon sets

👁 2 views Open →

Financial Modeling advanced

Excel Financial Model Three-Statement Integration

Build a three-statement financial model in Excel for [company type, e.g., a SaaS...

#financial-model #three-statement #excel

👁 2 views Open →

Power Query advanced

Excel Power Query Data Transformation Masterclass

You are a Power Query specialist. I have raw data that needs cleaning and transf...

#excel #power-query #etl

👁 2 views Open →

What-If Analysis advanced

Excel Scenario Manager and What-If Analysis Business Planning

You are a financial modeling expert using Excel. I need to build a what-if analy...

#excel #scenario-manager #what-if

👁 2 views Open →

Array Formulas advanced

Excel Dynamic Array Functions SEQUENCE SORT FILTER

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

#excel #array-formulas #sequence

👁 2 views Open →

Formulas & Functions 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

👁 2 views Open →

Financial Modeling advanced

Excel Financial Modeling: Scenario Manager and Goal Seek Analysis

I'm building a financial model in Excel for [project/business type]. Help me set...

#scenario manager #goal seek #sensitivity analysis

👁 2 views Open →