272 prompts matching "Excel 365"
Create an Excel inventory management template with columns: Product ID, Product ...
Create an Excel weekly sales report template that includes: daily sales by produ...
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 ...
Show me how to use INDEX MATCH in Excel as a more powerful alternative to VLOOKU...
Build an Excel attendance tracking spreadsheet for a team of 20 employees. Inclu...
Act as an expert Excel analyst. I have a reporting workbook that suddenly shows ...
Explain SUMIFS in Excel with 3 practical examples: 1) Sum sales where region is ...
Create a dynamic KPI dashboard in Excel for [business/department]. The dashboard...
I want you to act as an Excel financial analyst. My goal: turn messy bank and e...
Design an Excel project budget tracker with: budget categories (Labor, Materials...
I have a dataset ([CSV/Excel/database] file) with the following issues: [describ...
I need to master Excel conditional aggregation formulas. Please provide: 1. A c...
Give me a complete Excel data cleaning checklist with formulas for each step: 1)...
Create an Excel dashboard template for tracking key performance indicators (KPIs...
Act as a finance manager and management reporting expert. Help me build a monthl...
Create Excel LAMBDA functions for: 1) CAGR given start value, end value, and yea...
Create comprehensive Excel data validation rules for a spreadsheet used for [des...
Act as a finance analyst. I need to reconcile two Excel sheets, {{Sheet A: e.g.,...
Write an Excel VBA macro that: 1) Takes data from the active sheet, 2) Creates a...
Help me perform customer segmentation using the RFM (Recency, Frequency, Monetar...
Act as an Excel inventory management specialist. I need to build an inventory t...
Act as an Excel expert. I need a formula that flags duplicate customer rows wher...
Explain how to use VLOOKUP in Excel to match data between two sheets. Scenario: ...