71 prompts matching "functions"
You are a SQL teacher. Walk me through window functions using realistic examples...
Write a nested IF formula in Excel that assigns letter grades based on numeric s...
Show me how to use INDEX MATCH in Excel as a more powerful alternative to VLOOKU...
Explain SUMIFS in Excel with 3 practical examples: 1) Sum sales where region is ...
Write SQL queries for a business intelligence dashboard. Tables: orders, custome...
I need to master Excel conditional aggregation formulas. Please provide: 1. A c...
Create Excel LAMBDA functions for: 1) CAGR given start value, end value, and yea...
Act as a senior data engineer and SQL expert. Help me master SQL window function...
Explain how to use VLOOKUP in Excel to match data between two sheets. Scenario: ...
Give me the most useful Excel date formulas for business: 1) Calculate age from ...
Show me essential Excel text formulas with examples: 1) Extract first name from ...
Demonstrate advanced Pandas GroupBy operations for [dataset type, e.g., sales tr...
Teach me how to use Excel dynamic array functions (FILTER, SORT, UNIQUE, SEQUENC...
You are an Excel expert specializing in modern dynamic array functions. I want t...
Explain and demonstrate best practices for async/await error handling in JavaScr...
I have existing Excel spreadsheets that use VLOOKUP formulas and I want to moder...
I have an Excel formula that is not working correctly or returning unexpected re...
Act as an Excel formula expert. Help me replace nested INDEX-MATCH and VLOOKUP f...
Write a Postgres query to produce a monthly cohort retention table. Source table...
I have a single column in Excel containing messy entries like "{{example raw ent...
Create a complete guide for designing professional Looker Studio dashboards for ...
You are an Excel formula expert. Help me write an INDEX/MATCH formula that retur...
I need to reconcile two Excel lists that should overlap, but the data is messy. ...
You are an Excel reporting expert. I need to build a professional pivot table re...