Topic # Excel & Modeling Formulas, functions, Power Query, Python in Excel and financial modeling technique. 88 articles ## A practical guide to this topic Financial modeling in Excel links inputs, assumptions and calculations to financial outcomes. Useful models are understandable and repeatable: readers can see which figures are inputs, how they are transformed and what changes when an assumption moves. For spreadsheet analysts improving a repeatable finance task and finance managers reviewing model outputs. The archive covers both spreadsheet technique and the work around a workbook. Formula tools, Python analysis and data preparation address different problems. Start by naming the task: cleaning a recurring export, comparing budget and actuals, matching records, or presenting a result. The choice of technique should follow that task rather than the novelty of a feature. A model is not automatically governed because it lives in Excel or uses a new add-in. Teams still need agreed source data, clear versions and a way to review outputs. The connected FP&A guide explains why consolidating and controlling inputs can matter as much as changing formulas. Python in Excel introduces programmatic analysis within cells, but statistical assumptions and exceptions still need review. Use the learning path to move from spreadsheet options into repeatable analysis and reporting. It is suitable for finance users who want to extend an existing workbook rather than replace everything. Budgeting and forecasting supplies the business questions a model should answer; reporting and automation connects the model to reliable actuals and recurring delivery. ### Tasks to explore - Prepare recurring data inputs - Build a variance comparison - Explore Python analysis in cells - Evaluate a task-specific add-in ### A learning path - [Python in Excel for FP&A](/post/python-in-excel-for-fpa) - [The Guide to Creating a Variance Analysis Report in Excel](/post/creating-variance-analysis-report-in-excel) - [Best Excel Plugins: Free, Paid, and AI Add-Ins](/post/best-excel-plugins-free-paid-and-ai-add-ins) - [Getting Real FP&A Automation While Staying in Excel](/post/getting-real-fpa-automation-staying-in-excel) ### Common questions #### Does Python replace spreadsheet modeling? It can extend analysis within Excel; existing inputs, models and review routines still matter. #### What should drive add-in selection? The task, compatibility and control requirements—not simply whether a product is described as AI-enabled. #### Why examine data handoffs? Repeated exporting and pasting can create reconciliation and version problems before modeling starts. Connect this topic with [Budgeting & Forecasting](/topics/budgeting-forecasting) and [Reporting & Automation](/topics/reporting-automation). See the [Knowledge directory](/knowledge) and [glossary](/glossary) for more reading routes. [![](/__l5e/assets-v1/3a8a2eae-4a80-423a-9900-5c4ce1cdc633/orig-500eed15e75a-Excels-Limitations-When-It-Comes-to-FPA.jpg)](/post/excels-limitations-fpa) Budgeting & Forecasting7 min read ### [Excel’s Limitations When It Comes to FP&A](/post/excels-limitations-fpa) Excel has been a popular workspace of finance for decades, and for good reason. It is flexible, familiar, and powerful… James Richard · November 1, 2026 [![](/__l5e/assets-v1/19d39af2-f416-4cf9-b423-ad2cb8bbed69/orig-cb272cf26a41-Getting-Real-FPA-Automation-While-Staying-in-Excel.jpg)](/post/getting-real-fpa-automation-staying-in-excel) Reporting & Automation7 min read ### [Getting Real FP&A Automation While Staying in Excel](/post/getting-real-fpa-automation-staying-in-excel) Most finance teams have no intention of abandoning Microsoft Excel, and they shouldn’t have to. You can get real FP&A… James Richard · October 3, 2026 [![](/__l5e/assets-v1/368cea88-b459-4920-8532-ba8352ad32f3/orig-94ddd3ce880f-Questions-to-Ask-on-a-Demo-for-Native-Excel-FPA-Software.jpg)](/post/questions-to-ask-on-a-demo-for-native-excel-fpa-software) Budgeting & Forecasting7 min read ### [Questions to Ask on a Demo for Native Excel FP&A Software](/post/questions-to-ask-on-a-demo-for-native-excel-fpa-software) Every FP&A vendor’s homepage says some version of “works with Excel.” That phrase covers three genuinely different products, and a… James Richard · September 17, 2026 [![](/__l5e/assets-v1/d3581afe-d700-48c3-b0cc-6cd4eb660440/orig-d41752b4ba85-AI-Will-Make-Excel-Even-More-Popular-Than-It-Is-Today.jpg)](/post/ai-will-make-excel-even-more-popular) AI for Finance5 min read ### [AI Will Make Excel Even More Popular Than It Is Today](/post/ai-will-make-excel-even-more-popular) AI will make Excel even more popular, not less, and the numbers support it. For years, the prevailing narrative in… James Richard · August 28, 2026 [![](/__l5e/assets-v1/1b9c8648-eacf-430e-9f4e-1eaa94bc7be3/orig-0eaaf7f38787-Forecasting-has-Become-More-Difficult-with-the-Token-and-Credit-Models.jpg)](/post/forecasting-token-credit-models) Budgeting & Forecasting6 min read ### [Forecasting has Become More Difficult with the Token and Credit Models](/post/forecasting-token-credit-models) Forecasting has become more difficult with token and credit models because revenue now depends on how customers use a product,… James Richard · August 23, 2026 [![](/__l5e/assets-v1/b9fdeaf6-2751-4d5b-8ba4-d9523f6c7133/orig-84e5c8dd3f71-57-of-Finance-Leaders-Missed-Opportunities-Due-to-Delayed-Data.jpg)](/post/supply-chain-ai-data-foundation) AI for Finance5 min read ### [Supply Chain AI is Only as Strong as Its Data Foundation](/post/supply-chain-ai-data-foundation) Supply chain Artificial Intelligence (AI) is only as strong as its data foundation because AI models depend on accurate, connected,… James Richard · July 31, 2026 [![](/__l5e/assets-v1/756473ee-0e27-42ab-83d5-19e7077042c0/orig-7eccbabbc6ee-Why-Uploading-a-Spreadsheet-to-Chatbots-is-Not-an-AI-Finance-Strategy.jpg)](/post/why-uploading-spreadsheets-is-not-an-ai-finance-strategy) AI for Finance5 min read ### [Why Uploading a Spreadsheet to Chatbots is Not an AI Finance Strategy](/post/why-uploading-spreadsheets-is-not-an-ai-finance-strategy) Uploading a spreadsheet to ChatGPT or another AI chatbot is not an AI finance strategy because it relies on static,… James Richard · July 20, 2026 [![](/__l5e/assets-v1/3be951a0-c275-4943-9d39-b6ffdc119bdf/e23c059c-a70c25_31cb10332ff949bc829caec6f55396d0mv2.png)](/post/top-excel-influencers) Reporting & Automation7 min read ### [Top Excel influencers](/post/top-excel-influencers) Top Excel influencers are professionals who help users master Microsoft Excel through practical tutorials, financial modeling techniques, dashboard design, automation… James Richard · July 11, 2026 [![](/__l5e/assets-v1/a8fda407-189d-4b65-937d-cbfd3289ef67/orig-173dd7208bc6-Top-Excel-AI-Plugins.jpg)](/post/top-excel-ai-plugins) AI for Finance10 min read ### [Top AI Plugins for Excel](/post/top-excel-ai-plugins) Top Excel AI plugins help users automate spreadsheet work, generate formulas, analyze large datasets, and produce insights faster without leaving… James Richard · June 21, 2026 [![](/__l5e/assets-v1/1b569318-612d-4205-ae9a-b2e41db0fd3d/orig-7337dc92e16d-AI-in-Excel-for-CPM-Software.jpg)](/post/ai-in-excel-for-cpm-software) AI for Finance5 min read ### [AI in Excel for CPM Software](/post/ai-in-excel-for-cpm-software) AI in Excel for CPM software combines the flexibility of spreadsheets with the governance, automation, and data integrity of modern… James Richard · June 14, 2026 [![](/__l5e/assets-v1/1896af86-7062-4fb7-b821-0beb9189b0e4/orig-a79cf99d2f84-Top-Excel-AI-Podcast-Episodes.jpg)](/post/top-excel-ai-podcast-episodes) AI for Finance4 min read ### [Top Excel AI Podcast Episodes](/post/top-excel-ai-podcast-episodes) Finance professionals, analysts, and enterprise tech teams are increasingly turning to top Excel AI podcasts to stay ahead of developments… James Richard · May 12, 2026 [![](/__l5e/assets-v1/6b7f7ce5-b074-45af-ac53-f0991311f6b8/orig-f63c981e6ee2-Using-Claude-with-Excel-for-Finance.jpg)](/post/using-claude-with-excel-for-finance) Excel & Modeling3 min read ### [Using Claude with Excel for Finance](/post/using-claude-with-excel-for-finance) Using Claude with Excel for finance allows teams to analyze data, build models, and generate insights faster using natural language…. James Richard · April 14, 2026