39 prompts matching "functions"
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...
I need to master Excel conditional aggregation formulas. Please provide: 1. A c...
Explain SUMIFS in Excel with 3 practical examples: 1) Sum sales where region is ...
Give me the most useful Excel date formulas for business: 1) Calculate age from ...
You are an Excel reporting expert. I need to build a professional pivot table re...
Explain how to use VLOOKUP in Excel to match data between two sheets. Scenario: ...
Show me essential Excel text formulas with examples: 1) Extract first name from ...
Write SQL queries for a business intelligence dashboard. Tables: orders, custome...
Create Excel LAMBDA functions for: 1) CAGR given start value, end value, and yea...
Help me master Excel dynamic array functions to replace my manual filtering and ...
You are a SQL teacher. Walk me through window functions using realistic examples...
Teach me how to use Excel dynamic array functions (FILTER, SORT, UNIQUE, SEQUENC...
Act as a senior data engineer and SQL expert. Help me master SQL window function...
Explain and demonstrate best practices for async/await error handling in JavaScr...
Act as a Microsoft 365 Excel trainer. Teach me the dynamic-array trio FILTER, SO...
You are an Excel expert specializing in modern dynamic array functions. I want t...
Create a complete guide for designing professional Looker Studio dashboards for ...
Create a TypeScript utility functions library with these categories: 1) Array ut...
Teach me SQL window functions with practical business analytics examples. Cover:...
Act as an Excel formula expert. I want to master SUMIF, SUMIFS, COUNTIF, and COU...
Help me write advanced SQL queries for [database: PostgreSQL/MySQL/BigQuery/SQL ...
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...