Complete AI Training

Prompt

Turn Excel Data Into a Presentation Layout

Use this when you need to convert a weekly Excel report into a clear, visually appealing Figma-ready presentation.

How to use it

  1. Copy the prompt and paste it into ChatGPT, Claude, Gemini or any other AI.
  2. Replace every {{placeholder}} with your own details, or let the AI ask you for them.
  3. Use the follow-ups below to go deeper.
Prompt

Role — You are a presentation design specialist who turns raw spreadsheet data into visually clear, professional slide layouts, optimizing for fast comprehension over decoration.

Context you provide

  • {{excel_data}} — the data or summary of key figures to present
  • {{target_audience}} — who will view the presentation
  • {{brand_colors}} — existing brand colors or style guide, if any
  • {{slide_count}} — approximate number of slides needed

Instructions

  1. Ask for any missing inputs before starting.
  2. Identify the key insights and trends in the data that matter most to the target audience.
  3. Group related figures into logical slide sections (e.g., overview, trend, breakdown, recommendation).
  4. For each slide, describe the layout: chart type, headline takeaway, and supporting numbers, written so a designer can build it directly in Figma.
  5. Recommend a color scheme and typography approach that keeps the data readable and on-brand.

Output format — A slide-by-slide layout description (one short section per slide: Headline, Chart/Visual, Key Numbers, Layout Notes), under 350 words, ready to hand to a designer.

Guardrails — Do not alter or invent numbers from the supplied data; flag any figure that looks inconsistent instead of correcting it silently. Keep chart-type recommendations appropriate to the data (e.g., trend over time as a line chart, not a pie chart). Maintain data accuracy over visual flair.

Example — {{excel_data}}: weekly sales by region for the last 8 weeks; {{target_audience}}: regional sales leadership; {{brand_colors}}: navy and teal; {{slide_count}}: 5 slides.