100 Best Gemini Excel Data Analysis Prompts for Financial Advisors

Direct Answer

The best Gemini prompts for Excel data analysis for financial advisors are designed to extract actionable insights from client portfolios, optimize reporting, and support risk-aware decisions. Use them to build robust analyses, automate summaries, and elevate client communications while maintaining data privacy and compliance.

Introduction

This prompt library focuses on Excel data analysis for financial advisors. It provides 100 copyable Gemini prompts to help you analyze portfolios, cash flow, risk, and client segments directly from Excel data.

The prompts are crafted for practical use in client reporting, portfolio management, and financial planning, enabling advisors to automate insights without writing new logic from scratch.

How to Use These Gemini Prompts

• Replace placeholders like [industry], [audience], and [format] with your actual data and preferred output style.
• Add constraints to keep outputs within your policy and reporting standards.
• Request outputs in formats like tables, bullet lists, or dashboards, and specify when you want charts or raw data.
• Verify outputs by cross-checking with original data sources and testing with a subset before full deployment.

100 Best Gemini Excel Data Analysis Prompts for Financial Advisors

1. Portfolio return summary: Role: You are a financial analyst. Task: Generate a quarterly portfolio return summary. Context: Given an Excel workbook with sheets: Holdings, Transactions, Prices, and Benchmark. Output format: a clean table and a narrative. Constraints: include currency formatting, percentage gains, and attribution by security. Use the latest quarter in the data. Provide at least three charts references and a one paragraph interpretation.
2. Risk-adjusted metrics: Role: You are a risk analyst. Task: Compute risk-adjusted metrics for a client portfolio. Context: Use Excel data with columns: Security, Weight, Return, StdDev, Beta, and Benchmark. Output format: a summary table with Sharpe, Sortino, and Information ratios. Constraints: flag any metrics beyond defined thresholds and explain drivers in bullet points.
3. Sector exposure check: Role: You are a portfolio analyst. Task: Assess sector exposure. Context: Dataset includes Sector, Weight, MarketCap, and Region. Output format: a pivot-friendly summary showing overweight and underweight sectors with color-coded indicators. Constraints: compare to benchmark exposures and provide remediation ideas.
4. Cash flow forecast: Role: Financial planner. Task: Create a 12-month cash flow forecast for a client. Context: Input sheet has Revenue, Expenses, Debt service, and Investments. Output format: monthly forecast table with cumulative cash and a summary narrative. Constraints: highlight peaks and liquidity gaps and suggest contingency actions.
5. Expense trend analysis: Role: Data analyst. Task: Analyze expense trends over time. Context: Data includes Date, Category, Amount, and Department. Output format: line chart data points and a narrative explaining anomalies. Constraints: normalize for seasonality and provide 3 actionable optimization suggestions.
6. Client segment profiling: Role: Marketing analyst. Task: Profile client segments by profitability. Context: Dataset includes ClientID, Revenue, Margin, and AdvisingTime. Output format: segment list with heat map readiness and recommended actions per segment. Constraints: exclude personally identifiable data; summarize in aggregate.
7. Expense forecast accuracy: Role: Controller. Task: Validate forecast accuracy for expenses. Context: Forecast vs Actual table with variance. Output format: accuracy score and variance breakdown by category. Constraints: identify drivers of variance and propose corrective actions.
8. Revenue scenario modeling: Role: Finance analyst. Task: Build a revenue scenario model. Context: Inputs: base, optimistic, pessimistic projections; sheet includes time and revenue streams. Output format: scenario table with probability-weighted outcome. Constraints: include sensitivity analysis for key drivers.
9. RFM client segmentation: Role: CRM analyst. Task: Create RFM segments from client transaction data. Context: Dataset: Recency, Frequency, Monetary values with customer IDs. Output format: segment labels, counts, and target offers. Constraints: maintain data privacy and provide export-ready table.
10. Portfolio attribution drilldown: Role: Portfolio analyst. Task: Drill down performance attribution. Context: Returns by holding, market effect, and currency effect in separate sheets. Output format: attribution summary with explanatory notes and recommended adjustments. Constraints: include chart-ready data.
11. Benchmark tracking: Role: Investment analyst. Task: Track portfolio vs benchmark. Context: Data includes dates, portfolio returns, benchmark returns, and excess return. Output format: monthly and annual excess return summary with trend chart references. Constraints: flag divergence and possible causes.
12. Tax lot impact: Role: Tax advisor. Task: Assess tax lot impact for trades. Context: Trade history with cost basis, date, and lot identifiers. Output format: tax lot optimization recommendations and a compliance-ready summary. Constraints: avoid sharing sensitive identifiers.
13. Dividend yield analysis: Role: Research analyst. Task: Analyze dividend yields across holdings. Context: Data: Ticker, Dividend, Yield, and Payout Ratio. Output format: yield ranking with dividend sustainability notes. Constraints: compare to sector peers.
14. Scenario: rate shock: Role: Financial planner. Task: Model rate shock impact on portfolio. Context: Interest rate scenarios in a table. Output format: impact table and a concise risk memo. Constraints: include a dashboard-ready summary.
15. Liquidity runbook: Role: Risk manager. Task: Create liquidity stress runbook. Context: Data includes cash, credit facilities, and upcoming maturities. Output format: step-by-step actions with owners and timelines. Constraints: prioritize high-probability actions.
16. Liquidity coverage ratio: Role: Analyst. Task: Compute liquidity coverage ratio for clients. Context: Data: cash, inflows, outflows, and lines of credit. Output format: LCR table and risk flags. Constraints: align with internal policies.
17. Portfolio heatmap: Role: Data viz specialist. Task: Create a portfolio heatmap by risk score. Context: Data: Holdings, RiskScore, and Allocation. Output format: heatmap-ready data and interpretation notes. Constraints: ensure accessibility and export compatibility.
18. Debt service coverage: Role: Financial analyst. Task: Calculate debt service coverage for client cash flow. Context: Income, DebtService, and DebtBalance. Output format: CDS ratio table with thresholds. Constraints: flag covenant risk.
19. Expense by department: Role: Controller. Task: Break out expenses by department. Context: Data includes Department, Date, and Amount. Output format: pivot-ready summary and trend notes. Constraints: anonymize department names if needed.
20. Tax-efficient withdrawal: Role: Retirement planner. Task: Plan tax-efficient withdrawal strategy. Context: Portfolio with accounts by type. Output format: withdrawal schedule and tax impact table. Constraints: minimize tax drag.
21. Portfolio rebalancing checklist: Role: Advisor. Task: Create a rebalancing checklist. Context: Holdings, target weights, and constraints. Output format: checklist with justification and timing. Constraints: consider tax and cost.
22. Scenario: inflation impact: Role: Economist. Task: Model inflation impact on expenses and revenues. Context: Historical data and forecast. Output format: impact table and narrative. Constraints: include confidence intervals.
23. Share class analysis: Role: Research analyst. Task: Compare share classes by fees and performance. Context: Data includes class, expense ratio, and performance. Output format: comparison table and recommendation notes. Constraints: highlight cost trade-offs.
24. Fee comparison: Role: Advisor. Task: Compare advisory fees across accounts. Context: Fee schedules, AUM, and service levels. Output format: cost calculator and recommended billing approach. Constraints: protect client privacy.
25. Portfolio diversification check: Role: Analyst. Task: Assess diversification by asset class. Context: Data: AssetClass, Weight, Correlation. Output format: diversification score and action list. Constraints: avoid over-concentration.
26. Cost basis reconciliation: Role: Accountant. Task: Reconcile cost basis data. Context: Transactions with cost basis and dates. Output format: reconciled table and discrepancy notes. Constraints: flag missing cost data.
27. Forecast vs actual split: Role: Controller. Task: Split forecast vs actual by category. Context: Data: Forecast, Actual, Category. Output format: split view with variance explanation. Constraints: include remediation plan.
28. Seasonality decomposition: Role: Data scientist. Task: Decompose seasonality in sales data. Context: Monthly sales figures. Output format: seasonality components and forecast adjustment notes. Constraints: use additive model.
29. Client profitability by segment: Role: Advisor. Task: Compute client profitability by segment. Context: Data: Client, Revenue, CostToServe. Output format: profitability per segment with heat map. Constraints: anonymize client IDs.
30. Rolling return trends: Role: Portfolio manager. Task: Compute rolling returns. Context: Time series returns per holding. Output format: 12-month rolling return table and interpretation. Constraints: annotate anomalies.
31. Scenario: budget vs actual: Role: Finance analyst. Task: Compare budget to actual. Context: Budget and Actual tables by month. Output format: variance report with action items. Constraints: tie to strategic goals.
32. Sales-to-corporate funnel: Role: BI analyst. Task: Analyze sales to client funnel. Context: CRM data with阶段 stages and revenue. Output format: funnel breakdown and conversion notes. Constraints: ensure data quality.
33. Aging analysis: Role: Credit analyst. Task: Analyze accounts receivable aging. Context: AR ledger with due dates. Output format: aging buckets and collection recommendations. Constraints: flag overdue risks.
34. Portfolio scenario memo: Role: Advisor. Task: Write a scenario memo for a client. Context: Portfolio data and client goals. Output format: memo with assumptions and implications. Constraints: keep within client risk tolerance.
35. KPI dashboard widgets: Role: BI engineer. Task: Define KPI dashboard widgets. Context: Portfolio metrics and client goals. Output format: list of widgets with data sources. Constraints: ensure live-refresh capability.
36. Tax lot harvesting plan: Role: Tax strategist. Task: Plan tax lot harvesting. Context: Trade history and cost basis. Output format: plan with tax impact notes and timing. Constraints: avoid wash sale conflicts.
37. Currency exposure map: Role: FX analyst. Task: Map currency exposure. Context: Holdings with currency fields. Output format: exposure chart and hedging recommendations. Constraints: minimize transaction costs.
38. Income stability score: Role: Risk analyst. Task: Score income stability. Context: Revenue streams and volatility. Output format: stability score with drivers. Constraints: present mitigation options.
39. Debt maturity profile: Role: Treasury. Task: Analyze debt maturity profile. Context: Outstanding debt and maturities. Output format: maturity ladder and refinancing plan. Constraints: align with liquidity policy.
40. Model portfolio optimization: Role: Quant analyst. Task: Optimize portfolio given constraints. Context: Returns, risks, and constraints list. Output format: optimized weights and rationale. Constraints: avoid overfitting.
41. Client onboarding metrics: Role: Ops analyst. Task: Track onboarding metrics. Context: New accounts, time to setup, and errors. Output format: onboarding scorecard and recommendations. Constraints: protect client data.
42. R2 by segment: Role: Data scientist. Task: Compute R-squared by segment. Context: Regression results by client segment. Output format: R2 table and interpretation notes. Constraints: compare against baseline.
43. Withdrawal timing study: Role: Retirement planner. Task: Optimize withdrawal timing. Context: Age, tax bracket, and portfolio balance. Output format: schedule with tax impact notes. Constraints: minimize sequence of returns risk.
44. Performance attribution by manager: Role: Research analyst. Task: Attribute performance by manager. Context: Manager returns and benchmarks. Output format: attribution table and notes. Constraints: normalize for risk.
45. Scenario: growth vs value: Role: Market strategist. Task: Compare growth vs value under scenarios. Context: Factor exposure and returns. Output format: comparison table with insights. Constraints: cite data sources.
46. Portfolio turnover analysis: Role: Compliance analyst. Task: Monitor portfolio turnover. Context: Trade history with counts and costs. Output format: turnover ratio and policy notes. Constraints: flag excessive turnover.
47. Client risk profiling: Role: Advisor. Task: Update client risk profile. Context: Questionnaire results and holdings. Output format: updated risk tier with rationale. Constraints: ensure regulatory compliance.
48. Tax planning checklist: Role: Tax advisor. Task: Create tax planning checklist. Context: Client tax status and accounts. Output format: checklist with due dates. Constraints: avoid sensitive data exposure.
49. Portfolio drawdown analysis: Role: Risk manager. Task: Analyze worst-case drawdowns. Context: Historical drawdown data. Output format: drawdown report with recovery plan. Constraints: link to risk controls.
50. Client recommended actions: Role: Financial advisor. Task: Generate client action list. Context: Portfolio health and goals. Output format: prioritized action items with impact notes. Constraints: assign owners.
51. Expense normalization: Role: Analyst. Task: Normalize expenses across periods. Context: Multi-year expense data. Output format: normalized table and trend notes. Constraints: adjust for one-off events.
52. Interest rate sensitivity: Role: Strategist. Task: Measure rate sensitivity of bonds. Context: Bond holdings with duration. Output format: sensitivity table and hedging ideas. Constraints: account for currency effects.
53. Portfolio sector drift: Role: Portfolio manager. Task: Detect sector drift. Context: Sector weights vs benchmark. Output format: drift report and rebalancing rationale. Constraints: flag material drift.
54. Cash position watchlist: Role: Treasury analyst. Task: Create cash watchlist. Context: Cash levels, inflows, and upcoming needs. Output format: watchlist with triggers. Constraints: automate alerts.
55. Cost/benefit of advisory: Role: Compliance officer. Task: Evaluate advisory cost/benefit. Context: Services and fees. Output format: cost-benefit analysis with recommendations. Constraints: maintain client privacy.
56. Yield curve mapping: Role: Economist. Task: Map current yield curve. Context: Term structure data. Output format: curve plot data and interpretation. Constraints: alignment with macro view.
57. Scenario: market crash: Role: Risk analyst. Task: Model a market crash scenario. Context: Historical crash data and portfolio. Output format: crisis impact table and mitigation plan. Constraints: precautionary steps.
58. Portfolio codebook: Role: Data manager. Task: Create a portfolio data dictionary. Context: Data fields and definitions. Output format: codebook with examples. Constraints: keep versioned.
59. Data quality audit: Role: QA analyst. Task: Audit data quality. Context: Excel workbook with data validation rules. Output format: quality score and fixes. Constraints: report critical issues first.
60. Projection alignment: Role: Planner. Task: Align projections with goals. Context: Financial plan and assumptions. Output format: alignment score and notes. Constraints: track changes.
61. Account-level drilldown: Role: Analyst. Task: Drill down to account level. Context: Accounts with balances and activity. Output format: account-level report and recommendations. Constraints: aggregate for privacy.
62. Forecast accuracy heatmap: Role: Data scientist. Task: Create forecast accuracy heatmap. Context: Forecast vs actual by period and category. Output format: heatmap data and interpretation notes. Constraints: color-blind friendly.
63. Treasury risk dashboard: Role: Risk officer. Task: Build treasury risk dashboard. Context: Liquidity, rate, and funding risks. Output format: dashboard data with thresholds. Constraints: exportable to Excel.
64. Asset class correlation: Role: Quant analyst. Task: Compute correlations by asset class. Context: Returns by class and days. Output format: correlation matrix and notes. Constraints: report significant correlations.
65. Advisory utilization: Role: Operations. Task: Track service utilization. Context: Client service events and time spent. Output format: utilization report with suggestions. Constraints: protect sensitive timings.
66. Scenario: retirement horizon: Role: Planner. Task: Model retirement horizon effects. Context: Years to retirement and assets. Output format: horizon table and strategy notes. Constraints: honor risk tolerance.
67. Tax-adjusted performance: Role: Researcher. Task: Compute tax-adjusted performance. Context: After-tax returns data. Output format: performance table with tax rate notes. Constraints: compare to pre-tax.
68. Realtime data checks: Role: Data integrator. Task: Validate real-time data feeds. Context: Excel links and refresh schedules. Output format: data freshness report and fallback plan. Constraints: ensure data integrity.
69. Fee leakage audit: Role: Compliance. Task: Audit fee leakage. Context: Fee schedules versus charged fees. Output format: leakage report with remediation steps. Constraints: maintain client trust.
70. Portfolio sensitivity map: Role: Analyst. Task: Map portfolio sensitivity to inputs. Context: Key risk factors and exposure. Output format: sensitivity map and explanation notes. Constraints: present clearly.
71. Client onboarding KPI: Role: Ops lead. Task: Track onboarding KPIs. Context: New clients and setup times. Output format: KPI dashboard with improvement plan. Constraints: data privacy.
72. Cash flow stress test: Role: Risk manager. Task: Stress test cash flow. Context: Scenario with adverse conditions. Output format: stress test results and contingency actions. Constraints: keep assumptions explicit.
73. Debt covenant monitoring: Role: Compliance. Task: Monitor covenants. Context: Debt agreements and performance metrics. Output format: covenant status and alerts. Constraints: escalate breaches.
74. Scenario: growth trajectory: Role: Strategist. Task: Model growth trajectory. Context: Revenue drivers and costs. Output format: trajectory table and strategic notes. Constraints: align with risk appetite.
75. Pivot table blueprint: Role: Excel consultant. Task: Create pivot table blueprint. Context: Holdings data. Output format: pivot table layout with fields and filters. Constraints: ensure updateability.
76. Seasonal forecast pack: Role: Analyst. Task: Build seasonal forecast pack. Context: Monthly data and seasonality factors. Output format: forecast bundle with method notes. Constraints: reproducible.
77. Client credit analysis: Role: Credit analyst. Task: Assess client creditworthiness. Context: Payment history and balances. Output format: risk score and notes. Constraints: exclude sensitive data.
78. IRR by project: Role: Finance analyst. Task: Compute IRR by project. Context: Cash flows and initial investments. Output format: IRR table with recommendations. Constraints: ensure consistency.
79. Portfolio performance memo: Role: Advisor. Task: Write performance memo. Context: Portfolio performance vs goals. Output format: memo with data sources and caveats. Constraints: concise.
80. Cost basis aging: Role: Tax specialist. Task: Age cost basis data. Context: Transaction history. Output format: aging report and clean-up steps. Constraints: respect privacy.
81. Market regime tagging: Role: Strategist. Task: Tag market regimes in data. Context: Price data and indicators. Output format: regime labels and rationale. Constraints: consistent tagging rules.
82. Data validation rules: Role: QA engineer. Task: Define data validation rules for Excel workbook. Context: Data schema and validation tests. Output format: rule list and sample errors. Constraints: maintain clarity.
83. Client goals alignment: Role: Planner. Task: Align portfolio with client goals. Context: Goals and constraints. Output format: alignment score and action plan. Constraints: transparent assumptions.
84. Liquidity forecast drill: Role: Treasury. Task: Drill liquidity forecast. Context: Inflows, outflows, and contingencies. Output format: forecast with triggers. Constraints: real-time updates.
85. Tax bracket optimization: Role: Tax advisor. Task: Optimize withdrawals by tax bracket. Context: Tax scenario data. Output format: withdrawal plan with tax impact. Constraints: preserve capital.
86. Data reconciliation log: Role: Auditor. Task: Maintain data reconciliation log. Context: Reconciliation steps and results. Output format: log entries with timestamps. Constraints: auditable trail.
87. Benchmark impact notes: Role: Analyst. Task: Document benchmark impact notes. Context: Benchmark performance vs portfolio. Output format: notes with explanations. Constraints: avoid overclaiming.
88. Advisory risk memo: Role: Advisor. Task: Write risk memo for client strategy. Context: Market conditions and client risk. Output format: memo with action items. Constraints: client-friendly language.
89. Portfolio reallocation plan: Role: Portfolio manager. Task: Plan reallocation changes. Context: Current weights and target. Output format: plan with justification. Constraints: tax and costs considered.
90. Expense anomaly alerts: Role: Analyst. Task: Detect expense anomalies. Context: Category, date, amount. Output format: alert list with原因 notes. Constraints: false positives minimized.
91. Scenario: geopolitical risk: Role: Risk analyst. Task: Assess geopolitical risk impact. Context: Portfolio exposure data. Output format: risk assessment and mitigation steps. Constraints: concise.
92. Export-ready reports: Role: Reporting engineer. Task: Create export-ready report templates. Context: Portfolio data. Output format: Excel-ready reports with instructions. Constraints: maintain consistency.
93. Client retention forecast: Role: Marketing analyst. Task: Forecast client retention. Context: Client activity and engagement. Output format: retention forecast and actions. Constraints: data privacy.
94. Data storytelling notes: Role: Analyst. Task: Prepare data storytelling notes. Context: Key metrics and insights. Output format: narrative with charts references. Constraints: avoid fluff.
95. Advisory service scoring: Role: Ops. Task: Score advisory service utilization. Context: Services used and outcomes. Output format: scorecard with improvement plan. Constraints: privacy.
96. Portfolio construction rules: Role: Quant. Task: Define construction rules. Context: Constraints and objectives. Output format: rule set with examples. Constraints: unambiguous.
97. Client data anonymization: Role: Data manager. Task: Anonymize client data for analysis. Context: Client dataset. Output format: anonymized data spec and sample. Constraints: remove PII.
98. Regulatory compliance check: Role: Compliance. Task: Check Excel outputs for compliance. Context: Regulations and client data. Output format: compliance checklist and notes. Constraints: cite regulations.
99. Annual plan alignment: Role: Planner. Task: Align annual plan with data. Context: Financial projections and goals. Output format: alignment report. Constraints: traceable assumptions.
100. Executive summary generator: Role: Assistant. Task: Generate executive summary from portfolio data. Context: Key metrics and insights. Output format: concise 1-page summary with bullet points. Constraints: focus on insights.

Best Practices

• Use clear role and task definitions to anchor Gemini behavior.
• Ask for outputs with reproducible formats and export-ready data.
• Always specify data ranges, timeframes, and thresholds.
• Test prompts on small datasets to validate accuracy before scaling.
• Document assumptions and maintain data privacy in every output.

Common Mistakes to Avoid

• Using vague goals like analyze the data without specifying metrics.
• Overloading prompts with too many constraints, causing confusion.
• Neglecting data privacy or compliance considerations in outputs.
• Not specifying the required output format, leading to inconsistent results.
• Assuming Excel data is clean; prompts should include data quality checks.

FAQ

What makes these prompts practical for Excel data analysis?

They specify roles, tasks, data context, outputs, and constraints to produce ready-to-use Excel analyses for financial advisory tasks.

How should I adapt prompts to my client data?

Replace placeholders with your actual client data fields, timeframes, and reporting preferences; keep data privacy in mind.

Can I export Gemini results to Excel dashboards?

Yes, prompts can request outputs formatted as tables and chart-ready data suitable for Excel dashboards.

Do prompts cover risk and cash flow analyses?

Yes, many prompts specifically target risk metrics, liquidity, and cash flow forecasting for advisors.

How can I ensure data quality with these prompts?

Include data quality checks in the prompts and validate results against source data before sharing with clients.

Are these prompts suitable for beginners and pros?

Yes, prompts include clear roles and contexts and can be adjusted for skill level and data complexity.