The Excel finance training gives you mastery of Excel functions dedicated to financial management: interest calculations, present value, internal rate of return, depreciation, schedules. In one intensive half day, you discover the most used Excel financial functions in finance, accounting and management control services in French speaking Switzerland.<\/p>\n
Master Excel’s financial language to gain credibility in numbers-driven roles<\/strong><\/p>\n In the financial domain in French speaking Switzerland, knowing how to handle Excel financial functions (PV, IRR, PMT, SLN) clearly places your level in the top tier. This Excel finance training focuses on hands on cases: business plan, investment study, loan schedule, profitability analysis.<\/p>\n","protected":false},"featured_media":41300,"parent":0,"menu_order":0,"template":"","editeurs":[1539,1537],"domaine":[1265,1269],"class_list":["post-14704","formations","type-formations","status-publish","has-post-thumbnail","hentry","editeurs-microsoft-excel-microsoft-office","editeurs-microsoft-office","domaine-office-automation","domaine-spreadsheet"],"acf":{"reference":"MOE-33","duree_nombre":0.5,"duree_unite":"jour","prix_virtuel":375,"prix_presentiel":400,"prix_blended":"","prix_elearning":"","views":2171,"niveau":["Expert"],"role":"","certifiant":"","pdus":"","lieux":["Gen\u00e8ve","Lausanne"],"formats_dapprentissage":["presentiel","virtuel"],"examen_inclus":"Non certifiant","garanti":"","financement":["Temptraining"],"description_temptraining":"","description_caf":"","description_title":"Excel - Financial Management Formulas and Functions Training","objectifs":" Excel offers about thirty dedicated financial functions covering essential calculations in corporate and personal finance: present value, internal rate of return, loan installment, linear or accelerated depreciation. The Excel finance training delivers these levers in one intensive half day.<\/p>\n The training places significant focus on the most used financial functions. PMT to calculate a loan installment, IPMT and PPMT to break down an installment into interest and capital, SLN and DDB for linear and double-declining depreciation.<\/p>\n NPV (Net Present Value) and IRR (Internal Rate of Return) are the two reference indicators to evaluate an investment. The training details their simplified mathematical logic, their calculation in Excel via NPV and IRR functions, their interpretation for decision making.<\/p>\n The training ends with two complete hands on cases. Building a complete loan schedule that recalculates automatically when a parameter changes. And building a mini business plan with NPV and IRR calculation over 5 years.<\/p>\n The Excel finance training is designed for accountants, management controllers, financial analysts, bankers, self employed professionals managing their treasury and any financial profile.<\/p>\n In ITTA centers in Carouge and Le Flon, this Excel finance training runs as an intensive half day with an expert instructor and a limited group for direct exchanges.<\/p>\n What is the difference between NPV and IRR?<\/strong><\/p>\n NPV gives an amount in CHF (the value created by the investment), IRR gives an annualized rate of return.<\/p>\n Does the Excel PMT function serve loans?<\/strong><\/p>\n Yes, PMT calculates a loan installment from capital, rate and duration.<\/p>\n Do I need to master Excel before this finance training?<\/strong><\/p>\n Yes, good mastery of common Excel functions is required.<\/p>\n Does the training cover accounting depreciation?<\/strong><\/p>\n Yes, SLN (linear) and DDB (declining balance) are studied with their accounting use cases.<\/p>\n Is this Excel finance training held in Geneva?<\/strong><\/p>\n Yes, at the ITTA center in Carouge in Geneva, at Le Flon in Lausanne and in a virtual classroom.<\/p>\n How long to be comfortable with Excel financial functions?<\/strong><\/p>\n The basics are acquired in a structured half day.<\/p>\n Which course should follow this Excel finance training?<\/strong><\/p>\n The Excel Dashboards course to build complete financial dashboards.<\/p>\n Finance, controlling, accounting profiles using Excel intensively for analyses and wanting to master specialized financial functions. In Geneva and Lausanne, the course welcomes participants from international organizations, banking, consulting and growing SMEs. No specific prerequisite is required other than a concrete willingness to progress on the subject.<\/p>\n You leave with an operational mastery of the fundamentals, reusable canvases on your concrete cases, a structured action plan for the weeks that follow. Many participants report a visible effect from the first week back, with sustainable anchoring over four to six weeks of regular practice. The course combines short theory inputs, practical exercises on your real situations and personalized trainer debrief.<\/p>\n A controller calculating depreciation, NPV and IRR for investment projects. An analyst structuring a 5-year financial forecast model. A treasurer automating compound interest and loan repayment calculations. The course adapts exercises to your context with personalized trainer feedback, and each participant leaves with an action plan calibrated to their own situation.<\/p>\n This training combines well with Excel Dashboards for financial reporting, Excel Advanced formulas for complex calculations, and PowerQuery for data consolidation. Many participants enroll in one of these courses in the following trimester, according to their current priority and professional context.<\/p>\n Excel remains the universal tool of finance function, despite arrival of modern ERPs. Financial functions (NPV, IRR, SLN, PMT, IPMT) are precious for ad hoc analyses and forecast models. This training targets financial profiles wanting to master these specialized functions and integrate them into robust models.<\/p>\n\n Most participants report a noticeable effect from the first week of return, with deeper anchoring over four to six weeks of regular practice on real files. The course closes with a personalized practice plan calibrated on your professional context, including milestones and review prompts to ensure the techniques become permanent rather than fading after a few weeks.<\/p>\n At ITTA centers in Geneva and Lausanne, this course runs in a small group with an expert trainer and a format alternating concise theory, practical exercises and personalized debrief. Group confidentiality is explicit and held. Each participant arrives with a real case and leaves with an action plan calibrated to their context. The course integrates recent evolutions of the domain (digital tools, hybrid formats, 2025-2026 practices) without losing focus on fundamentals.<\/p>\n Need to be finance expert?<\/strong><\/p>\n The course addresses finance or controlling profiles. Some financial notions help.<\/p>\n Does it cover forecast models?<\/strong><\/p>\n Yes, forecast model construction is treated with modeling best practices.<\/p>\n Are modern tools (Power BI) addressed?<\/strong><\/p>\n Power BI is briefly positioned as Excel complement.<\/p>\n Where do sessions take place?<\/strong><\/p>\n ITTA has three centers in French speaking Switzerland: in Geneva (Carouge, Route des Jeunes 35), in Lausanne at the Flon (Rue des Cotes de Montbenon 16) and at Lausanne Mon-Repos (Avenue de Mon-repos 24). The training is also available in virtual classroom.<\/p>","inclus_dans_ce_cours_virtuel":"\n\t
\r\n \t
\r\n \t
\r\n \t
\r\n
\r\n \t
\r\n \t
\r\n \t
The role of Excel financial functions in modern work<\/h3>\n
Essential Excel functions in finance<\/h3>\n
Net Present Value and Internal Rate of Return<\/h3>\n
Building a loan schedule and a business plan<\/h3>\n
Who this training is for<\/h3>\n
Practical Excel finance training in Carouge and Le Flon<\/h3>\n
FAQ Excel finance training<\/h3>\n
Who this excel finance training is for<\/h3>\n
Concretely, what will you be able to do at the end<\/h3>\n
Concrete use cases in business<\/h3>\n
Articulation with other ITTA courses<\/h3>\n
Why this training makes a difference in professional environment<\/h3>\n
Sustained anchoring after the course<\/h3>\n
ITTA pedagogy oriented towards practice in Geneva and Lausanne<\/h3>\n
\r\n \t
\r\n \t