Gemini Promptsgemini100 Prompts

100 Best Gemini Excel Data Analysis Prompts for HR and Recruiters

A practical Gemini prompt library for Excel data analysis tailored to HR and recruiters. 100 exact prompts to extract insights from HR data using Google Gemini prompts and Gemini AI prompts.

Gemini promptsExcel data analysisHR analyticsrecruitersGoogle Gemini promptsGemini AI promptsprompt libraryHR datarecruiting metricsdata analysis prompts

Best For

HR professionals, recruiters, and HR analysts who use Excel and Gemini AI prompts for data insights.

Prompt Use Cases

  • HR analytics
  • recruiting metrics dashboards
  • headcount forecasting
  • attrition analysis
  • diversity metrics tracking
  • recruitment funnel optimization
  • compensation and benefits analysis
  • employee lifecycle analytics
  • performance data analysis
  • talent pipeline reporting

Direct Answer

The best Gemini prompts for Excel data analysis for HR and recruiters are designed to extract department insights, hiring metrics, turnover risks, and compensation benchmarks from HR data in Excel using Gemini prompts. They provide clear roles, tasks, context, outputs, and constraints to deliver actionable results. Use them to drive data-driven HR decisions with reproducible steps.

Introduction

This page is a practical prompt library for Excel data analysis in HR and recruiting. It targets HR professionals, analysts, and recruiters who want to leverage Gemini prompts to analyze Excel datasets. The prompts guide structured data extraction, pattern discovery, and actionable recommendations.

The 100 prompts below are designed to be copyable and immediately usable without needing to supply extra context beyond the placeholders provided. They cover headcount, attrition, hiring, diversity, budgeting, and onboarding analytics.

How to Use These Gemini Prompts

  • Replace placeholders in square brackets with your actual data fields and values to tailor each prompt to your dataset.
  • Add constraints or output formats as needed to fit your reporting requirements, such as tables, bullet lists, or charts descriptions.
  • Request outputs in specific formats like CSV, Excel-ready tables, or narrative summaries to align with your workflow.
  • Review outputs for consistency with your data model and verify key figures with a quick spot-check of the underlying dataset.
  • If outputs include charts or visuals, describe the visualization succinctly so it can be recreated in Excel or a BI tool.
  • Iterate by testing prompts on a sample dataset to ensure reliability and adjust prompts for edge cases.

100 Best Gemini Excel Data Analysis Prompts for HR and Recruiters

  1. Headcount by Department: Role: Analyst. Task: Produce a department-level headcount summary from a given Excel dataset. Context: The dataset includes Department, Job Title, Hire Date, Termination Date, and Location. Output: A clean table with counts by department and location, plus a quarterly trend chart description. Constraints: Include missing value handling, year-to-date totals, and a brief interpretation.
  2. Attrition Rate Trend: Role: Analyst. Task: Calculate attrition rate over time from HR records. Context: Fields include Employee ID, Hire Date, Termination Date, and Termination Reason. Output: A monthly attrition rate series with an interpretation note and a recommendation section. Constraints: Exclude voluntary exits where reason is retirement; handle new hires within the period.
  3. Hiring Funnel Conversion: Role: Analyst. Task: Build a hiring funnel conversion analysis from applicant data. Context: Data columns include Stage, Count, Source, and Time Period. Output: Funnel steps with conversion rates between stages, plus top sources per stage. Constraints: Provide at least three actionable recommendations.
  4. Time-to-Hire Benchmark: Role: Analyst. Task: Compute time-to-hire by department and recruiter. Context: Recruitment events with dates for requisition opened, first interview, offer, and start date. Output: Summary table with medians, interquartile ranges, and a short benchmark interpretation. Constraints: Include outlier handling and a lightweight visualization description.
  5. Cost-per-Hire Analysis: Role: Analyst. Task: Estimate cost per hire by job family. Context: Data includes external spend, agency fees, recruiter hours, and onboarding costs. Output: Cost-per-hire per family, with a narrative on ROI. Constraints: Use year-to-date values and 12-month rolling window insights.
  6. Diversity Pipeline Review: Role: Analyst. Task: Assess diversity metrics across stages of recruitment. Context: Fields include Gender, Ethnicity, Stage, and Outcome. Output: Diversity delta by stage and recommendations to improve representation. Constraints: Provide safe, responsible interpretations and avoid sensitive inferences.
  7. Candidate Source ROI: Role: Analyst. Task: Quantify return on investment by candidate source. Context: Columns Source, Applications, Hires, Time-to-fill, and Revenue per employee. Output: ROI per source and a prioritization list for budget reallocation. Constraints: Normalize by source volume.
  8. Offer Acceptance Forecast: Role: Analyst. Task: Forecast offer acceptance likelihood by role. Context: Features include role, location, salary, recruiter, and interview score. Output: Probabilities by role with recommended tweaking strategies. Constraints: Use a holdout validation period.
  9. Turnover Risk Heatmap: Role: Analyst. Task: Create a turnover risk heatmap by team. Context: Data includes team, attrition flag, tenure, and performance band. Output: Heatmap description and a risk-based action plan. Constraints: Highlight high-risk teams with recommended mitigations.
  10. Salary Range Alignment: Role: Analyst. Task: Check salary ranges against market benchmarks. Context: Data includes Job Title, Current Salary, Min/Max Range, Market Benchmark. Output: Gap analysis by title plus recommended adjustments. Constraints: Note any compliance constraints.
  11. Recruitment Channel Mix: Role: Analyst. Task: Analyze channel mix over time. Context: Data includes Channel, Applications, Hires, Cost. Output: Channel performance summary and optimization suggestions. Constraints: Compare quarterly vs yearly performance.
  12. Candidate Temperature Analysis: Role: Analyst. Task: Classify candidate quality by source and stage. Context: Data includes Candidate ID, Source, Stage, Interview Score, Offer Status. Output: Quality score by source with actionable insights. Constraints: Use standardized scoring rubric.
  13. Onboarding Time Impact: Role: Analyst. Task: Link time-to-productivity to onboarding duration. Context: Data includes Onboarding Days, Time-to-Productivity, Role. Output: Correlation and interpretation with caveats. Constraints: Control for role seniority.
  14. Time-series Hiring Forecast: Role: Analyst. Task: Forecast hiring needs for next 6 quarters. Context: Historical hires by department, seasonality, and growth rate. Output: 6-quarter forecast with confidence intervals and usage notes. Constraints: Include scenario planning.
  15. Employee Spend Segmentation: Role: Analyst. Task: Segment payroll spend by department and location. Context: Data includes Salary, Benefits, Taxes, and Location. Output: Spend by segment with trend analysis and anomaly flags. Constraints: Use rolling averages.
  16. Exit Interview Patterns: Role: Analyst. Task: Summarize themes from exit interview text data. Context: Free-text responses per employee. Output: Thematic summary with actionable retention ideas. Constraints: Maintain confidentiality and only use aggregated insights.
  17. Requisition Fill Rate: Role: Analyst. Task: Compute requisition fill rate by department. Context: Data includes Requisition ID, Open Date, Close Date, Status. Output: Fill rate by department and time period with bottleneck notes. Constraints: Exclude canceled requisitions.
  18. Candidate Experience Score: Role: Analyst. Task: Construct candidate experience score from survey data. Context: Data includes NPS, CSAT, and feedback counts. Output: Overall experience score with improvement plan. Constraints: Normalize scores across periods.
  19. Hiring Manager Satisfaction: Role: Analyst. Task: Measure hiring manager satisfaction by team. Context: Survey results by team, manager, and quarter. Output: Satisfaction index with drivers and actions. Constraints: Report only statistically significant changes.
  20. Offer Decline Reasons: Role: Analyst. Task: Categorize why offers are declined. Context: Data includes Reason, Role, Location, and Stage. Output: Decline reason distribution and mitigation ideas. Constraints: Avoid blaming individuals.
  21. Salary Compression Alert: Role: Analyst. Task: Detect salary compression within teams. Context: Data includes Employee, Title, Salary, and Grade. Output: Compression flags and recommendations. Constraints: Highlight edge cases.
  22. Promotions vs Tenure: Role: Analyst. Task: Compare promotion rates by tenure bands. Context: Data includes Employee ID, Tenure, Promotion Date, and Grade. Output: Promotion rate by tenure with parity notes. Constraints: Control for performance.
  23. Training ROI by Role: Role: Analyst. Task: Assess training ROI by job family. Context: Data includes Training Cost, Employee Performance, and Promotion.. Output: ROI by family with recommendations. Constraints: Use a consistent performance metric.
  24. Headcount Forecast Confidence: Role: Analyst. Task: Assess confidence in headcount forecast. Context: Forecasts, historical errors, and variance. Output: Confidence intervals and risk factors. Constraints: Document assumptions.
  25. Diversity Hiring Gap: Role: Analyst. Task: Identify gaps in diverse hiring by department. Context: Data includes Diversity indicators, Stage, and Outcome. Output: Gap analysis and target actions. Constraints: Respect privacy.
  26. Candidate Pipelining Map: Role: Analyst. Task: Visualize candidate pipelines by stage and source. Context: Stage counts by source over time. Output: Pipeline flow diagram description and takeaways. Constraints: Include drop-off rates.
  27. GDPR Compliance Check: Role: Analyst. Task: Validate data handling for HR analytics. Context: Data fields, retention rules, access controls. Output: Compliance checklist with risk notes. Constraints: No PII in outputs.
  28. Time-to-Offer Analysis: Role: Analyst. Task: Break down time from opening to offer by role. Context: Requisitions with dates and outcomes. Output: Time-to-offer by role and actionable optimizations. Constraints: Exclude non-starters.
  29. Vendor Performance Review: Role: Analyst. Task: Compare recruitment vendors on cost and outcomes. Context: Vendor, spend, hires, time-to-fill. Output: Vendor ranking with recommendations. Constraints: Normalize for volume.
  30. Sourcing Talent Pools: Role: Analyst. Task: Compile a talent pool by role and location. Context: Data includes talent IDs, status, and engagement level. Output: Pool readiness score and next steps. Constraints: Respect candidate privacy.
  31. Compliance Data Anonymize: Role: Analyst. Task: Anonymize HR analytics dataset. Context: Fields with PII. Output: Anonymized table and a data masking plan. Constraints: Remove identifiers entirely.
  32. Compensation Benchmarking: Role: Analyst. Task: Benchmark compensation against market data. Context: Job titles, salaries, benchmarks. Output: Gap analysis and recommended ranges. Constraints: Use latest market data.
  33. ATS Efficiency Report: Role: Analyst. Task: Evaluate applicant tracking system efficiency. Context: Data includes time in each stage, drop-offs, and costs. Output: Efficiency score and bottlenecks. Constraints: Provide actionable steps.
  34. Headcount by Location: Role: Analyst. Task: Analyze headcount distribution by location. Context: Location, department, role, and tenure. Output: Location heatmap description and insights. Constraints: Normalize for market size.
  35. New Hire Quality Check: Role: Analyst. Task: Assess new hire quality via performance at 90 days. Context: Hire date, performance rating, role. Output: Quality index and onboarding tweaks. Constraints: Adjust for role seniority.
  36. Turnover by Tenure: Role: Analyst. Task: Examine turnover by tenure band. Context: Tenure, exit reason, department. Output: Turnover curve by tenure with recommendations. Constraints: Separate voluntary and involuntary exits.
  37. Employee Engagement Pulse: Role: Analyst. Task: Analyze monthly engagement survey results. Context: NPS, sentiment, and participation. Output: Engagement trend and improvement plan. Constraints: Compare against last quarter.
  38. Hiring Plan Alignment: Role: Analyst. Task: Align hiring plan with budget and headcount. Context: Plan, actuals, and forecast. Output: Alignment score and adjustment list. Constraints: Include scenario planning.
  39. Candidate Skill Gap: Role: Analyst. Task: Identify skill gaps by role from resume data. Context: Resumes, job requirements, and performance metrics. Output: Gap report with prioritized upskilling actions. Constraints: Use a consistent rubric.
  40. Team Attrition Benchmark: Role: Analyst. Task: Benchmark team attrition against company average. Context: Team, tenure, and performance band. Output: Benchmark results and retention actions. Constraints: Include confidence intervals.
  41. Interview De-brief Summary: Role: Analyst. Task: Summarize interview de-brief notes by candidate. Context: Notes, scores, and recommendations. Output: Candidate-ready summary with next steps. Constraints: Keep concise.
  42. Offer-Decision Timeline: Role: Analyst. Task: Map decision timelines for offers. Context: Requisition, stage timestamps, and outcome. Output: Timeline heatmap and bottlenecks. Constraints: Highlight fastest vs slowest paths.
  43. Remote vs Onsite Hiring: Role: Analyst. Task: Compare remote versus onsite hiring metrics. Context: Location, stage, and time to fill. Output: Comparison table and practice recommendations. Constraints: Normalize by pool size.
  44. Candidate Experience Audit: Role: Analyst. Task: Audit candidate touchpoints for experience. Context: Email, portal, and interview interactions. Output: Experience score with concrete fixes. Constraints: Prioritize high-impact changes.
  45. Relocation Impact: Role: Analyst. Task: Assess relocation effects on hires. Context: Relocation status, cost, and time to start. Output: Impact analysis and policy suggestions. Constraints: Consider tax implications.
  46. HR Dashboard Sketch: Role: Analyst. Task: Design a KPI dashboard for HR analytics. Context: Key metrics need to be included. Output: Dashboard blueprint with data sources and visuals. Constraints: Ensure actionable insights.
  47. Candidate Rejection Patterns: Role: Analyst. Task: Analyze reasons for rejection. Context: Reasons by stage and role. Output: Rejection causes and remediation actions. Constraints: Avoid biased conclusions.
  48. New Hire Ramp-Up: Role: Analyst. Task: Track ramp-up performance by month after start. Context: Performance and training data. Output: Ramp-up curve with recommendations. Constraints: Control for role type.
  49. Attrition Risk by Role: Role: Analyst. Task: Map attrition risk by job family. Context: Attrition flags, tenure, performance. Output: Risk ranking with mitigation ideas. Constraints: Do not infer protected attributes.
  50. Redundancy Risk Scan: Role: Analyst. Task: Identify roles with overlap and redundancy risk. Context: Role descriptions, headcount, and skills. Output: Redundancy report with consolidation options. Constraints: Include workforce planning notes.
  51. Hiring Policy Gap: Role: Analyst. Task: Find policy gaps impacting time-to-fill. Context: Policy docs, process steps, SLAs. Output: Gap list and corrective actions. Constraints: Align with compliance.
  52. Resume Screen Efficiency: Role: Analyst. Task: Measure resume screening speed and accuracy. Context: Screening time, candidate outcomes, and quality checks. Output: Efficiency metrics and process tweaks. Constraints: Ensure fair screening.
  53. Candidate Diversity Tracker: Role: Analyst. Task: Track diversity metrics across hiring stages. Context: Diversity fields, stage, and outcome. Output: Diversity trajectory with action items. Constraints: Respect privacy.
  54. Internal Mobility Pulse: Role: Analyst. Task: Analyze internal mobility opportunities by department. Context: Internal applicants, promotions, and transfers. Output: Mobility heatmap and recommendations. Constraints: Data freshness required.
  55. Impact of ATS Changes: Role: Analyst. Task: Evaluate impact of ATS updates on workflow. Context: Version, feature, and user feedback. Output: Change impact report and adoption plan. Constraints: Link to business outcomes.
  56. Salary Inflation Trend: Role: Analyst. Task: Track salary inflation by department. Context: Salary data over time, department, and role. Output: Inflation trend and budgeting notes. Constraints: Exclude one-off adjustments.
  57. Time-to-Productivity by Role: Role: Analyst. Task: Compare time-to-productivity across roles. Context: Start date, productivity milestone, and role. Output: Role-wise productivity curve with actions. Constraints: Normalize for experience.
  58. Hiring Freeze Impact: Role: Analyst. Task: Model impact of a hiring freeze. Context: Previous hires, backlog, and backlog risks. Output: Scenario results and recovery plan. Constraints: Include KPI implications.
  59. Background Check Delays: Role: Analyst. Task: Analyze delays in background checks. Context: Check status, vendor, and time to clearance. Output: Delay drivers and process fixes. Constraints: Respect privacy.
  60. New Hire Retention Predict: Role: Analyst. Task: Predict 12-month retention for new hires. Context: Onboarding score, role, location, and initial performance. Output: Retention probability with actions. Constraints: Use conservative estimates.
  61. Hiring Budget Allocation: Role: Analyst. Task: Allocate budget across departments. Context: Spend by department, hires target, and pipeline. Output: Allocation plan with ROI notes. Constraints: Minimize risk.
  62. Candidate Nurturing Plan: Role: Analyst. Task: Create nurturing workflow for passive candidates. Context: Candidate status, engagement level, and touchpoints. Output: Multichannel plan with cadence. Constraints: Respect opt-out preferences.
  63. Applicant Pipeline Health: Role: Analyst. Task: Assess pipeline health by stage. Context: Stage counts, time in stage, and source. Output: Health score and improvement plan. Constraints: Provide concrete next steps.
  64. Third-Party Vendor Benchmark: Role: Analyst. Task: Benchmark third-party recruiters. Context: Vendor data, outcomes, and costs. Output: Ranking and recommended partnerships. Constraints: Normalize for volume.
  65. Candidate Email Optimization: Role: Analyst. Task: Optimize candidate emails for engagement. Context: Email open and response rates by message. Output: Email copy with best practices and tested variants. Constraints: Ensure accessibility.
  66. Diversity Hiring Targets: Role: Analyst. Task: Set practical diversity targets by department. Context: Current diversity by department, goal, and timeline. Output: Target plan with accountability. Constraints: Align with legal guidelines.
  67. Hiring Pipeline SLA: Role: Analyst. Task: Define SLAs for each hiring stage. Context: Stage definitions, owners, and targets. Output: SLA document and monitoring plan. Constraints: Include escalation paths.
  68. Candidate Scoring Rubric: Role: Analyst. Task: Create a scoring rubric for candidates. Context: Criteria by role and interview stage. Output: Rubric with scoring bands and examples. Constraints: Apply consistently.
  69. Onboarding Milestone Tracker: Role: Analyst. Task: Track onboarding milestones by new hire. Context: Milestones, dates, and completion status. Output: Milestone dashboard description and alerts. Constraints: Notify delays.
  70. HR Metrics Roadmap: Role: Analyst. Task: Build a metrics roadmap for HR analytics. Context: Key metrics, data sources, and owners. Output: Roadmap with milestones. Constraints: Align with business goals.
  71. Candidate Time-to-Reply: Role: Analyst. Task: Analyze time to reply from applicants. Context: Applicant timestamps and response status. Output: Reply-time distribution and improvements. Constraints: Respect communication policies.
  72. Hiring Manager Guidance: Role: Analyst. Task: Develop guidance for hiring managers. Context: Process steps, rubrics, and expectations. Output: Quick-start guide with examples. Constraints: Keep concise.
  73. Salary Band Alignment: Role: Analyst. Task: Align salaries to band ranges across departments. Context: Current salaries, bands, and roles. Output: Alignment report and adjustment plan. Constraints: Legal compliance.
  74. Remediation Action Plan: Role: Analyst. Task: Create remediation plans for analytics gaps. Context: Gap analysis results, owners, and timelines. Output: Action plan with milestones. Constraints: Track progress.
  75. Data Quality Audit: Role: Analyst. Task: Audit data quality for HR analytics. Context: Data completeness, accuracy, and consistency checks. Output: Audit report with remediation steps. Constraints: Prioritize high-impact fixes.
  76. Forecast vs Actuals: Role: Analyst. Task: Compare forecast hires to actuals. Context: Forecast data, actual hires, and variance. Output: Variance analysis and corrective actions. Constraints: Include seasonality.
  77. Candidate Geography Map: Role: Analyst. Task: Map candidate origins by geography. Context: Addresses or locations anonymized. Output: Geographic distribution and insights. Constraints: Protect privacy.
  78. New Hire Background Trends: Role: Analyst. Task: Analyze background trends of hires. Context: Education, experience, industry prior. Output: Trend report with implications. Constraints: Handle privacy.
  79. Offer Pipeline Health: Role: Analyst. Task: Assess health of offer pipeline. Context: Open offers, accepted, declined. Output: Health score and action items. Constraints: Avoid bias.
  80. Compliance Risk Dashboard: Role: Analyst. Task: Build compliance risk metrics for HR analytics. Context: Policies, audits, incidents. Output: Dashboard snapshot and remediation plan. Constraints: Keep it concise.
  81. Employee Lifecycle Map: Role: Analyst. Task: Create end-to-end employee lifecycle map. Context: Stages from hire to exit. Output: Lifecycle diagram description and insights. Constraints: Focus on optimization.
  82. Data Retention Plan: Role: Analyst. Task: Define data retention for HR analytics. Context: Data types, legal requirements, and deletion schedule. Output: Retention policy with justifications. Constraints: Align with regulations.
  83. Automation Opportunity Scan: Role: Analyst. Task: Identify automations in HR data workflow. Context: Current processes and pain points. Output: List of automations with impact estimates. Constraints: Prioritize high ROI.
  84. Headcount by Seniority: Role: Analyst. Task: Break down headcount by seniority level. Context: Seniority, department, and location. Output: Seniority distribution and growth notes. Constraints: Normalize by department size.
  85. Hiring Manager Risk: Role: Analyst. Task: Assess hiring manager risk factors. Context: Manager performance, team needs, and past hiring outcomes. Output: Risk score with mitigation ideas. Constraints: Data privacy.
  86. Candidate Re-Engagement: Role: Analyst. Task: Plan re-engagement for inactive candidates. Context: Candidate status, last touchpoint, and response probability. Output: Re-engagement workflow and copy. Constraints: Comply with consent.
  87. Interview Panel Diversity: Role: Analyst. Task: Analyze diversity of interview panels. Context: Panel members, sessions, and outcomes. Output: Panel diversity metrics and recommendations. Constraints: Avoid bias.
  88. Learning Path Alignment: Role: Analyst. Task: Align training paths with career goals. Context: Employee roles, training completed, performance. Output: Path matrix and gaps. Constraints: Personalize within policy.
  89. Compliance Audit Readiness: Role: Analyst. Task: Prepare HR analytics for audits. Context: Data access, logs, and controls. Output: Readiness checklist and evidence pack. Constraints: No sensitive data leakage.
  90. Performance Data Hygiene: Role: Analyst. Task: Cleanse and normalize performance data. Context: Reviews, scores, and dates. Output: Clean dataset and validation plan. Constraints: Document data lineage.
  91. Recruiter Productivity: Role: Analyst. Task: Measure recruiter output per cycle. Context: Requisitions, time-to-fill, and hires. Output: Productivity index and coaching tips. Constraints: Account for market conditions.
  92. Campaign Performance: Role: Analyst. Task: Evaluate recruitment campaigns. Context: Campaign IDs, clicks, conversions, hires. Output: Campaign ROI and creative recommendations. Constraints: Normalize by spend.
  93. Candidate Compliance Checks: Role: Analyst. Task: Verify candidate data compliance. Context: Data accessed, retention, consent. Output: Compliance report and red flags. Constraints: Anonymize outputs.
  94. Succession Risk Map: Role: Analyst. Task: Map succession risk by department. Context: Critical roles, bench strength, and risk rating. Output: Succession plan with updates needed. Constraints: Keep sensitive data secure.
  95. Salary Range Drift: Role: Analyst. Task: Detect drift in salary ranges over time. Context: Ranges, actuals, and market data. Output: Drift report and recommended corrections. Constraints: Time window specified.
  96. Background Check SLA: Role: Analyst. Task: Monitor background check timelines against SLAs. Context: Check type, vendor, and status. Output: SLA adherence report with actions. Constraints: Notify breaches.
  97. Candidate Nudge Templates: Role: Analyst. Task: Create automated nudges for candidates. Context: Stage, status, and response history. Output: Template set with personalization rules. Constraints: Respect opt-out.
  98. Hiring Freeze Scenario: Role: Analyst. Task: Model hiring freeze impact on backlog. Context: Backlog by department and time to fill. Output: Scenario outcomes and recovery steps. Constraints: Communicate clearly.
  99. Diversity Outreach Plan: Role: Analyst. Task: Plan outreach to diverse candidate pools. Context: Target roles, channels, and budgeting. Output: Outreach plan with metrics. Constraints: Ensure inclusivity.
  100. Exit Cause Trend: Role: Analyst. Task: Track exit causes over time by department. Context: Exit reasons, tenure, and department. Output: Trend chart description and retention actions. Constraints: Aggregate legitimately.

Markdown Template

100 Best Gemini Excel Data Analysis Prompts for HR and Recruiters

# 100 Best Gemini Excel Data Analysis Prompts for HR and Recruiters

**Headcount by Department**: Role: Analyst. Task: Produce a department-level headcount summary from a given Excel dataset. Context: The dataset includes Department, Job Title, Hire Date, Termination Date, and Location. Output: A clean table with counts by department and location, plus a quarterly trend chart description. Constraints: Include missing value handling, year-to-date totals, and a brief interpretation.
**Attrition Rate Trend**: Role: Analyst. Task: Calculate attrition rate over time from HR records. Context: Fields include Employee ID, Hire Date, Termination Date, and Termination Reason. Output: A monthly attrition rate series with an interpretation note and a recommendation section. Constraints: Exclude voluntary exits where reason is retirement; handle new hires within the period.
**Hiring Funnel Conversion**: Role: Analyst. Task: Build a hiring funnel conversion analysis from applicant data. Context: Data columns include Stage, Count, Source, and Time Period. Output: Funnel steps with conversion rates between stages, plus top sources per stage. Constraints: Provide at least three actionable recommendations.
**Time-to-Hire Benchmark**: Role: Analyst. Task: Compute time-to-hire by department and recruiter. Context: Recruitment events with dates for requisition opened, first interview, offer, and start date. Output: Summary table with medians, interquartile ranges, and a short benchmark interpretation. Constraints: Include outlier handling and a lightweight visualization description.
**Cost-per-Hire Analysis**: Role: Analyst. Task: Estimate cost per hire by job family. Context: Data includes external spend, agency fees, recruiter hours, and onboarding costs. Output: Cost-per-hire per family, with a narrative on ROI. Constraints: Use year-to-date values and 12-month rolling window insights.
**Diversity Pipeline Review**: Role: Analyst. Task: Assess diversity metrics across stages of recruitment. Context: Fields include Gender, Ethnicity, Stage, and Outcome. Output: Diversity delta by stage and recommendations to improve representation. Constraints: Provide safe, responsible interpretations and avoid sensitive inferences.
**Candidate Source ROI**: Role: Analyst. Task: Quantify return on investment by candidate source. Context: Columns Source, Applications, Hires, Time-to-fill, and Revenue per employee. Output: ROI per source and a prioritization list for budget reallocation. Constraints: Normalize by source volume.
**Offer Acceptance Forecast**: Role: Analyst. Task: Forecast offer acceptance likelihood by role. Context: Features include role, location, salary, recruiter, and interview score. Output: Probabilities by role with recommended tweaking strategies. Constraints: Use a holdout validation period.
**Turnover Risk Heatmap**: Role: Analyst. Task: Create a turnover risk heatmap by team. Context: Data includes team, attrition flag, tenure, and performance band. Output: Heatmap description and a risk-based action plan. Constraints: Highlight high-risk teams with recommended mitigations.
**Salary Range Alignment**: Role: Analyst. Task: Check salary ranges against market benchmarks. Context: Data includes Job Title, Current Salary, Min/Max Range, Market Benchmark. Output: Gap analysis by title plus recommended adjustments. Constraints: Note any compliance constraints.
**Recruitment Channel Mix**: Role: Analyst. Task: Analyze channel mix over time. Context: Data includes Channel, Applications, Hires, Cost. Output: Channel performance summary and optimization suggestions. Constraints: Compare quarterly vs yearly performance.
**Candidate Temperature Analysis**: Role: Analyst. Task: Classify candidate quality by source and stage. Context: Data includes Candidate ID, Source, Stage, Interview Score, Offer Status. Output: Quality score by source with actionable insights. Constraints: Use standardized scoring rubric.
**Onboarding Time Impact**: Role: Analyst. Task: Link time-to-productivity to onboarding duration. Context: Data includes Onboarding Days, Time-to-Productivity, Role. Output: Correlation and interpretation with caveats. Constraints: Control for role seniority.
**Time-series Hiring Forecast**: Role: Analyst. Task: Forecast hiring needs for next 6 quarters. Context: Historical hires by department, seasonality, and growth rate. Output: 6-quarter forecast with confidence intervals and usage notes. Constraints: Include scenario planning.
**Employee Spend Segmentation**: Role: Analyst. Task: Segment payroll spend by department and location. Context: Data includes Salary, Benefits, Taxes, and Location. Output: Spend by segment with trend analysis and anomaly flags. Constraints: Use rolling averages.
**Exit Interview Patterns**: Role: Analyst. Task: Summarize themes from exit interview text data. Context: Free-text responses per employee. Output: Thematic summary with actionable retention ideas. Constraints: Maintain confidentiality and only use aggregated insights.
**Requisition Fill Rate**: Role: Analyst. Task: Compute requisition fill rate by department. Context: Data includes Requisition ID, Open Date, Close Date, Status. Output: Fill rate by department and time period with bottleneck notes. Constraints: Exclude canceled requisitions.
**Candidate Experience Score**: Role: Analyst. Task: Construct candidate experience score from survey data. Context: Data includes NPS, CSAT, and feedback counts. Output: Overall experience score with improvement plan. Constraints: Normalize scores across periods.
**Hiring Manager Satisfaction**: Role: Analyst. Task: Measure hiring manager satisfaction by team. Context: Survey results by team, manager, and quarter. Output: Satisfaction index with drivers and actions. Constraints: Report only statistically significant changes.
**Offer Decline Reasons**: Role: Analyst. Task: Categorize why offers are declined. Context: Data includes Reason, Role, Location, and Stage. Output: Decline reason distribution and mitigation ideas. Constraints: Avoid blaming individuals.
**Salary Compression Alert**: Role: Analyst. Task: Detect salary compression within teams. Context: Data includes Employee, Title, Salary, and Grade. Output: Compression flags and recommendations. Constraints: Highlight edge cases.
**Promotions vs Tenure**: Role: Analyst. Task: Compare promotion rates by tenure bands. Context: Data includes Employee ID, Tenure, Promotion Date, and Grade. Output: Promotion rate by tenure with parity notes. Constraints: Control for performance.
**Training ROI by Role**: Role: Analyst. Task: Assess training ROI by job family. Context: Data includes Training Cost, Employee Performance, and Promotion.. Output: ROI by family with recommendations. Constraints: Use a consistent performance metric.
**Headcount Forecast Confidence**: Role: Analyst. Task: Assess confidence in headcount forecast. Context: Forecasts, historical errors, and variance. Output: Confidence intervals and risk factors. Constraints: Document assumptions.
**Diversity Hiring Gap**: Role: Analyst. Task: Identify gaps in diverse hiring by department. Context: Data includes Diversity indicators, Stage, and Outcome. Output: Gap analysis and target actions. Constraints: Respect privacy.
**Candidate Pipelining Map**: Role: Analyst. Task: Visualize candidate pipelines by stage and source. Context: Stage counts by source over time. Output: Pipeline flow diagram description and takeaways. Constraints: Include drop-off rates.
**GDPR Compliance Check**: Role: Analyst. Task: Validate data handling for HR analytics. Context: Data fields, retention rules, access controls. Output: Compliance checklist with risk notes. Constraints: No PII in outputs.
**Time-to-Offer Analysis**: Role: Analyst. Task: Break down time from opening to offer by role. Context: Requisitions with dates and outcomes. Output: Time-to-offer by role and actionable optimizations. Constraints: Exclude non-starters.
**Vendor Performance Review**: Role: Analyst. Task: Compare recruitment vendors on cost and outcomes. Context: Vendor, spend, hires, time-to-fill. Output: Vendor ranking with recommendations. Constraints: Normalize for volume.
**Sourcing Talent Pools**: Role: Analyst. Task: Compile a talent pool by role and location. Context: Data includes talent IDs, status, and engagement level. Output: Pool readiness score and next steps. Constraints: Respect candidate privacy.
**Compliance Data Anonymize**: Role: Analyst. Task: Anonymize HR analytics dataset. Context: Fields with PII. Output: Anonymized table and a data masking plan. Constraints: Remove identifiers entirely.
**Compensation Benchmarking**: Role: Analyst. Task: Benchmark compensation against market data. Context: Job titles, salaries, benchmarks. Output: Gap analysis and recommended ranges. Constraints: Use latest market data.
**ATS Efficiency Report**: Role: Analyst. Task: Evaluate applicant tracking system efficiency. Context: Data includes time in each stage, drop-offs, and costs. Output: Efficiency score and bottlenecks. Constraints: Provide actionable steps.
**Headcount by Location**: Role: Analyst. Task: Analyze headcount distribution by location. Context: Location, department, role, and tenure. Output: Location heatmap description and insights. Constraints: Normalize for market size.
**New Hire Quality Check**: Role: Analyst. Task: Assess new hire quality via performance at 90 days. Context: Hire date, performance rating, role. Output: Quality index and onboarding tweaks. Constraints: Adjust for role seniority.
**Turnover by Tenure**: Role: Analyst. Task: Examine turnover by tenure band. Context: Tenure, exit reason, department. Output: Turnover curve by tenure with recommendations. Constraints: Separate voluntary and involuntary exits.
**Employee Engagement Pulse**: Role: Analyst. Task: Analyze monthly engagement survey results. Context: NPS, sentiment, and participation. Output: Engagement trend and improvement plan. Constraints: Compare against last quarter.
**Hiring Plan Alignment**: Role: Analyst. Task: Align hiring plan with budget and headcount. Context: Plan, actuals, and forecast. Output: Alignment score and adjustment list. Constraints: Include scenario planning.
**Candidate Skill Gap**: Role: Analyst. Task: Identify skill gaps by role from resume data. Context: Resumes, job requirements, and performance metrics. Output: Gap report with prioritized upskilling actions. Constraints: Use a consistent rubric.
**Team Attrition Benchmark**: Role: Analyst. Task: Benchmark team attrition against company average. Context: Team, tenure, and performance band. Output: Benchmark results and retention actions. Constraints: Include confidence intervals.
**Interview De-brief Summary**: Role: Analyst. Task: Summarize interview de-brief notes by candidate. Context: Notes, scores, and recommendations. Output: Candidate-ready summary with next steps. Constraints: Keep concise.
**Offer-Decision Timeline**: Role: Analyst. Task: Map decision timelines for offers. Context: Requisition, stage timestamps, and outcome. Output: Timeline heatmap and bottlenecks. Constraints: Highlight fastest vs slowest paths.
**Remote vs Onsite Hiring**: Role: Analyst. Task: Compare remote versus onsite hiring metrics. Context: Location, stage, and time to fill. Output: Comparison table and practice recommendations. Constraints: Normalize by pool size.
**Candidate Experience Audit**: Role: Analyst. Task: Audit candidate touchpoints for experience. Context: Email, portal, and interview interactions. Output: Experience score with concrete fixes. Constraints: Prioritize high-impact changes.
**Relocation Impact**: Role: Analyst. Task: Assess relocation effects on hires. Context: Relocation status, cost, and time to start. Output: Impact analysis and policy suggestions. Constraints: Consider tax implications.
**HR Dashboard Sketch**: Role: Analyst. Task: Design a KPI dashboard for HR analytics. Context: Key metrics need to be included. Output: Dashboard blueprint with data sources and visuals. Constraints: Ensure actionable insights.
**Candidate Rejection Patterns**: Role: Analyst. Task: Analyze reasons for rejection. Context: Reasons by stage and role. Output: Rejection causes and remediation actions. Constraints: Avoid biased conclusions.
**New Hire Ramp-Up**: Role: Analyst. Task: Track ramp-up performance by month after start. Context: Performance and training data. Output: Ramp-up curve with recommendations. Constraints: Control for role type.
**Attrition Risk by Role**: Role: Analyst. Task: Map attrition risk by job family. Context: Attrition flags, tenure, performance. Output: Risk ranking with mitigation ideas. Constraints: Do not infer protected attributes.
**Redundancy Risk Scan**: Role: Analyst. Task: Identify roles with overlap and redundancy risk. Context: Role descriptions, headcount, and skills. Output: Redundancy report with consolidation options. Constraints: Include workforce planning notes.
**Hiring Policy Gap**: Role: Analyst. Task: Find policy gaps impacting time-to-fill. Context: Policy docs, process steps, SLAs. Output: Gap list and corrective actions. Constraints: Align with compliance.
**Resume Screen Efficiency**: Role: Analyst. Task: Measure resume screening speed and accuracy. Context: Screening time, candidate outcomes, and quality checks. Output: Efficiency metrics and process tweaks. Constraints: Ensure fair screening.
**Candidate Diversity Tracker**: Role: Analyst. Task: Track diversity metrics across hiring stages. Context: Diversity fields, stage, and outcome. Output: Diversity trajectory with action items. Constraints: Respect privacy.
**Internal Mobility Pulse**: Role: Analyst. Task: Analyze internal mobility opportunities by department. Context: Internal applicants, promotions, and transfers. Output: Mobility heatmap and recommendations. Constraints: Data freshness required.
**Impact of ATS Changes**: Role: Analyst. Task: Evaluate impact of ATS updates on workflow. Context: Version, feature, and user feedback. Output: Change impact report and adoption plan. Constraints: Link to business outcomes.
**Salary Inflation Trend**: Role: Analyst. Task: Track salary inflation by department. Context: Salary data over time, department, and role. Output: Inflation trend and budgeting notes. Constraints: Exclude one-off adjustments.
**Time-to-Productivity by Role**: Role: Analyst. Task: Compare time-to-productivity across roles. Context: Start date, productivity milestone, and role. Output: Role-wise productivity curve with actions. Constraints: Normalize for experience.
**Hiring Freeze Impact**: Role: Analyst. Task: Model impact of a hiring freeze. Context: Previous hires, backlog, and backlog risks. Output: Scenario results and recovery plan. Constraints: Include KPI implications.
**Background Check Delays**: Role: Analyst. Task: Analyze delays in background checks. Context: Check status, vendor, and time to clearance. Output: Delay drivers and process fixes. Constraints: Respect privacy.
**New Hire Retention Predict**: Role: Analyst. Task: Predict 12-month retention for new hires. Context: Onboarding score, role, location, and initial performance. Output: Retention probability with actions. Constraints: Use conservative estimates.
**Hiring Budget Allocation**: Role: Analyst. Task: Allocate budget across departments. Context: Spend by department, hires target, and pipeline. Output: Allocation plan with ROI notes. Constraints: Minimize risk.
**Candidate Nurturing Plan**: Role: Analyst. Task: Create nurturing workflow for passive candidates. Context: Candidate status, engagement level, and touchpoints. Output: Multichannel plan with cadence. Constraints: Respect opt-out preferences.
**Applicant Pipeline Health**: Role: Analyst. Task: Assess pipeline health by stage. Context: Stage counts, time in stage, and source. Output: Health score and improvement plan. Constraints: Provide concrete next steps.
**Third-Party Vendor Benchmark**: Role: Analyst. Task: Benchmark third-party recruiters. Context: Vendor data, outcomes, and costs. Output: Ranking and recommended partnerships. Constraints: Normalize for volume.
**Candidate Email Optimization**: Role: Analyst. Task: Optimize candidate emails for engagement. Context: Email open and response rates by message. Output: Email copy with best practices and tested variants. Constraints: Ensure accessibility.
**Diversity Hiring Targets**: Role: Analyst. Task: Set practical diversity targets by department. Context: Current diversity by department, goal, and timeline. Output: Target plan with accountability. Constraints: Align with legal guidelines.
**Hiring Pipeline SLA**: Role: Analyst. Task: Define SLAs for each hiring stage. Context: Stage definitions, owners, and targets. Output: SLA document and monitoring plan. Constraints: Include escalation paths.
**Candidate Scoring Rubric**: Role: Analyst. Task: Create a scoring rubric for candidates. Context: Criteria by role and interview stage. Output: Rubric with scoring bands and examples. Constraints: Apply consistently.
**Onboarding Milestone Tracker**: Role: Analyst. Task: Track onboarding milestones by new hire. Context: Milestones, dates, and completion status. Output: Milestone dashboard description and alerts. Constraints: Notify delays.
**HR Metrics Roadmap**: Role: Analyst. Task: Build a metrics roadmap for HR analytics. Context: Key metrics, data sources, and owners. Output: Roadmap with milestones. Constraints: Align with business goals.
**Candidate Time-to-Reply**: Role: Analyst. Task: Analyze time to reply from applicants. Context: Applicant timestamps and response status. Output: Reply-time distribution and improvements. Constraints: Respect communication policies.
**Hiring Manager Guidance**: Role: Analyst. Task: Develop guidance for hiring managers. Context: Process steps, rubrics, and expectations. Output: Quick-start guide with examples. Constraints: Keep concise.
**Salary Band Alignment**: Role: Analyst. Task: Align salaries to band ranges across departments. Context: Current salaries, bands, and roles. Output: Alignment report and adjustment plan. Constraints: Legal compliance.
**Remediation Action Plan**: Role: Analyst. Task: Create remediation plans for analytics gaps. Context: Gap analysis results, owners, and timelines. Output: Action plan with milestones. Constraints: Track progress.
**Data Quality Audit**: Role: Analyst. Task: Audit data quality for HR analytics. Context: Data completeness, accuracy, and consistency checks. Output: Audit report with remediation steps. Constraints: Prioritize high-impact fixes.
**Forecast vs Actuals**: Role: Analyst. Task: Compare forecast hires to actuals. Context: Forecast data, actual hires, and variance. Output: Variance analysis and corrective actions. Constraints: Include seasonality.
**Candidate Geography Map**: Role: Analyst. Task: Map candidate origins by geography. Context: Addresses or locations anonymized. Output: Geographic distribution and insights. Constraints: Protect privacy.
**New Hire Background Trends**: Role: Analyst. Task: Analyze background trends of hires. Context: Education, experience, industry prior. Output: Trend report with implications. Constraints: Handle privacy.
**Offer Pipeline Health**: Role: Analyst. Task: Assess health of offer pipeline. Context: Open offers, accepted, declined. Output: Health score and action items. Constraints: Avoid bias.
**Compliance Risk Dashboard**: Role: Analyst. Task: Build compliance risk metrics for HR analytics. Context: Policies, audits, incidents. Output: Dashboard snapshot and remediation plan. Constraints: Keep it concise.
**Employee Lifecycle Map**: Role: Analyst. Task: Create end-to-end employee lifecycle map. Context: Stages from hire to exit. Output: Lifecycle diagram description and insights. Constraints: Focus on optimization.
**Data Retention Plan**: Role: Analyst. Task: Define data retention for HR analytics. Context: Data types, legal requirements, and deletion schedule. Output: Retention policy with justifications. Constraints: Align with regulations.
**Automation Opportunity Scan**: Role: Analyst. Task: Identify automations in HR data workflow. Context: Current processes and pain points. Output: List of automations with impact estimates. Constraints: Prioritize high ROI.
**Headcount by Seniority**: Role: Analyst. Task: Break down headcount by seniority level. Context: Seniority, department, and location. Output: Seniority distribution and growth notes. Constraints: Normalize by department size.
**Hiring Manager Risk**: Role: Analyst. Task: Assess hiring manager risk factors. Context: Manager performance, team needs, and past hiring outcomes. Output: Risk score with mitigation ideas. Constraints: Data privacy.
**Candidate Re-Engagement**: Role: Analyst. Task: Plan re-engagement for inactive candidates. Context: Candidate status, last touchpoint, and response probability. Output: Re-engagement workflow and copy. Constraints: Comply with consent.
**Interview Panel Diversity**: Role: Analyst. Task: Analyze diversity of interview panels. Context: Panel members, sessions, and outcomes. Output: Panel diversity metrics and recommendations. Constraints: Avoid bias.
**Learning Path Alignment**: Role: Analyst. Task: Align training paths with career goals. Context: Employee roles, training completed, performance. Output: Path matrix and gaps. Constraints: Personalize within policy.
**Compliance Audit Readiness**: Role: Analyst. Task: Prepare HR analytics for audits. Context: Data access, logs, and controls. Output: Readiness checklist and evidence pack. Constraints: No sensitive data leakage.
**Performance Data Hygiene**: Role: Analyst. Task: Cleanse and normalize performance data. Context: Reviews, scores, and dates. Output: Clean dataset and validation plan. Constraints: Document data lineage.
**Recruiter Productivity**: Role: Analyst. Task: Measure recruiter output per cycle. Context: Requisitions, time-to-fill, and hires. Output: Productivity index and coaching tips. Constraints: Account for market conditions.
**Campaign Performance**: Role: Analyst. Task: Evaluate recruitment campaigns. Context: Campaign IDs, clicks, conversions, hires. Output: Campaign ROI and creative recommendations. Constraints: Normalize by spend.
**Candidate Compliance Checks**: Role: Analyst. Task: Verify candidate data compliance. Context: Data accessed, retention, consent. Output: Compliance report and red flags. Constraints: Anonymize outputs.
**Succession Risk Map**: Role: Analyst. Task: Map succession risk by department. Context: Critical roles, bench strength, and risk rating. Output: Succession plan with updates needed. Constraints: Keep sensitive data secure.
**Salary Range Drift**: Role: Analyst. Task: Detect drift in salary ranges over time. Context: Ranges, actuals, and market data. Output: Drift report and recommended corrections. Constraints: Time window specified.
**Background Check SLA**: Role: Analyst. Task: Monitor background check timelines against SLAs. Context: Check type, vendor, and status. Output: SLA adherence report with actions. Constraints: Notify breaches.
**Candidate Nudge Templates**: Role: Analyst. Task: Create automated nudges for candidates. Context: Stage, status, and response history. Output: Template set with personalization rules. Constraints: Respect opt-out.
**Hiring Freeze Scenario**: Role: Analyst. Task: Model hiring freeze impact on backlog. Context: Backlog by department and time to fill. Output: Scenario outcomes and recovery steps. Constraints: Communicate clearly.
**Diversity Outreach Plan**: Role: Analyst. Task: Plan outreach to diverse candidate pools. Context: Target roles, channels, and budgeting. Output: Outreach plan with metrics. Constraints: Ensure inclusivity.
**Exit Cause Trend**: Role: Analyst. Task: Track exit causes over time by department. Context: Exit reasons, tenure, and department. Output: Trend chart description and retention actions. Constraints: Aggregate legitimately.

Best Practices

  • Keep prompts focused on a single analytical objective to avoid ambiguous outputs.
  • Use standardized field names across datasets to ensure prompts work consistently.
  • Incorporate data quality checks in prompts to catch missing or outlier values.
  • Reuse prompts with small, documented adjustments for different departments or locations.
  • Safeguard sensitive data by limiting outputs to aggregated or anonymized results.

Common Mistakes to Avoid

  • Using vague terms like analyze or summarize without specifying data fields or outputs.
  • Forgetting to specify output format or verification steps, leading to inconsistent results.
  • Neglecting data privacy and showing PII in outputs or descriptions.
  • Overcomplicating prompts with too many constraints, making results brittle.
  • Not providing a clear context or dataset schema, causing misinterpretation of results.

FAQ

What are Gemini prompts for HR data analysis in Excel?

Gemini prompts are structured instructions that guide Gemini AI to analyze HR data in Excel, producing tables, summaries, and insights with specific outputs and constraints.

How can I use these prompts with HR data?

Replace placeholders with your dataset fields, such as Department, Hire Date, Termination Date, and Salary, then run the prompts to generate analyses and reports.

Do prompts require a specific Excel format?

Prompts are designed to work with common Excel structures; ensure your data is organized in clean columns and rows with headers that match the placeholders.

Can prompts handle sensitive HR data safely?

Yes, prompts should emphasize aggregation and anonymization; outputs should avoid exposing PII and comply with privacy policies.

How do I verify Gemini outputs?

Cross-check key metrics manually from the dataset, validate a sample of results, and compare against known benchmarks or prior reports.

Are these prompts suitable for recruiters only?

They are suitable for HR professionals and recruiters who analyze talent pipelines, hiring metrics, compensation, and onboarding in Excel.

100 Best Gemini Excel Data Analysis Prompts for HR and Recruiters | Suhas Bhairav