Search: "dynamic arrays"

#onboarding #mobile ux #app design

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

#excel formulas #dynamic arrays #dashboard

ChatGPT Prompt: Excel Dynamic Array Formulas for Reporting Dashboards

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

#excel #dashboard #index-match

Build a Dynamic Dashboard Using INDEX-MATCH and Slicers

Act as an Excel power user. I have a sales dataset with columns: Date, Region, P...

#data validation #dropdown lists #dependent dropdowns

Excel Data Validation and Dropdown Lists

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

👁 17 views

#excel #dashboard #pivottable

Create a Dynamic Dashboard with Slicers and PivotTables

You are an Excel dashboard designer. Guide me through building an interactive sa...

👁 17 views

coding Intermediate

Coding: Review a PR From a Senior Without Just Saying LGTM

I'm reviewing a PR from [SENIOR ENGINEER] who's more experienced than me: [DESCR...

#coding #code-review #mentorship

👁 16 views

#excel #formulas #commission

Build a Dynamic Commission Calculator With Tiered Rates in Excel

I need an Excel commission calculator that supports tiered rates (e.g. 5% on the...

👁 15 views

#excel #dynamic-arrays #textsplit

Excel Dynamic Array Formula to Split Comma-Separated Tags into Columns

I have column A filled with comma-separated tags like 'urgent, vip, refund, bill...

👁 15 views

excel intermediate

Build a Dynamic Excel Dashboard with Slicers

Act as an Excel expert. Guide me through building a dynamic dashboard for [datas...

#excel #dashboard #slicers

👁 14 views

#excel #dashboard #pivottable

Build a Dynamic Excel Dashboard Summary

Act as an Excel analyst. I will paste a table of raw data with these columns: [L...

👁 13 views

Automate Variance-to-Budget Reporting in Excel with LET and LAMBDA

You are an FP&A automation specialist. I have a monthly actuals sheet and a budg...

#lambda #let #variance

👁 12 views

#rolling #trend #dynamic-range

Excel: Build a Rolling 12-Month Revenue Trend Without Hardcoded Dates

I want a chart that always shows the last 12 months of revenue — so when I add M...

👁 11 views

#excel #dropdown #data validation

Build a dynamic dropdown that filters a second dropdown

I want two dependent dropdowns in Excel: pick a Region in cell A2, and the City ...

👁 11 views

#excel #data-validation #dropdown

Build a Dynamic Dropdown Validation Plan

You are an Excel data-validation specialist. I will describe the lists and rules...

👁 10 views

excel Beginner

Convert a Business Question into an Excel Formula

You are an Excel formula expert. I want to answer this question from my spreadsh...

#excel #formulas #xlookup

👁 9 views