Search: "FILTER function"

#code review #pull request #software engineering

ChatGPT Prompt: Code Review Checklist Tailored to PR Diff Analysis

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

#coding #testing #property-based

coding Advanced

Generate Property-Based Tests with Hypothesis or fast-check

I have a function `[paste signature + 1-paragraph spec]` and I want property-bas...

excel Advanced

Build Dynamic Dashboard With Slicers and Pivot Charts

Act as an Excel dashboard designer. I have a dataset of {{describe data: e.g., m...

#excel #dashboard #pivot

#hr #interview #screening questions

hr Intermediate

ChatGPT prompt for screening interview questions based on a real role

Act as a practical hiring manager. I need screening interview questions for a c...

#refactor duplicate code #clean code #software design

ChatGPT prompt for refactoring duplicated business logic safely

Act as a senior software engineer reviewing duplicated business logic across mul...

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

#songwriting #lyrics #song structure

creative intermediate

Songwriting Lyrics Structure Hook Bridge Development

Help me write and structure a song. Genre: [pop / country / R&B / folk / rock]. ...

coding advanced

AWS Lambda Serverless Function Deployment Complete Guide

You are an AWS serverless architect. I need to build and deploy a serverless app...

#coding #aws #lambda

#SQL #GROUP BY #window functions

data intermediate

SQL Advanced Queries: GROUP BY, HAVING, and Window Functions

Help me write advanced SQL queries for [database: PostgreSQL/MySQL/BigQuery/SQL ...

#dynamic arrays #FILTER #SORT

excel 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

excel Intermediate

Excel Dynamic Array FILTER SORT UNIQUE Modern Functions Guide

Act as a Microsoft 365 Excel trainer. Teach me the dynamic-array trio FILTER, SO...

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

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

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

#coding #refactoring #clean-code

Refactor a God Function with Multiple Responsibilities

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

Write a Production-Grade Python Function With Tests

Act as a senior Python engineer. Write a function {{function_name}} that {{descr...

#coding #python #testing

#pivot table #sales analysis #excel

excel Intermediate

Build Dynamic Pivot Table from Sales Data

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

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

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

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

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

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