Search: "FILTER function"

#Excel #formulas #automation

Excel Intermediate

Excel Formula Generator

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

#TypeScript #utility functions #JavaScript

coding intermediate

JavaScript TypeScript Generic Utility Functions Library

Create a TypeScript utility functions library with these categories: 1) Array ut...

#SQL #window functions #analytics

data advanced

SQL Window Functions Advanced Analytics Queries

Teach me SQL window functions with practical business analytics examples. Cover:...

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

#finance #investing #portfolio

finance intermediate

Investment Portfolio Rebalancing Strategy Template Guide

Create a comprehensive guide for individual investors on portfolio rebalancing s...

#coding #testing #unit-tests

coding intermediate

Unit Test Generator for Existing Code

Generate comprehensive unit tests for my existing code. Details: Code to test: ...

#power-bi #dashboard #dax

data intermediate

Power BI Dashboard Design: Best Practices for Business Intelligence

Help me design an effective Power BI dashboard. My situation: Data source: [EXC...

#excel #formula #duplicates

excel Intermediate

Excel Formula to Detect Duplicate Customer Records Across Multiple Columns

Act as an Excel expert. I need a formula that flags duplicate customer rows wher...

#coding #refactoring #clean-code

coding Intermediate

Refactor a God Function with Multiple Responsibilities

Below is a function that's grown to ~200 lines and does too much. Refactor it. R...

#Power BI #DAX #dashboard

data advanced

Power BI Dashboard Design Executive Sales Report

Help me design a Power BI executive sales dashboard. Data sources: [CRM data / S...

#XLOOKUP #INDEX MATCH #multi-criteria lookup

excel advanced

Excel XLOOKUP Multi-Condition: Advanced Lookup Formulas Guide

I need to look up values in Excel using multiple conditions. My dataset has colu...

#pivot tables #excel #data analysis

excel Intermediate

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 #power query #m code

excel Advanced

Power Query M Code Generator for Repeatable Data Transformation

Act as a Power Query (M language) developer. I will describe a messy raw export ...

productivity Intermediate

Inbox Zero Triage Protocol for a 2000-Email Backlog

I have 2000+ unread emails in my inbox. Build me a one-time triage protocol I ca...

#productivity #inbox-zero #email

#kpi #scorecard #dashboard

excel intermediate

Excel Dashboard KPI Scorecard with Traffic Lights

Design an Excel KPI scorecard dashboard for [department] with: 1) KPI table with...

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

#board-meeting #governance #pre-read

business Advanced

Board Meeting Pre-Read Document Generator

Act as a chief of staff to a startup CEO. Draft a board pre-read for the [QUARTE...

#coding #refactor #clean-code

coding Advanced

ChatGPT Prompt: Code Refactor Plan for a Long, Tangled Function

You are a senior engineer guiding a safe refactor. Help me decompose a long, tan...

#hr #onboarding #new-hire

hr Intermediate

ChatGPT Prompt: Onboarding Plan for a New Hire's First 30-60-90 Days

You are a people operations lead. Build a 30-60-90 day onboarding plan for a new...

#power query #excel #web scraping

excel Advanced

ChatGPT Prompt: Excel Power Query M Code for Web Data Scraping

Write Power Query M code to scrape and transform data from [URL OR DESCRIBE WEBP...

#excel formulas #dynamic arrays #dashboard

excel Intermediate

ChatGPT Prompt: Excel Dynamic Array Formulas for Reporting Dashboards

Build a reporting dashboard using Excel 365 dynamic array formulas (FILTER, SORT...

#code review #pull request #software engineering

coding Intermediate

ChatGPT Prompt: Code Review Checklist Tailored to PR Diff Analysis

Review this pull request diff and provide structured feedback. [PASTE DIFF OR F...

#exit interview #employee relations #hr analytics

hr Intermediate

ChatGPT Prompt: Exit Interview Script with Theme Analysis Framework

Create an exit interview process for [COMPANY] that produces actionable insights...