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...
Explain SUMIFS in Excel with 3 practical examples: 1) Sum sales where region is ...
I need to master Excel conditional aggregation formulas. Please provide: 1. A c...
Show me how to use INDEX MATCH in Excel as a more powerful alternative to VLOOKU...
Write SQL queries for a business intelligence dashboard. Tables: orders, custome...
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 ...
I need to reconcile two Excel lists that should overlap, but the data is messy. ...
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...
I have a single column in Excel containing messy entries like "{{example raw ent...
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...
Explain how to use VLOOKUP in Excel to match data between two sheets. Scenario: ...
You are an Excel auditing specialist. Walk me through a systematic audit of a wo...
Teach me how to use Excel dynamic array functions (FILTER, SORT, UNIQUE, SEQUENC...
Create a TypeScript utility functions library with these categories: 1) Array ut...
Create a complete guide for designing professional Looker Studio dashboards for ...
Act as an Excel formula expert. Help me replace nested INDEX-MATCH and VLOOKUP f...
Act as a senior SQL engineer. I need to compute {{describe: e.g., 7-day rolling ...
Demonstrate advanced Pandas GroupBy operations for [dataset type, e.g., sales tr...
I have an Excel formula that is not working correctly or returning unexpected re...