Data Cleaning & Analysis
Cleaning raw data, pivot tables, statistical analysis and data transformation.
3 Prompts
PROMPT 01
Data Cleaning Formulas
Help me clean this messy dataset in Excel. Problems I have: [describe issues — e.g., inconsistent date formats, extra spaces in names, mixed case text, duplicates, blank rows]. Write the formulas or steps to fix each issue using: TRIM, CLEAN, PROPER, TEXT, SUBSTITUTE, REMOVE DUPLICATES, and Flash Fill. Also explain how to use Power Query for bulk cleaning.
Data Cleaning
Power Query
PROMPT 02
Pivot Table Master Guide
Walk me through building a comprehensive PivotTable from this data: [describe dataset — columns and row count]. I want to analyse: [describe the analysis — e.g., 'total sales by region by month, with top 5 products']. Step-by-step: setting up the PivotTable, choosing the right fields for rows/columns/values/filters, applying calculated fields, and formatting the output. Include how to refresh data when the source updates.
PivotTable
Data Analysis
PROMPT 03
Excel Statistical Analysis
Perform a statistical analysis on this dataset: [describe data]. I need: descriptive statistics (mean, median, mode, standard deviation, min, max, quartiles), a frequency distribution, and a basic correlation analysis between [column A] and [column B]. Write the Excel formulas for each calculation, and explain what each result tells me about the data.
Statistics
Data Analysis
🔍
No prompts match your filter
Try a different search term or difficulty level.
More Excel & Spreadsheets Collections
Formulas & Functions
Complex Excel formulas, VLOOKUP, INDEX/MATCH, XLOOKUP, array functions and nested logic.
5 prompts
Dashboards & Reports
KPI dashboards, management reports and data visualisation design.
3 prompts
AI Spreadsheet Automation
Use MultipleChat to build, populate and analyse Excel files from data or a brief.
3 prompts
🖥
Using Claude Desktop? These prompts are built for it.
Download Claude Desktop for Mac or Windows. Copy any prompt, fill in the [brackets], and paste directly into a new Claude chat. For the best results, use MultipleChat to compare Claude, ChatGPT, Gemini and Grok side by side.