Gestaffelte Provision berechnen
Erstellen a formula or explanation for sales commission rules with multiple thresholds.
“Calculate 5% commission up to $5,000, 7% from $5,001 to $10,000, and 10% above $10,000 for the value in D2.”
Beispiele
Nutzen Sie bessere Eingaben und erzielen Sie bessere Tabellenergebnisse.
Diese Beispielsammlung zeigt praktische Eingabemuster für Formeln, Berichte, Rechnungen, Datenbereinigung, Analysen, Diagramme und Konvertierungen. Übernehmen Sie die Idee, passen Sie sie an Ihre Tabelle an und nutzen Sie sie im Hauptarbeitsbereich.
✓ Reale Anwendungsfälle✓ Beispiele für gute Eingaben✓ Internal links to related tools
Eingabe-Galerie
Beispiele, die Benutzer direkt anpassen können.
Die besten Beispiele sind konkret statt allgemein. Sie nennen der KI das Geschäftsziel, die zu verwendenden Daten und das gewünschte Endergebnis.
Mitarbeiter anhand der ID finden
Use a formula example when your data lives on a separate sheet.
“Return the employee name and department from the Employees sheet using the ID in A2.”
Doppelte E-Mail-Adressen finden
Useful for cleanup, CRM imports, and customer-list maintenance.
“Mark duplicate email addresses in column B, but ignore blank cells.”
Überfällige Rechnungen hervorheben
Ask for a formula, workbook logic, or document-ready rule.
“Show Overdue when the due date has passed and the invoice status is not Paid.”
Umsatz nach Stadt summieren
Turn messy reporting requests into precise spreadsheet logic.
“Sum revenue in column D where city in column B equals New York and date is in the current month.”
Eine #VALUE!-Formel korrigieren
Use this when a spreadsheet already exists and the logic is failing.
“Erklären why this formula returns #VALUE! and give me a corrected version.”
Aufbau einer guten Eingabe
Was eine starke Eingabe enthalten sollte.
Prompt part
Example
Why it matters
Ziel
Find duplicates
Tells AI the job
Location
Column B
Targets the data
Ausgabe
Highlight or label
Defines the result
More categories
Beispiele beyond formulas.
Resources should also encourage deeper product usage across the rest of SheetWise.
Erstellen business documents
Ask SheetWise to build invoices, budgets, payroll workbooks, expense logs, or full spreadsheet templates from a plain-English description.
Explore Erstellen →Ask questions about uploaded data
Hochladen a workbook and ask for top performers, missing values, comparisons, trends, suspicious numbers, or chart recommendations.
Open KI-Datenassistent →Erstellen spreadsheet automation
Describe a macro or Apps Script workflow and ask for code, setup steps, explanations, and optimization suggestions.
Open Automatisierung →Can I copy these prompts exactly?
Yes, but it is even better to adapt them to your own workbook, column names, rules, and output needs.
Are the examples for Excel only?
No. Many prompt structures also work for Google Sheets, especially in formula generation, analysis, and business-document creation.
Why are examples important for SEO and conversions?
They answer real user intents, help people discover use cases, and demonstrate product value with concrete, readable content.
Where should I go after reviewing examples?
Open the matching tool page or the main workspace and try the prompt there.
Practice with real examples
Arbeitsbereich öffnen and try a prompt that matches your job.
Beispiele are only valuable when they lead directly into action—so each section sends users back into the correct SheetWise tool.