Basic Data Crunching (No Code)

Here's a sentence that will save you hours of your life:

You can paste data into AI and ask it questions in plain English.

No VLOOKUP. No pivot tables. No SQL. No Python (unless you want it). Just: "here's my data, what does this tell me?"

IMAGE PLACEHOLDER
DALL-E 3 / Midjourney / Ideogram
A split-screen: on the left, a chaotic spreadsheet with hundreds of rows and a frustrated person. On the right, a clean chat interface showing a clear, structured summary with key insights highlighted. Dark background, green accent for the insights panel. No text.

What You Can Do With Pasted Data

The Quick Analysis

"Here is a table of sales data: [paste data]. What are the top 3 insights? What should I pay attention to?"

Find the Outliers

"Here is last month's expense report: [paste]. Which line items are unusually high compared to the others? Flag anything that looks like it might be an error."

The Comparison

"Here are two months of website traffic data: [paste]. What changed? What got better? What got worse?"

The Ranking

"Here is a list of [products/customers/employees] with their [metric]. Rank them from best to worst and explain what the gap between the top and bottom tells us."

The Forecast

"Based on this data showing [metric] for the last 6 months: [paste]. What would a simple trend projection suggest for next month? What assumptions are you making?"

The CSV Trick

For larger spreadsheets:

1. In Excel/Google Sheets → File → Download as CSV
2. Open the CSV in a text editor → Copy all the text
3. Paste into Claude and ask your question

Claude can handle thousands of rows. Just tell it what you're looking for.

Prompt Challenge: Read the Numbers

Prompt Challenge
Rate My Prompt — how many power elements can you hit?
Your Mission
You have monthly sales figures for 4 products over 6 months. You need to write an AI prompt that will tell you which product is growing fastest, which is declining, and what the overall trend is.
 Rate My Prompt
The best data analysis prompts tell AI exactly what question you're trying to answer, not just "analyse this".

Interactive: Calculate Statistics

See how easy data analysis becomes with just a few lines of Python:

python-runner.pyInteractive
# Sales data for 4 products over 6 months
sales = {
    "Product A": [1200, 1350, 1280, 1500, 1620, 1800],
    "Product B": [800, 750, 700, 680, 650, 610],
    "Product C": [400, 420, 450, 480, 510, 550],
    "Product D": [2000, 1980, 2050, 2100, 2080, 2200],
}

print("Product Performance Summary")
print("-" * 40)

for product, monthly in sales.items():
    start = monthly[0]
    end = monthly[-1]
    growth = ((end - start) / start) * 100
    trend = "GROWING" if growth > 0 else "DECLINING"
    print(f"{product}: {trend} ({growth:+.1f}% over 6 months)")

best = max(sales, key=lambda p: sales[p][-1])
print(f"\nTop performer this month: {best}")
 Loading Kernel...

When the Data Gets Complex

For advanced analysis, ask AI to write the code for you:

"Here is a CSV with columns: date, product, region, revenue, units_sold. Write me Python code to: 1) find the top 3 regions by revenue, 2) calculate month-over-month growth by product, 3) identify any products where units sold went up but revenue went down."

AI writes the code. You run it. You get the answer.

Key takeaway: Spreadsheets are just data. AI speaks data. Stop fighting with formulas — just ask questions.

Up next: Lesson 8 — Rapid learning with AI as your personal tutor