Excel prompts Page 4 of 7
Prompts
-
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.
-
Team Vacation and Leave Planner
Coordinate time off and coverage.
-
Product Launch Countdown Planner
Plan tasks backward from a launch date.
-
Class or Training Schedule Planner
Coordinate sessions, rooms, and instructors.
-
Excel Power Query Cleaning Plan for a Messy Export
Plan the applied steps that turn a monthly export into a clean, refreshable table.
-
Excel Power Query Plan to Combine Monthly Files From a Folder
Combine many files with the same layout into one table.
-
Excel Data Model and DAX Measure Design for a Sales Report
Plan tables, relationships and measures before building the PivotTable.
-
Excel Solver and Goal Seek Setup for a Planning Decision
Frame a decision as a model that Goal Seek or Solver can handle.
-
Excel PivotTable With Slicers and Timeline: Interactive Report Design
Design a one-page interactive report from a raw table.
-
Excel Macro Specification Writer Before You Record or Ask for VBA
Define exactly what a macro should do, check, and never do.
-
Excel Chart Brief: Choose the Chart and Format It for the Message
Pick the right chart and format it so the message is clear.
-
Excel Print Layout and Page Setup Plan for a Report Sheet
Make a sheet print cleanly on one or more pages.
-
Excel Get Data From a Web Page or PDF: Feasibility and Steps
Decide whether and how to import data from a page or file, respecting terms of use.
-
Excel Training Plan for a Team: From Basic to Confident in Six Weeks
Plan short lessons around the team's real tasks.
-
Excel Workbook Guide: Explain This Workbook to a New Owner
Write a handover guide from a description of the workbook.
-
Excel Text to Columns and Flash Fill Cleaning Guide
Choose the right quick technique for splitting and reshaping text.
-
Dependent Dropdown Lists in Excel Step by Step
Set up dependent dropdown lists in Excel so the second list changes with the first, with named ranges, formulas and fixes for common errors.
-
Dependent Dropdown Troubleshooter: Why Is My List Broken?
Diagnose a broken dependent dropdown by answering guided questions, then get a ranked list of likely causes and a fix for each one.
-
Conditional Formatting Rule Audit and Cleanup Plan
Audit a sheet with messy conditional formatting rules, find duplicates, overlaps and slow rules, and get a cleanup plan without losing highlights.
-
Power Query: Combine Many Excel Files From a Folder
Combine many Excel or CSV files from one folder with Power Query, including step-by-step setup, cleaning steps and a refresh routine.
-
Power Query Merge Two Tables Like a Lookup
Merge two tables in Power Query to replace slow lookups, with join types explained in plain words, a match check and refresh instructions.
-
Power Query Refresh Failures: Diagnose and Fix Checklist
Troubleshoot a Power Query refresh that fails or returns wrong data with a diagnosis table, step-by-step checks and prevention habits.
-
Excel Formula Auditing Tools Guide With a Practice Workbook
Learn to trace and check formulas.
-
Excel Colour Coding and Layout Standard for Models
Set consistent conventions for inputs, calculations and outputs.
-
Excel Moving Average and Seasonal Forecast Lesson With Honest Limits
Learn simple forecasting and when not to trust it.
-
Excel Co-Authoring and Shared Workbook Etiquette Guide
Work together on one file without overwriting each other.
-
Excel Monthly Report Refresh Playbook for a Non-Expert
Document the routine so anyone can update the report.
-
Excel Table Cleaning Plan: Trim, Case, Duplicates and Dates
Clean a pasted Excel table step by step: trim spaces, fix case, remove duplicates and standardise dates, with checks.
-
Excel Split and Merge Columns: Names, Addresses and Codes
Split and combine text columns correctly, including awkward cases.
-
Excel PivotTable Summary From a Raw Table With Cross-Checks
Plan a pivot, build it, and prove the numbers are right.
-
Excel Formula Error Diagnosis From a Pasted Formula and Message
Find out why a formula fails and fix it safely.
-
Cash Flow Forecast Template
Design a 12-month cash flow forecast template in a spreadsheet with formulas for inflows, outflows and running balance.
-
Profit and Loss Tracker by Month
Create an income statement tracker with variance.
-
Loan and Investment Calculator Sheet
Build calculators with amortization and scenarios.
-
Invoice and Accounts Receivable Tracker
Build an invoice and accounts receivable tracker in a spreadsheet with aging, follow-ups and a payment status view.
-
Break-Even and Pricing Scenario Model
Model price, volume, and cost trade-offs.
-
Sales Commission and Bonus Calculator
Compute payouts from tiers and quotas.
-
Rental Property or Investment Analysis Sheet
Evaluate returns with transparent assumptions.
-
Payroll and Labor Cost Planner
Forecast staffing cost and overtime.
-
Three-Scenario Financial Forecast Workbook
Build a base, downside, and upside forecast with a scenario switch.