8 Data Analysis AI Prompts for Virtual Assistants

Browse the prompts

{
  "model": "jev-latest",
  "state": {
    "today": "{{today-iso-date}}",
    "document": "{{document-text}}"
  },
  "questions": {
    "mode": {
      "type": "choice",
      "instructions": "How is the {{date-role}} written in the document?",
      "criteria": {
        "absolute": "A calendar date that names a month",
        "relative": "Given relative to today, such as tomorrow or next Friday",
        "none": "The document does not state this date"
      }
    },
    "month": {
      "type": "choice",
      "instructions": "If the {{date-role}} is an absolute calendar date, which month is it in?",
      "criteria": {"january": "January", "february": "February", "march": "March", "april": "April", "may": "May", "june": "June", "july": "July", "august": "August", "september": "September", "october": "October", "november": "November", "december": "December", "none": "Not an absolute

Date Extraction Without Letting the Model Do Math

JevData AnalysisData Cleaning

Extracts specified dates from text documents without performing mathematical operations.

68
## Role
You are an expert in Microsoft Excel, providing clear, accurate instructions for tasks including pivot tables, formulas, data formatting, and charts.

## Task
Provide a comprehensive step-by-step guide to complete the specified Excel task described by the user.

## Instructions

1. **Define the task**: Clearly restate the specific Excel task or problem to be solved.

2. **Prerequisites**: Outline the initial setup required:
   - Required data structure or range
   - Any preliminary formatting needed
   - Relevant Excel version considerations or settings

3. **Step-by-step walkthrough**: Detail each action required:
   - Which tab, menu, or function to access
   - Exact formulas or data to enter, with explanations of each component and its purpose
   - Parameters or options to configure, explaining what each choice affects
   - How to verify results for accuracy

4. **Best practic

Excel Task Guide Prompt for ChatGPT

OpenAIChatGPTData AnalysisSpreadsheets & Formulas

Generates step-by-step instructions for any Microsoft Excel task, from pivot tables and formulas to charts and data formatting. Runs on ChatGPT, Claude, and other text models.

64

Advanced Excel Formula Solver Prompt

OpenAIChatGPTData AnalysisSpreadsheets & Formulas

Generates production-ready Excel formulas with step-by-step explanations for complex spreadsheet challenges. Runs on ChatGPT, Claude, Gemini, and Grok to deliver array formulas, nested functions, and alternative solutions.

55

Excel Task Helper Prompt for Step-by-Step Guidance

OpenAIChatGPTData AnalysisSpreadsheets & Formulas

Generates detailed, step-by-step instructions for completing Excel tasks, from formulas and data analysis to charts and automation. Runs on ChatGPT, Claude, and Gemini.

38

Excel Function Mechanics Explainer Prompt

OpenAIChatGPTData AnalysisSpreadsheets & Formulas

Generates step-by-step explanations of any Excel function, from syntax and arguments to practical examples and troubleshooting. Runs on ChatGPT, Claude, and Gemini to teach spreadsheet formulas at any skill level.

35
## Role
You are a productivity analyst with expertise in team performance measurement, data-driven insights, and operational optimization.

## Task
Analyze team productivity trends and deliver a comprehensive report with actionable recommendations to improve efficiency and output.

## Context
Team: {{team-context}}

Focus on quantitative metrics (task completion rates, time-to-completion, output quality) and qualitative data (team feedback, performance reviews). Analyze trends over time, comparing performance against industry benchmarks and organizational goals. Consider external factors affecting productivity (tool changes, process shifts, workload variations). Ensure all recommendations follow SMART criteria (specific, measurable, achievable, relevant, time-bound). Avoid assumptions without data-backed evidence.

## Output
Deliver your analysis in this structure:

**Executive Summary**

Team Productivity Trends Analysis Report Prompt

OpenAIChatGPTData AnalysisReporting & Dashboards

Generates a comprehensive productivity analysis report with data-driven insights, trend visualizations, and SMART recommendations for improving team efficiency. Runs on ChatGPT, Claude, and Gemini.

28
## Role
You are a productivity analyst specializing in team performance optimization, data-driven insights, and actionable efficiency improvements.

## Task
Conduct a comprehensive analysis of team productivity trends and deliver a structured report with evidence-based recommendations for optimizing performance.

## Context
Team details: {{team-and-tracking-context}}
(Include team size, industry, current productivity tracking methods, any known challenges, and organizational goals.)

## Analysis Framework

**Data Collection & Metrics:**
- Quantitative: task completion rates, time-to-completion, output quality scores, velocity trends
- Qualitative: team feedback, performance reviews, blockers reported
- Compare against industry benchmarks and internal targets
- Account for external factors (tool changes, process shifts, seasonal variations)

**Pattern Identification:**
- Analyze trends ov

Team Productivity Trend Analysis Prompt

OpenAIChatGPTData AnalysisData Insights

Generates a structured productivity analysis report with data-driven insights and SMART recommendations for optimizing team performance. Runs on ChatGPT, Claude, Gemini, and Grok.

27

Excel Function Tutorial Generator for Specific Tasks

OpenAIChatGPTData AnalysisSpreadsheets & Formulas

Generates step-by-step instructional guides for applying Excel functions to specific tasks. Runs on ChatGPT, Claude, Gemini, and Grok to create practical, focused tutorials that skip basic navigation and concentrate on real-world function usage.

20

What are Data Analysis AI prompts for Virtual Assistants?

Data Analysis AI prompts for Virtual Assistants are engineered instructions that already work. These are not one-line questions. Each one fixes the role, the context, the task and the output format before you type a word, so you get a usable result on the first run instead of the fourth.

They cover the work Virtual Assistants actually get asked for: research and briefs, copy and content, analysis and reporting, planning, outreach and the admin that eats the day. Open a card to see the full prompt and the output it returns.

The deepest areas here: App Development (109 prompts), Data Insights (86 prompts), Reporting & Dashboards (61 prompts), Data Cleaning (19 prompts), Data Visualization (19 prompts).

Popular on this page right now: "Date Extraction Without Letting the Model Do Math", "Excel Task Guide Prompt for ChatGPT", "Advanced Excel Formula Solver Prompt".

8 on this page, every one scoped to Virtual Assistants. Free to read, free to copy.

Why these prompts work for Virtual Assistants

A weak prompt costs you the hour you were trying to save: you rewrite it three times, get something generic, then finish the job by hand. An engineered prompt front-loads that thinking once.

In Virtual Assistants that means first drafts you can send, analysis you can act on, and the repetitive work handed off, so the time goes into judgement instead of typing.

Every prompt here was written for a real job and tested against the models people actually use. Nothing scraped from a thread.

How to use these prompts

Open a prompt, copy it, and replace the [bracketed] variables with your own product, audience or topic. The structure around them stays as is. That structure is the part doing the work.

Paste it into ChatGPT, Claude, Gemini, Grok or the model you already use. If the output drifts, tighten the context line instead of rewriting the whole prompt.

No account needed to copy one. No setup, no extension, nothing to install.

Which AI tool works best for Virtual Assistants prompts?

Text prompts here run well in ChatGPT, Claude, Gemini and Grok; image prompts target Midjourney and Nano Banana. Each card lists the models it was tested with.

Are these AI prompts free to use?

A big part of the library is free: open a prompt, copy it, use it. Premium packs and the Complete AI Bundle unlock the full collection with lifetime updates.

How do I adapt these prompts to my use case?

Start with the [variables]: niche, audience, constraints. If the result still misses, add one example of the output you want. A single good example beats three extra instructions.

For a prompt built from scratch, the Start Now card above opens the custom prompt generator.

Related resources

Get smarter on AI every week

One email a week with the best new prompts, tools, and model updates. Unsubscribe anytime.

Join 100,000+ subscribers. One email a week, real prompts, tools, and model updates. Unsubscribe anytime.