Skip to content
cccskills
FreePublished on GitHub

data-analyst

Turn raw data into an Excel workbook with cleaned records, formula-based summaries, and charts. Get three to five plain-language conclusions grounded in figures, with possible explanations or recommendations and clear acknowledgment when the data is insufficient.

OriginalShow the original description

Take raw data through cleaning, formulas and charts to plain-language conclusions, delivered as an Excel workbook

Works withExcel

Run score Not tested

See how to install

Good for

  • Cleaning inconsistent units and date formats
  • Comparing results across periods or years
  • Visualizing trends and composition
  • Preparing key findings for a business review

Files included (1)

  • SKILL.md1.4 KB

SKILL.md (original)

Review the instructions the agent will receive before you install.

You are a data analyst. The goal is for a non-technical user to come away with insights they can understand, not just a table.

Workflow

  1. Look at the data first: read the attachment or pasted data once through, confirm what each field means, the row count, and obvious dirty data (blanks / duplicates / inconsistent units). Ask about anything ambiguous before going on.
  2. Build the workbook as an Excel workbook with the spreadsheet tools available here.
    • Sheet 1 holds the cleaned detail (units and date formats unified, with a note of what was excluded);
    • Sheet 2 holds the summary: grouped statistics, period-on-period and year-on-year comparisons and Top-N, all with formulas, never typed results;
    • Key metrics get charts (line for trends, bar / pie for composition); headers bold, number columns right-aligned.
  3. Once the workbook is done, give 3-5 conclusions in the reply, each = observation + figure + likely explanation or recommendation. Do not restate the table.
  4. Where the data cannot support a conclusion, say "insufficient data" rather than over-inferring.

Reviews

No reviews yet. Tell others what you thought.

Comments

No login needed. Share how it worked for you, ask a question, or note where it did not run.

No comments yet. Be the first to write one.

Comments are published right away. Do not include personal information such as email addresses or phone numbers. Up to 2 URLs.

0 / 1,000 characters

This form is protected by reCAPTCHA, and the Google Privacy Policy and Terms of Service apply.

More skills from this repository

brand-copy

FreeSummary

Use product facts and audience information to create ten tagline options, benefit statements backed by evidence, and brand stories for websites and social media. Compare alternatives in a Markdown document with recommendations and tone guidance.

  • Compare tagline options for a product
  • Rewrite product features as customer benefits
  • Create brand stories for a website and social media
genspark-ai/genoffice10.7KUpdated Oct 23, 2026

budget-planner

FreeSummary

Turn a business plan or project spending details into an Excel budget workbook. Organize monthly costs, account and quarterly summaries, confirmed assumptions, and a change log, with formulas that update calculations when assumptions change.

  • Build an annual department budget from a business plan
  • Organize project spending into a monthly budget
  • Compare budget totals with previous-year results
genspark-ai/genoffice10.7KUpdated Oct 23, 2026

business-plan

FreeSummary

Turn a project idea or unfinished draft into a Word business plan for fundraising or internal approval, covering customers, market size, competitors, revenue model, team, and three-year financial projections with clearly stated assumptions.

  • Prepare a business plan for fundraising
  • Develop a proposal for internal project approval
  • Complete financial projections and competitor analysis
genspark-ai/genoffice10.7KUpdated Oct 23, 2026

business-report

FreeSummary

Turn notes, data, and source documents into a structured Word business report. An executive summary, evidence-based findings, actionable recommendations, and open questions give readers a clear conclusion, with consistent wording and sources for the figures.

  • Turning notes and data into a business report
  • Writing an assessment to support a decision
  • Preparing a sourced report for a client
genspark-ai/genoffice10.7KUpdated Oct 23, 2026

campaign-planner

FreeSummary

Turn campaign goals, audience details, timing, and budget into a Word plan for review. Develop theme options, schedules, promotion channels, materials, cost breakdowns, measurable targets, contingency plans, and a template for reviewing results.

  • Plan a product launch event
  • Design a seasonal sales promotion within a budget
  • Map participation and conversion steps for an online campaign
genspark-ai/genoffice10.7KUpdated Oct 23, 2026

contract-drafter

FreeSummary

Prepare a reference contract draft in Word from the parties, scope, payment terms, and other agreement details. Include a pre-signing checklist explaining unfavorable clauses and unresolved negotiation points, with a reminder to obtain licensed legal review.

  • Drafting a services outsourcing contract
  • Identifying risks in an agreement before signing
  • Listing unresolved contract negotiation points
genspark-ai/genoffice10.7KUpdated Oct 23, 2026

See all skills by genspark-ai

Report a problem with this skill