Document Practice Spreadsheet Audit
Prompts
-
Excel Chart Type Chooser From a Small Data Sample
Pick the right chart for the message and avoid misleading ones.
-
Workbook Structure and Tab Layout Audit for Clarity
Review how a workbook's tabs, order and naming are organised and propose a clearer structure so another person can follow it without help.
-
Spreadsheet Formula Consistency Audit From Sample Rows
Spot inconsistent, hard-coded or broken formulas in a column by comparing sample cells, and get a fix plan that is safe to test on a copy.
-
Spreadsheet Handover Documentation and README Audit
Check whether a spreadsheet has enough explanation for a successor to use it safely, then produce a README tab with sources, steps and cautions.
-
Data Entry Validation and Input Cell Audit
Audit a spreadsheet's input columns for validation gaps, free-text chaos and error-prone entry, and design simple rules to prevent bad data.
-
Spreadsheet File Naming and Version Control Audit
Review a shared folder of spreadsheet versions to find confusing names and unclear latest files, then set a naming rule and cleanup plan.
-
Shared Spreadsheet Access and Edit Risk Audit
Check who can view and edit a shared spreadsheet, spot over-broad access and fragile editing habits, and propose safer settings. Defensive only.
-
Hard-Coded Numbers and Hidden Assumptions Audit
Find numbers typed into formulas and undocumented assumptions in a model, and move them into labelled input cells with a change log.
-
Pivot Table Source Data and Refresh Check
Audit the source range, refresh habits and field setup of a pivot table to catch stale or incomplete numbers before sharing a report.
-
Report Sheet Readability and Print Layout Audit
Review a spreadsheet report page for readability, number formatting, labels and print settings, and get a prioritised polish list for readers.
-
Date and Number Format Consistency Audit for a Dataset
Detect mixed date formats, text-numbers and inconsistent units in a pasted dataset sample, and write a safe standardising plan.
No prompts match those filters.