Search: "dynamic arrays"

41 prompts matching "dynamic arrays"

"dynamic arrays" ✕ Clear all ✕

excel intermediate

Build a Dynamic KPI Dashboard in Excel

Create a dynamic KPI dashboard in Excel for [business/department]. The dashboard...

#excel #dashboard #kpi

design Intermediate

Web Accessibility Audit: WCAG 2.1 Checklist for Designers and Developers

Help me conduct a thorough web accessibility audit and implement WCAG 2.1 compli...

#accessibility #WCAG #web accessibility

Dynamic Date Formulas

Give me the most useful Excel date formulas for business: 1) Calculate age from ...

#excel #date #DATEDIF

Excel Data Validation: Drop-down Lists and Input Controls

Act as an Excel data integrity specialist. I need to set up data validation with...

#excel #data-validation #dropdown

excel intermediate

Excel Dashboard Builder from Raw Data

I have raw data in Excel and want to create a professional dashboard. My data in...

#excel #dashboard #visualization

coding Intermediate

ChatGPT prompt for converting manual QA steps into Playwright test cases

Act as a test automation engineer. I have manual QA steps and I want them conver...

#playwright test generation #manual qa to automation #e2e test prompt

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

design Intermediate

Mobile UX Wireframe Brief with User Flow Notes

You are a senior mobile UX designer. I will describe a feature. Produce a wirefr...

#design #ux #wireframe

excel 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

marketing intermediate

Google Ads Search Campaign Copywriting and Optimization

You are a Google Ads specialist and direct response copywriter. I need to write ...

#marketing #google-ads #ppc

Dynamic Employee Shift Schedule with Drop-downs and Conflict Detection

Act as an Excel expert. Create a weekly employee shift schedule spreadsheet for ...

#excel #shift schedule #data validation

finance intermediate

Business Budget Variance Analysis Template Monthly Reporting

Build a complete budget variance analysis system for business financial manageme...

#finance #budget #variance-analysis

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

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

#dynamic arrays #filter #sort

INDEX/MATCH Formula Generator with Dynamic Multi-Criteria Lookup

You are an Excel formula expert. Help me write an INDEX/MATCH formula that retur...

#excel #index match #formula

excel Intermediate

Build Dynamic Pivot Table from Sales Data

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

#pivot table #sales analysis #excel

coding Advanced

Debug Memory Leak in Long-Running Node.js Process

I have a Node.js process leaking memory. RSS grows from 200MB to 2GB over 6 hour...

#memory leak #nodejs #debugging

excel Intermediate

Excel Data Validation and Dropdown Lists

Teach me how to create advanced data validation and dependent dropdown lists in ...

#data validation #dropdown lists #dependent dropdowns

Excel XLOOKUP Multi-Condition: Advanced Lookup Formulas Guide

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

#XLOOKUP #INDEX MATCH #multi-criteria lookup

excel Intermediate

Excel XLOOKUP Formula Builder for Multi-Criteria Match

Act as an Excel power user. I need an XLOOKUP-based formula that returns [RETURN...

#xlookup #formulas #excel

excel Intermediate

ChatGPT Prompt: Excel Dynamic Array Formulas for Reporting Dashboards

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

#excel formulas #dynamic arrays #dashboard

Excel LAMBDA Function Custom Formula Library Creation Guide

Design a library of reusable custom Excel functions using the LAMBDA function fo...

#excel #lambda #custom-functions

design Advanced

Mobile App Onboarding Flow UX Pattern Library Best Practices

Act as a mobile UX designer. Design an onboarding flow for [APP TYPE — fintech, ...

#onboarding #mobile ux #app design