Google Sheets prompts Page 3 of 6
Prompts
-
Power BI Naming Conventions and Field Folder Audit
Review table, column and measure names in a Power BI model for clarity, consistency and hidden clutter, then set a naming standard.
-
Power BI Slicer and Filter Interaction Audit
Check how slicers, page filters and visual interactions in a Power BI report change numbers, to find confusing or misleading filter behaviour.
-
Power BI Gateway and Data Source Credential Hygiene Audit
Review data sources, gateway use and stored credentials behind your Power BI reports for ownership gaps and risk. Defensive review of your own setup.
-
Power BI Calculated Column Versus Measure Usage Audit
Examine calculated columns and measures in your Power BI model to find misplaced logic that bloats size or gives wrong totals, with a move plan.
-
Power BI Report Handover and Documentation Audit
Check that a Power BI report has the owner, sources, definitions and refresh notes a successor needs, and create a one-page documentation template.
-
Power BI Visual Choice and Misleading Chart Audit
Review the charts on a Power BI page for misleading scales, poor chart types and clutter, and suggest clearer visuals matched to each question.
-
Power BI Relationship Cardinality and Ambiguity Check
Examine the table relationships in a Power BI model for wrong cardinality, many-to-many risks and ambiguous paths that inflate or hide totals.
-
Power Query Transformation Steps Audit for Data Quality
Review the Power Query steps behind a Power BI dataset for risky type changes, silent row loss and hard-coded values, with a verification plan.
-
Google Sheets Formula Consistency Across Rows and Columns Audit
Find formulas that break the pattern.
-
Google Sheets Version History and Change Review Audit
Check recent changes for accidental or unauthorised edits.
-
Google Sheets Accessibility and Readability Audit
Check colours, labels and structure for all users.
-
Google Sheets Limits, Quotas and Scale Risk Review
Check whether a sheet is approaching practical limits.
-
Spreadsheet-Based Dashboard Build Guide
Create a live dashboard in a spreadsheet.
-
Sales Report From a Raw Export: Pivot Plan
Plan the pivots before building them.
-
Monthly Variance Analysis Workbook
Explain budget versus actual differences.
-
Break-Even Analysis Workbook
Model fixed costs, variable costs and volume.
-
Cleaning a Messy Export Before Analysis
Create a repeatable clean-up sequence.
-
Cash Flow Forecast Workbook
Plan 13 weeks of inflows and outflows.
-
Seasonality Index From Monthly History
Measure normal highs and lows by month.
-
Discount Impact Analysis
Check whether a promotion actually paid.
-
Headcount and Attrition Analysis
Understand turnover with careful definitions.
-
Budget Versus Actual Dashboard Plan
Plan a one-page management view.
-
Linear Trend Forecast With Honest Caveats
Project a simple trend and state its limits.
-
Supply Par Level and Reorder Sheet Design
Keep supplies stocked without overbuying.
-
Household Monthly Budget
Create a household monthly budget spreadsheet with automatic summaries for income, bills, savings and spending categories.
-
Business Operating Budget
Build annual budget with departmental breakdown.
-
Project Budget vs Actual Tracker
Control a project's spend with forecasts.
-
Nonprofit and Event Fundraising Budget
Budget a fundraising campaign with cost per dollar raised.
-
Small Business Startup Cost Budget
Estimate startup costs and funding needs with a small business startup cost budget, including one-off and monthly costs.
-
Zero-Based Budget for a Department
Justify every line from scratch.
-
Wedding or Large Event Budget Planner
Allocate and track costs and payments.
-
Freelancer and Self-Employed Income Planner
Smooth irregular income and plan for taxes.
-
Personal Net Worth and Savings Goal Planner
Track assets, debts, and progress to goals.
-
Marketing Budget Planner With ROI Tracking
Build a marketing budget planner in a spreadsheet that tracks spend by channel and compares it with results and ROI.
-
Annual Budget Reforecast Workbook
Update the year's budget with actuals.
-
Department Chargeback Budget
Allocate shared costs fairly to departments.
-
Travel Budget Planner
Plan and track trip or team travel costs.
-
Content Calendar Spreadsheet
Build a content calendar spreadsheet with a status workflow, owners and publish dates you can filter and reuse.
-
Weekly Planner With Time Blocks
Create a weekly planning sheet with priorities and time budgeting.
-
Event Planning Timeline
Plan an event with a backward-scheduled timeline.
-
Editorial and Social Posting Schedule Grid
Create a grid to visualize campaigns across weeks.
-
Habit and Goal Tracker With Streaks
Build a habit and goal tracker in a spreadsheet with streaks, progress bars and weekly totals that give visual feedback.
-
Shift Schedule and Availability Planner
Build a staff schedule with constraints.
-
Academic or Course Planner
Plan a term with assignments and exams.
-
Annual Marketing and Business Calendar
Coordinate key dates and campaigns.
-
Resource Capacity and Workload Planner
Plan who can take on which work each week.
-
Content and Social Production Calendar With Approvals
Track content from idea to publication with owners and approval dates.
-
Meal Planning and Grocery Calendar
Plan meals and shopping together.