Search: "filter-function"

#excel #array-formulas #sequence

Excel Dashboard for KPI Tracking

Create an Excel dashboard template for tracking key performance indicators (KPIs...

#excel #kpi #dashboard

👁 22 views

excel advanced

Excel Dynamic Array Functions SEQUENCE SORT FILTER

You are an Excel expert specializing in modern dynamic array functions. I want t...

👁 20 views

#excel #pivot table #sales analysis

Sales Analysis Pivot Table

Guide me step by step to create a pivot table in Excel for sales analysis. My da...

👁 19 views

#power query #excel #web scraping

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

👁 19 views

#dynamic array #FILTER #SORT

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

👁 18 views

excel intermediate

Excel Dynamic Array FILTER SORT UNIQUE Formula Guide

Teach me how to use Excel dynamic array functions (FILTER, SORT, UNIQUE, SEQUENC...

👁 17 views

data intermediate

Looker Studio Dashboard Design Best Practices Business Reporting

Create a complete guide for designing professional Looker Studio dashboards for ...

#data #looker-studio #dashboard

👁 17 views

data intermediate

Power BI Dashboard Design: Best Practices for Business Intelligence

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

#power-bi #dashboard #dax

👁 16 views

#dynamic arrays #filter #sort

Excel Dynamic Array FILTER SORT UNIQUE Modern Functions Guide

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

👁 16 views

#excel #power query #m code

Power Query M Code Generator for Repeatable Data Transformation

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

👁 16 views

data advanced

Power BI Dashboard Design Executive Sales Report

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

#Power BI #DAX #dashboard

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

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

productivity Intermediate

Email Triage System for Inbox Zero

Design an email triage system to reach Inbox Zero in 20 minutes per day. Include...

#productivity #email #inbox zero

#job-description #recruiting #hiring

hr Intermediate

Write a Job Description That Filters In, Not Out

Rewrite this job description to filter the right people IN rather than the wrong...

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

👁 13 views

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

👁 13 views

creative Beginner

Brainstorm 30 Distinct Ideas Using Forced Constraints

Act as a creative director running a constrained brainstorm. Give me 30 ideas fo...

#creative #brainstorm #ideation

👁 13 views

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

👁 12 views

#excel #pivot tables #data cleaning

Convert Messy Sales Data into a Pivot Table Report

You are an Excel expert. I will paste a messy sales dataset with columns for dat...

👁 11 views