Search: "conditional sum"

#typescript #generics #utility-types

coding advanced

TypeScript Generics and Utility Types Complete Practical Guide

Create a comprehensive practical guide to TypeScript generics and built-in utili...

#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 #sales analysis #excel

Build Dynamic Pivot Table from Sales Data

Act as an Excel data analyst. I have a sales dataset with columns: [Date, Region...

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

#invoice #VBA #automation

excel Advanced

Invoice Generator with Auto-Numbering VBA

Create an Excel invoice generator with automatic invoice numbering using VBA. B...

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

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

#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 #inventory #reorder-point

excel Advanced

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 Advanced

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

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

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

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

👁 10 views

design Intermediate

Mobile App Wireframe: UX Flow Documentation and Screen Mapping

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

#wireframe #UX design #mobile app

👁 10 views

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

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

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

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