108 prompts matching "Excel formulas"
Design a KPI dashboard for a [type of business]. Include: 1) Define 8-10 key met...
Create an Excel inventory management template with columns: Product ID, Product ...
Write a nested IF formula in Excel that assigns letter grades based on numeric s...
Act as a financial analyst. Create a detailed monthly financial report template ...
Build an Excel attendance tracking spreadsheet for a team of 20 employees. Inclu...
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 ...
Give me the most useful Excel date formulas for business: 1) Calculate age from ...
Help me perform customer segmentation using the RFM (Recency, Frequency, Monetar...
Act as an expert Excel analyst. I have a reporting workbook that suddenly shows ...
Create an Excel weekly sales report template that includes: daily sales by produ...
Show me essential Excel text formulas with examples: 1) Extract first name from ...
Guide me step by step to create a pivot table in Excel for sales analysis. My da...
Give me a complete Excel data cleaning checklist with formulas for each step: 1)...
Act as a data analyst. I have sales data with columns: Date, Product, Category, ...
Act as an Excel inventory management specialist. I need to build an inventory t...
Design an Excel project budget tracker with: budget categories (Labor, Materials...
Create a comprehensive Excel expense report template with these features: 1. In...
Act as an Excel specialist. Build me an invoice tracking spreadsheet with these ...
Act as a data analyst helping me prepare a messy CSV file for analysis. I will ...
Act as a study coach. I will paste a textbook chapter excerpt, lecture notes, or...
Explain how to use VLOOKUP in Excel to match data between two sheets. Scenario: ...
Create a pivot table setup for employee performance analysis. Data columns: Empl...
Write an Excel VBA macro that: 1) Takes data from the active sheet, 2) Creates a...