Search: "conditional sum"

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

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

#budget #variance #reporting

Excel Budget Variance Report with Conditional Logic

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

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

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

#coding #typescript #interface

coding advanced

TypeScript Interface & Type Design Patterns Advanced Guide

Act as a TypeScript expert and software architect. Help me master advanced TypeS...

#wireframe #UX design #mobile app

design Intermediate

Mobile App Wireframe: UX Flow Documentation and Screen Mapping

Help me create comprehensive wireframe documentation and UX flow maps for a mobi...

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

customer-service Intermediate

CSAT Survey Question Bank with Open-End Triggers

Act as a VoC research lead. Design a post-resolution CSAT survey for [CHANNEL] (...

#csat #survey #vox

#excel #conditional-formatting #accounts-receivable

excel Beginner

Excel Conditional Formatting Rule to Highlight Aging Invoices

Help me build a conditional formatting rule for an invoices sheet so each row hi...

#excel #amortization #financial modeling

Build a Loan Amortization Schedule in Excel

Act as a financial analyst. Create a step-by-step Excel guide to build a loan am...

#template #data-validation #conditional-formatting

Build a Reusable Excel Template With Input Validation Built In

Help me design a reusable Excel template for [USE CASE: e.g. expense report, pro...

#budget tracker #personal finance #Excel template

excel Beginner

Excel Personal Budget Tracker: Monthly and Annual Template

Help me build a comprehensive personal budget tracker in Excel from scratch. I n...

#coding #typescript #generics

coding Advanced

ChatGPT Prompt: TypeScript Type Inference Helper for Complex Generic Functions

You are a TypeScript type-system expert. Help me get correct types on a generic ...

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

#data #data-quality #monitoring

data Advanced

Data Quality Monitoring Rules for a Production Table

I need to monitor data quality on a production table loaded daily from upstream ...

#SOP #standard operating procedure #process documentation

business intermediate

Standard Operating Procedure Template Operations Team

Create a Standard Operating Procedure (SOP) for the following business process: ...

👁 7 views

#excel #scenarios #data tables

Create a What-If Scenario Comparison Table With Data Tables

I have a financial model with three driver inputs (cells B2: pricing, B3: churn,...

👁 6 views

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

👁 5 views

#excel #power query #survey

Convert a Messy Survey Export Into Clean Long-Format Data

I exported a survey to Excel. Each respondent is one row, each question is its o...

👁 4 views