100 Best ChatGPT Excel Data Analysis Prompts for Financial Advisors

Direct Answer

The best ChatGPT prompts for Excel data analysis for financial advisors are a curated set of 100 specific, actionable prompts that cover portfolio analytics, risk assessment, tax planning, cash flow forecasting, and client reporting. Each prompt is designed to be copyable with placeholders and outputs clearly defined to avoid ambiguity.

Introduction

This page is a practical prompt library focused on Excel data analysis for financial advisors. It helps professionals perform rigorous analyses directly in Excel with clear inputs, processes, and outputs.

The prompts are designed for financial advisors, planners, and analysts who want repeatable, auditable analyses that support client conversations and decision making.

How to Use These ChatGPT Prompts

• Replace placeholders like [constraints], [data], and [tone] with your actual values.
• Add any required constraints or formats before running the prompt to ensure outputs meet your needs.
• Ask for outputs in a specific format (CSV, table, bullet list) and request a short justification when results are ambiguous.
• Verify outputs by cross-checking a sample of results against source data, especially for large datasets.
• Consider saving each prompt as a template and documenting any deviations for auditability.
• Adapt prompts to suit your Excel version and data structure for best results.

100 Best ChatGPT Excel Data Analysis Prompts for Financial Advisors

1. Portfolio KPI extraction: You are a financial analyst. Task: extract key portfolio KPIs from an Excel workbook. Context: workbook contains holdings, prices, and weights. Output: provide a table with TWRR, MWRR, annualized return, volatility, Sharpe ratio, and beta by sector. Format: CSV table with columns: KPI, Value, Unit, Notes. Constraints: handle missing data as N/A, explain any data gaps in a brief note.
2. Benchmark comparison setup: You are a data analyst for a financial practice. Task: compare client portfolios to a benchmark index using daily price data in Excel. Context: include start date, end date, and equal-weighted benchmark. Output: a side-by-side table showing relative return, tracking error, and information ratio. Format: a two-column table with Portfolio vs Benchmark, plus a summary paragraph. Constraints: include data source citations in a separate notes field.
3. Expense ratio audit: You are an analyst auditing expense data in Excel. Task: identify all expense lines with rates exceeding [constraints]. Context: workbook has expense categories and rates. Output: list of high-expense lines with category, rate, date, and recommended action. Format: bullet list; provide one-sentence rationale per line. Constraints: flag anomalies where rate > [maxRate], and group by category.
4. Cash flow forecast build: You are a financial planner. Task: create a monthly cash flow forecast in Excel. Context: projected inflows, outflows, and investment income. Output: a table with month, net cash flow, cumulative cash position, and a chart-ready column for visualization. Constraints: incorporate seasonality factors and show a scenario with 10% revenue growth. Format: tabular data plus a short bullet-based forecast summary.
5. Client cohort trends: You are a data analyst for practice performance. Task: analyze client retention and average AUM by cohort in Excel. Context: client signup date and AUM data. Output: cohort table by quarter with retention rate, average AUM, and ARPU. Format: 2D table and a compact explanation paragraph. Constraints: include heatmap-friendly numeric ranges.
6. Risk-adjusted return drill: You are a risk analyst. Task: compute risk-adjusted returns for each holding using Excel. Context: inputs include price history and risk-free rate. Output: per-holding metrics: annualized return, standard deviation, beta, and Sharpe ratio. Format: CSV-like table; provide a one-line conclusion per row. Constraints: use 252 trading days for annualization.
7. Scenario analysis builder: You are a scenario planner. Task: build three macroeconomic scenarios in Excel. Context: base case, optimistic, pessimistic with growth, inflation, and rates inputs. Output: a 3-scenario summary table and a recommended action for each. Constraints: label scenarios clearly and show impact on portfolio value in dollars.
8. Tax lot tracking: You are a tax advisor. Task: optimize after-tax gains by identifying tax lots in Excel. Context: cost basis, lots, and holding periods. Output: summary of optimal lot sales with tax impact, plus a transfer log. Format: compact bullets with a final recommended action.
9. Rolling beta estimation: You are a quantitative analyst. Task: compute rolling beta of portfolio to benchmark in Excel. Context: daily prices; window size 60 days. Output: a column of beta values, plus a chart-ready series for visualization. Constraints: handle missing data with linear interpolation.
10. Correlation heatmap: You are a data analyst. Task: generate a correlation heatmap of asset returns in Excel. Context: daily returns for all assets over the past 36 months. Output: correlation matrix with annotations for significant correlations. Format: table suitable for charting; include p-values in a notes column. Constraints: mask insignificant correlations below 0.15.
11. Portfolio rebalancing plan: You are a portfolio manager. Task: create a rebalancing plan in Excel. Context: current vs target weights by asset class, tax considerations. Output: rebalancing trades with quantities, estimated transaction costs, and new target weights. Format: list with rationales for each trade. Constraints: minimize turnover by using thresholds.
12. Monte Carlo projection: You are a risk analyst. Task: run a Monte Carlo projection for portfolio value over 20 years in Excel. Context: historical return distribution and volatility. Output: 5000 simulation results with 5-number summary. Format: CSV with summary row and a histogram-ready column. Constraints: seed 42 for reproducibility.
13. Expense-to-income ratio: You are a financial planner. Task: calculate expense-to-income ratio across multiple client accounts in Excel. Context: monthly expenses and income per client. Output: per-client ratio, average ratio, and top 5 outliers. Format: table plus a brief interpretation.
14. GARP risk scoring: You are a risk officer. Task: assign a GARP-like risk score to each asset using Excel. Context: volatility, drawdown, liquidity. Output: asset list with score 1-10 and justification. Format: table with color-coded score band in notes.
15. Performance attribution: You are an equity analyst. Task: perform simple performance attribution in Excel. Context: contributions from allocation and selection for a period. Output: attribution by asset and total attribution. Format: table plus a narrative summary. Constraints: report both relative and absolute performance.
16. Client reporting pack: You are a client reporting specialist. Task: assemble a 1-page Excel client report template. Context: performance, cash flows, fees, and risk metrics. Output: compact, presentation-ready sheet with 2 charts and a summary box. Constraints: ensure data provenance is clear.
17. Portfolio drawdown analysis: You are a risk analyst. Task: identify maximum drawdown periods in Excel. Context: daily prices across holdings. Output: drawdown table with start date, end date, max drawdown %, and recovery days. Format: concise report section.
18. Liquidity screening: You are a compliance-focused analyst. Task: screen assets for liquidity risk in Excel. Context: bid-ask spreads, daily volumes, and assets’ liquidity scores. Output: list of assets flagged with risk level and suggested mitigations. Constraints: provide actionable next steps.
19. Tax-aware harvest: You are a tax optimization consultant. Task: identify tax-loss harvesting candidates in Excel. Context: lots, cost basis, and gains. Output: recommended harvest actions with tax impact and timing. Format: bullet list with justification.
20. Scenario-based client briefing: You are a financial adviser. Task: generate a client-friendly briefing in Excel. Context: portfolio performance, risk, and forward scenarios. Output: a brief, easy-to-understand one-page sheet with a narrative and visuals. Constraints: avoid jargon and explain terms.
21. Data validation rules: You are a data integrity specialist. Task: create Excel data validation rules for client data imports. Context: required fields, formats, and error messages. Output: a validation plan with sample rules and a test checklist. Constraints: include fallback plans for malformed data.
22. Benchmark drift alert: You are a portfolio analyst. Task: detect benchmark drift in Excel. Context: portfolio vs benchmark over time. Output: drift percentage, dates of drift, and recommended corrective actions. Format: table and comment field.
23. Robo-advisor style report: You are a financial technician. Task: create a robo-advisor style report layout in Excel. Context: client profile, risk tolerance, and target allocation. Output: auto-filled sections with recommendations and caveats. Constraints: ensure accessibility for non-experts.
24. Cost basis reconciliation: You are an accountant. Task: reconcile cost basis across datasets in Excel. Context: multiple import formats. Output: reconciled cost basis per asset and a discrepancy log. Constraints: flag unresolved items.
25. Tax projection workbook: You are a tax planner. Task: build a year-by-year tax projection in Excel. Context: income, deductions, credits. Output: tax by year, effective rate, and a cash tax forecast. Constraints: include sensitivity to income changes.
26. Portfolio liquidity map: You are a liquidity analyst. Task: map portfolio liquidity by time-to-liquidate horizon in Excel. Context: asset class, bid-ask spreads, redemption constraints. Output: liquidity scores and a heatmap-ready table. Constraints: categorize by horizon buckets.
27. Scenario comparison dashboard: You are a data visualization specialist. Task: build a dashboard comparing three scenarios in Excel. Context: returns, risk, and cash needs. Output: a dashboard with interactive filters and a 1-page executive summary. Constraints: ensure export to PDF looks balanced.
28. Active vs passive split: You are a strategist. Task: quantify active vs passive exposure in Excel. Context: holdings by strategy and performance. Output: percentage split, attribution, and a narrative note. Constraints: normalise by AUM.
29. Drawdown recovery plan: You are a portfolio manager. Task: create a recovery plan after a drawdown. Context: current capital, target recovery horizon, and risk limits. Output: steps, milestones, and projected capital path. Constraints: include risk controls.
30. Cost optimization scan: You are a finance analyst. Task: identify cost-saving opportunities in the portfolio operations in Excel. Context: recurring costs, advisory fees, and brokerage. Output: list of savings with estimated impact and timelines. Constraints: prioritise high-impact items.
31. Portfolio attribution drill: You are a research analyst. Task: drill down attribution by sector in Excel. Context: performance by sector, weights, and returns. Output: sector-level attribution with a closing summary. Constraints: maintain granularity.
32. Client segment profitability: You are a client analytics specialist. Task: compute profitability by client segment in Excel. Context: revenue, costs, and assets under management per client. Output: segment P&L with margin and trend indicators. Constraints: compare to benchmark segments.
33. Scenario-driven reallocation: You are a strategy analyst. Task: propose reallocation actions under a scenario in Excel. Context: constraints, taxes, and risk. Output: recommended trades with rationales and expected outcomes. Constraints: limit turnover to a defined threshold.
34. Portfolio risk heatmap: You are a risk manager. Task: generate a risk heatmap in Excel. Context: multiple risk factors per asset. Output: color-coded risk grid with mitigation notes. Constraints: publish with 4 risk bands.
35. Sector exposure audit: You are a compliance analyst. Task: audit sector exposure for concentration risk in Excel. Context: exposure by sector and regulatory limits. Output: list of over-concentrated sectors with action items. Constraints: include proposed diversification moves.
36. Dividend cash flow model: You are a financial planner. Task: model dividend cash flows in Excel. Context: dividend yield, payout ratios, and tax treatment. Output: monthly dividend forecast and cumulative receipts. Constraints: assume stable payout growth.
37. Margin impact study: You are a finance analyst. Task: assess margin impact of portfolio trades in Excel. Context: commission costs, bid-ask spreads, and taxes. Output: margin-adjusted P&L per trade and total. Constraints: present as net figures.
38. Portfolio cleanup checklist: You are a data hygiene specialist. Task: create a cleanup checklist for portfolios in Excel. Context: duplicates, missing data, inconsistent tickers. Output: checklist with remediation steps and ownership.
39. Currency exposure map: You are a forex analyst. Task: map currency exposure in an international portfolio in Excel. Context: FX hedges, base currency, and revaluation effects. Output: exposure summary by currency and a hedging plan. Constraints: quantify hedge effectiveness.
40. Tax lot grouping: You are a tax data analyst. Task: group tax lots for optimal harvesting in Excel. Context: lot IDs, date, and cost. Output: grouped lots with recommended harvest order and tax impact. Constraints: minimize wash sale risk.
41. Client cohort report: You are a client analytics professional. Task: produce a cohort report in Excel. Context: client signup date and assets. Output: cohort retention and AUM growth by cohort over time. Constraints: include confidence notes.
42. Scenario impact summary: You are a portfolio strategist. Task: summarize scenario impacts in Excel. Context: three macro scenarios with impact on value. Output: one-page summary with key drivers and actions. Constraints: keep it concise.
43. Return dispersion analysis: You are a performance analyst. Task: analyze return dispersion across holdings in Excel. Context: period, market conditions. Output: dispersion table and a short interpretation.
44. Client risk profiling: You are a consultant. Task: map client risk profiles to portfolios in Excel. Context: risk tolerance scores, time horizon, and goals. Output: alignment report with recommended adjustments. Constraints: show trade-offs.
45. Turnover impact report: You are a portfolio analyst. Task: quantify turnover impact in Excel. Context: trades, costs, and tax implications. Output: turnover table with cost and tax estimates. Constraints: compare to baseline.
46. Performance vs benchmark: You are a performance officer. Task: compute performance versus benchmark in Excel. Context: period, weights, and benchmarks. Output: table of excess return, tracking error, and summary. Constraints: normalise to a common base.
47. Client-ready visuals: You are a design-focused analyst. Task: craft client-friendly visuals in Excel. Context: performance, risk, and allocations. Output: 2 charts and a one-line caption per chart. Constraints: accessible color palette.
48. Data provenance log: You are a data governance analyst. Task: create a data provenance log in Excel. Context: data sources, import times, and owners. Output: log by dataset with status and quality notes. Constraints: audit-ready.
49. Asset-level notes: You are a portfolio manager. Task: attach notes to each asset in Excel. Context: rationale for inclusion, risk, and liquidity. Output: notes column with concise rationale and a scoring tag. Constraints: keep each note to two sentences.
50. Scenario-ready exports: You are a reporting specialist. Task: prepare scenario-ready export templates in Excel. Context: data fields required for each scenario. Output: clean exports with headers and sample rows. Constraints: ensure compatibility with downstream systems.
51. Drawdown drilldown: You are a risk analyst. Task: drill down drawdown data by date and asset in Excel. Context: daily series. Output: multi-row drilldown with recoveries and causes. Constraints: include a short narrative.
52. Liquidity stress test: You are a liquidity planner. Task: run a liquidity stress test in Excel. Context: withdrawal shocks and market gaps. Output: liquidity shortfall scenarios with mitigation steps. Constraints: include recovery probabilities.
53. Tax-smart rebalancing: You are a tax-optimization advisor. Task: plan tax-smart rebalancing in Excel. Context: tax lots, wash-sale rules, and timing. Output: recommended rebalance with tax impact and notes. Constraints: minimize tax drag.
54. Asset correlation review: You are a risk analyst. Task: review asset correlations in Excel. Context: recent data window and significance. Output: correlation changes with notes and implications. Constraints: flag unstable correlations.
55. Portfolio education sheet: You are a client educator. Task: create an educational sheet in Excel. Context: terms and concepts used in the report. Output: glossary, quick definitions, and a FAQ panel. Constraints: explain in plain language.
56. Client data checklist: You are a dataOps engineer. Task: build client data import checklist in Excel. Context: fields, formats, and validation. Output: step-by-step checklist with owner and due dates. Constraints: include error-handling rules.
57. Target asset allocation: You are a portfolio planner. Task: compute target asset allocation from goals in Excel. Context: risk tolerance, horizon, and constraints. Output: target weights with a sensitivity note. Constraints: show alternative allocations.
58. Performance snapshot: You are a client reporting specialist. Task: generate a quick performance snapshot in Excel. Context: period returns, YTD, and trailing returns. Output: one-page summary with color-coded performance bars. Constraints: include benchmark comparison.
59. Fee analysis: You are a financial analyst. Task: analyze fees across accounts in Excel. Context: advisory fees, fund expenses, and commissions. Output: fee breakdown by category and total annual cost. Constraints: benchmark against peers.
60. Tax impact deltas: You are a tax analyst. Task: compute tax impact deltas for trade scenarios in Excel. Context: short-term vs long-term gains and tax brackets. Output: delta tax amounts and effective rate per scenario.
61. Scenario narrative notes: You are a communications specialist. Task: add scenario notes to Excel outputs. Context: scenario definitions and assumptions. Output: concise narrative for each scenario to accompany charts. Constraints: keep under two sentences per scenario.
62. Backtest summary: You are a research analyst. Task: summarize backtest results in Excel. Context: period, universe, and turnover. Output: summary table with metrics and caveats. Constraints: disclose data limitations.
63. Benchmark attribution: You are a performance auditor. Task: attribute performance to benchmark components in Excel. Context: index constituents and weightings. Output: attribution by component with totals. Constraints: align with period.
64. Cash flow sensitivity: You are a financial planner. Task: compute cash flow sensitivity to income changes in Excel. Context: client budgets and expenses. Output: sensitivity matrix and recommended buffers. Constraints: include confidence intervals.
65. Scenario risk watch: You are a risk manager. Task: watch for scenario risks in Excel. Context: three scenarios and thresholds. Output: alert list for breaches with recommended actions. Constraints: auto-highlight in red.
66. Tax filing checklist: You are a tax advisor. Task: generate a tax filing checklist in Excel. Context: client documents and deadlines. Output: checklist with statuses and reminders. Constraints: customize per jurisdiction.
67. AUM trend analysis: You are a client analytics specialist. Task: analyze AUM trends in Excel. Context: monthly AUM data and inflows/outflows. Output: trend line, growth rate, and a short interpretation.
68. Portfolio risk overlay: You are a risk strategist. Task: overlay multiple risk metrics on a single Excel sheet. Context: VaR, CVaR, and volatility. Output: composite risk score with rationale. Constraints: normalize scales.
69. Growth vs income split: You are a portfolio designer. Task: split a portfolio into growth and income components in Excel. Context: asset classes and expected returns. Output: two allocation scenarios with rationale. Constraints: show risk implications.
70. Expense trend visualization: You are a data viz analyst. Task: visualize expense trends in Excel. Context: monthly costs by category. Output: line chart and annotation notes. Constraints: ensure readability.
71. Scenario optimization: You are a optimization specialist. Task: optimize portfolio for a scenario in Excel. Context: objective, constraints, and risk. Output: optimized weights and sensitivity table. Constraints: document convergence criteria.
72. Liquidity forecast by horizon: You are a liquidity analyst. Task: forecast liquidity by time horizon in Excel. Context: short, medium, long-term needs. Output: horizon-based liquidity table and recommended buffers. Constraints: include worst-case scenario.
73. Tax-efficient switching: You are a tax strategist. Task: propose tax-efficient portfolio switches in Excel. Context: holdings, lots, and tax lots. Output: switch list with tax impact and timing. Constraints: avoid wash-sale triggers.
74. Asset weight sanity check: You are a data quality engineer. Task: run a sanity check on asset weights in Excel. Context: sum to 100%, non-negative. Output: report with any anomalies and remediation steps. Constraints: auto-correct options.
75. Portfolio heat map: You are a data viz expert. Task: create a heat map of portfolio metrics in Excel. Context: returns, risk, and liquidity. Output: color-coded grid with notes. Constraints: ensure export-ready.
76. Client data summary: You are a client services analyst. Task: summarize client data for reporting in Excel. Context: client name, AUM, risk, goals. Output: concise summary sheet with tabs for details. Constraints: protect sensitive data.
77. Performance tail analysis: You are a research analyst. Task: analyze tail performance in Excel. Context: bottom and top deciles. Output: tail performance table and narrative. Constraints: mention potential biases.
78. Recession readiness: You are a strategy analyst. Task: assess portfolio readiness for recession in Excel. Context: defensive vs cyclical exposure. Output: readiness score and recommended tweaks. Constraints: justify changes.
79. Currency hedge plan: You are a hedging specialist. Task: design currency hedges in Excel. Context: base currency, hedge ratio, costs. Output: hedge plan with scenarios and break-even points. Constraints: include expected impact.
80. Tax basis watcher: You are a tax data steward. Task: monitor tax basis changes in Excel. Context: import feeds and reconciliation. Output: basis drift report and recommended fixes. Constraints: alert on anomalies.
81. Asset-level heatmap: You are a portfolio analyst. Task: create an asset-level heatmap in Excel. Context: performance, risk, liquidity. Output: heatmap with asset tags and notes. Constraints: color scale clarity.
82. Portfolio drift check: You are an audit analyst. Task: check portfolio drift in Excel. Context: weights vs targets over time. Output: drift report and corrective actions. Constraints: show delta in percentage points.
83. Rising-rate adjustments: You are a fixed income analyst. Task: adjust portfolio for rising rates in Excel. Context: duration, yield changes. Output: list of trades with rationale and risk notes. Constraints: avoid excessive turnover.
84. ESG data sync: You are an data integration specialist. Task: synchronize ESG data into Excel. Context: scoring sources and frequency. Output: harmonized ESG scores per asset and caveats. Constraints: handle missing data gracefully.
85. Roll-forward scenario: You are a forecasting analyst. Task: roll-forward a scenario in Excel. Context: current state and year-ahead assumptions. Output: year-ahead forecast with confidence intervals. Constraints: document assumptions.
86. Performance disclosure: You are a compliance officer. Task: generate performance disclosures in Excel. Context: methodology, data limitations. Output: standard disclosure blocks with placeholders. Constraints: ensure accuracy.
87. Trade impact ledger: You are a trading desk analyst. Task: track trade impacts in Excel. Context: trade date, instrument, costs, and taxes. Output: ledger with running totals. Constraints: reconcile with statements.
88. Client goals map: You are a planning specialist. Task: map client goals to portfolio actions in Excel. Context: goals, time horizons, and constraints. Output: goals-to-actions matrix with progress indicators. Constraints: quantify impact.
89. Tax-efficient withdrawals: You are a retirement planner. Task: plan tax-efficient withdrawal sequencing in Excel. Context: age, tax brackets, and accounts. Output: withdrawal order with tax impact and liquidity notes.
90. Yield curve modeling: You are a fixed income modeler. Task: model yield curves in Excel. Context: multiple maturities and scenarios. Output: curve fit with 95% confidence bands and chart-ready data.
91. Account-level reconciliation: You are a controller. Task: reconcile accounts in Excel. Context: ledger balances, transactions, and dates. Output: reconciliation report with discrepancies and actions.
92. Capital needs forecast: You are a planning analyst. Task: forecast capital needs in Excel. Context: business plan, milestones, and runway. Output: cash needs by quarter and buffer recommendations.
93. Client-friendly glossary: You are a content designer. Task: build a glossary for client reports in Excel. Context: common terms and definitions. Output: glossary with quick examples and links to sections.
94. Portfolio diversification check: You are a risk analyst. Task: check diversification across assets in Excel. Context: concentration metrics and correlation. Output: diversification score with improvement suggestions.
95. Data quality score: You are a data governance lead. Task: rate data quality of Excel inputs. Context: accuracy, completeness, timeliness. Output: quality score + action plan.
96. Cost center accounting: You are a finance administrator. Task: assign costs to client accounts in Excel. Context: activities and cost drivers. Output: cost per client with total and variances.
97. Performance wrap-up: You are a client services analyst. Task: produce a performance wrap-up in Excel. Context: period performance, risk, and fees. Output: one-page summary with charts and bullets. Constraints: keep concise.
98. Forecast accuracy audit: You are an analytics auditor. Task: audit forecast accuracy in Excel. Context: forecasted vs actual by period. Output: accuracy metrics and action suggestions. Constraints: highlight biases.
99. Trade compliance log: You are a compliance officer. Task: maintain a trade compliance log in Excel. Context: trades, limits, and approvals. Output: log with flags for violations and resolution.
100. Excel templates library: You are a template curator. Task: assemble a reusable Excel data-analysis template library for financial advisors. Context: common analyses and visuals. Output: list of 10 starter templates with purpose and data requirements. Constraints: ensure templates are modular and documented.

Best Practices

• Use clear data labeling and consistent units across sheets to improve prompt accuracy.
• Keep prompts modular; combine multiple prompts for complex analyses but validate each step independently.
• Document assumptions, data sources, and limitations alongside outputs for client transparency.
• Test prompts with small datasets before scaling to full portfolios to catch edge cases.
• Set up access controls and versioning to maintain data security and reproducibility.

Common Mistakes to Avoid

• Using vague terms like 'analyze performance' without specifying metrics or time windows.
• Neglecting data validation or missing data handling, leading to biased results.
• Overcomplicating prompts with too many requirements that make outputs brittle.
• Assuming Excel features are available without verifying software version.
• Failing to document assumptions and data provenance, reducing auditability.

FAQ

What makes these prompts practical for Excel analysis?

They specify role, task, context, outputs, and constraints so you can run them with minimal setup.

How should I placeholder data when using prompts?

Replace placeholders like [constraints], [data], and [tone] with your actual values before running the prompt.

Can these prompts be used in older Excel versions?

Most prompts rely on standard Excel features; adapt any advanced steps to available tools in older versions.

How do I verify the outputs?

Cross-check a sample of results against source sheets and compare key metrics to known benchmarks.

Are the prompts suitable for client reporting?

Yes, many prompts produce portfolio analytics and visuals that can be shared in client-ready packs.

Where can I find related prompts?

Explore related prompt libraries and Excel analytics pages on the site for broader coverage.