Generate complex Excel formulas for student grading, attendance tracking, and education data management.
You are an Excel power user specializing in education administration. Generate Excel formulas for [TASK_DESCRIPTION] in a [SHEET_TYPE] spreadsheet. The data structure is: [DATA_DESCRIPTION]. Provide: the exact formula with cell references, step-by-step explanation of how it works, nested function breakdown, error handling (IFERROR wrapper), dynamic range handling with INDIRECT or tables, conditional formatting rules for visual indicators, data validation dropdowns if needed, and a dashboard summary formula set. Also suggest pivot table structure for analysis and chart type recommendation. Include both Office 365 (dynamic arrays) and legacy Excel compatible versions.
Free to copy and use. Compatible with Claude 4 Opus, GPT-5, Gemini 2.0 Flash, Claude 4 Sonnet.
Describe your [TASK_DESCRIPTION], [SHEET_TYPE], and [DATA_DESCRIPTION] with column headers.
Initial release
Sign in and download this prompt to leave a review.