Formulas & Functions Spreadsheets

Prompts

• XLOOKUP Formula Builder With Worked Examples

  Write lookup formulas that survive real data.

  Create Spreadsheets / Formulas & Functions

• INDEX MATCH Two-Way Lookup Builder

  Find a value at the intersection of a row and column.

  Create Spreadsheets / Formulas & Functions

• SUMIFS and COUNTIFS Multi-Criteria Formula Writer

  Total and count by several conditions.

  Create Spreadsheets / Formulas & Functions

• Dynamic Array Formulas: FILTER, SORT, UNIQUE

  Replace manual filtering with live formulas.

  Create Spreadsheets / Formulas & Functions

• Google Sheets QUERY Function Builder

  Write SQL-like queries inside a sheet.

  Create Spreadsheets / Formulas & Functions

• ARRAYFORMULA Patterns for Google Sheets

  Apply a formula to a whole column without dragging.

  Create Spreadsheets / Formulas & Functions

• Text Cleaning Formulas for Messy Data

  Fix spaces, case, characters, and formats.

  Create Spreadsheets / Formulas & Functions

• Splitting and Joining Text Formulas

  Combine and separate fields reliably.

  Create Spreadsheets / Formulas & Functions

• Date Calculation Formulas That Handle Real Cases

  Compute ages, deadlines, and durations correctly.

  Create Spreadsheets / Formulas & Functions

• Conditional Formatting Rule Writer

  Highlight what matters with custom rules.

  Create Spreadsheets / Formulas & Functions

• Data Validation and Dependent Dropdowns

  Control inputs and chain dropdown lists.

  Create Spreadsheets / Formulas & Functions

• IFERROR and Error-Proofing Formulas

  Handle errors without hiding real problems.

  Create Spreadsheets / Formulas & Functions

• Nested IF to IFS and SWITCH Simplifier

  Rewrite tangled logic into readable formulas.

  Create Spreadsheets / Formulas & Functions

• Running Totals and Moving Averages

  Track cumulative values and trends.

  Create Spreadsheets / Formulas & Functions

• Ranking and Percentile Formulas

  Rank items fairly and handle ties.

  Create Spreadsheets / Formulas & Functions

• Return All Matches Lookup Formulas

  Pull every row that matches, not just the first.

  Create Spreadsheets / Formulas & Functions

• Partial Text and Approximate Matching

  Match names that are not exactly the same.

  Create Spreadsheets / Formulas & Functions

• Formula Debugging Interview

  Find why a formula returns the wrong answer.

  Create Spreadsheets / Formulas & Functions

• Formula Explainer: Break It Down Step by Step

  Understand a complicated formula you inherited.

  Create Spreadsheets / Formulas & Functions

• LET and LAMBDA for Readable Formulas

  Name intermediate values and build reusable functions.

  Create Spreadsheets / Formulas & Functions

• Cross-Sheet Consolidation Formulas

  Combine data from several sheets or files.

  Create Spreadsheets / Formulas & Functions

• Financial Functions Walkthrough: PMT, NPV, IRR

  Use finance formulas correctly with examples.

  Create Spreadsheets / Formulas & Functions

• Statistical Functions for Beginners

  Describe data with the right measures.

  Create Spreadsheets / Formulas & Functions

• Inventory and Reorder Formulas

  Calculate stock, reorder points, and order quantities.

  Create Spreadsheets / Formulas & Functions

• Attendance and Schedule Formulas

  Track hours, shifts, and absences.

  Create Spreadsheets / Formulas & Functions

• Gradebook Formulas for Teachers

  Calculate weighted grades and flag students.

  Create Spreadsheets / Formulas & Functions

• Commission and Tiered Pricing Formulas

  Calculate bonuses and bracketed rates correctly.

  Create Spreadsheets / Formulas & Functions

• Currency and Unit Conversion Formulas

  Convert reliably and keep rates auditable.

  Create Spreadsheets / Formulas & Functions

• Regular Expression Formulas in Google Sheets

  Extract and validate text patterns.

  Create Spreadsheets / Formulas & Functions

• IMPORTRANGE and Data Import Setup

  Pull data from other files safely.

  Create Spreadsheets / Formulas & Functions

• KPI Dashboard Formulas

  Compute the numbers that drive a dashboard.

  Create Spreadsheets / Formulas & Functions

• Duplicate Detection and Removal Formulas

  Find, flag, and handle repeated records.

  Create Spreadsheets / Formulas & Functions

• Excel to Google Sheets Formula Translation Table

  Move formulas between apps without surprises.

  Create Spreadsheets / Formulas & Functions

• Array Formula Performance Review

  Speed up slow workbooks.

  Create Spreadsheets / Formulas & Functions

• Named Ranges and Structured References Setup

  Make formulas readable and resilient.

  Create Spreadsheets / Formulas & Functions

• Checks and Reconciliation Formulas

  Build self-checking sheets.

  Create Spreadsheets / Formulas & Functions

• Formula Test Case Builder

  Create test data that proves a formula works.

  Create Spreadsheets / Formulas & Functions

• Business Day and Holiday Calendar Formulas

  Handle deadlines around weekends and holidays.

  Create Spreadsheets / Formulas & Functions

• Spill and Dynamic Range Troubleshooting

  Fix #SPILL! errors and unstable ranges.

  Create Spreadsheets / Formulas & Functions

• Pivot Table Alternatives Using Formulas

  Build live summaries without a pivot table.

  Create Spreadsheets / Formulas & Functions

No prompts match those filters.