Training: Excel – Formulas and functions for financial management

Ref. MOE-33

Download PDF

Duration:

0.5

jour

Exam:

Non certifiant

Level:

Expert

Funding:

Eligible

Home > Trainings > Office Automation > Spreadsheet > Excel – Formulas and functions for financial management

Excel - Financial Management Formulas and Functions Training

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.

Master Excel’s financial language to gain credibility in numbers-driven roles

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.

Participant Profiles

Management controllers and financial analysts
Accountants and administrative managers
Project managers requiring financial analysis skills
Entrepreneurs and managers seeking to optimize their financial management
Executive assistants working with financial data

Objectives

Master essential Excel financial functions (PV, IRR, PMT)
Build a loan schedule with progressive amortizations
Calculate Net Present Value of an investment
Evaluate project profitability via Internal Rate of Return
Improve the reliability of your Excel financial analyses

Prerequisites

Maîtriser les fonctions de base d’Excel (formules simples, mise en forme)
Savoir créer et manipuler des tableaux de données

Course Content

Module 1: Financial functions

Use the financial functions: VPM(), NPM(), RATE()
Use the amortization functions : AMORLIN(), AMORDEGRC()
Use the Consolidate function

Module 2: Stock Market Charts

Organize your data to create a stock chart
Create a stock chart
Set up and format a chart

Module 3: Forecasting

Designing an assumption table
Use the Scenario Manager
Analyze data with the solver
Manage variable and target cells, constraints, results
Create a forecast sheet

Documentation

Digital course material included

Lab / Exercises

This course includes hands-on exercises designed to reinforce your knowledge and apply your skills in real-world professional scenarios.

Complementary Courses

Eligible Funding

ITTA is a partner of a continuing education fund dedicated to temporary workers. This fund can subsidize your training, provided that you are subject to the “Service Provision” collective labor agreement (CCT) and meet certain conditions, including having worked at least 88 hours in the past 12 months.

Additional Information

The role of Excel financial functions in modern work

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.

Essential Excel functions in finance

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.

Net Present Value and Internal Rate of Return

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.

Building a loan schedule and a business plan

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.

Who this training is for

The Excel finance training is designed for accountants, management controllers, financial analysts, bankers, self employed professionals managing their treasury and any financial profile.

Practical Excel finance training in Carouge and Le Flon

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.

FAQ Excel finance training

What is the difference between NPV and IRR?

NPV gives an amount in CHF (the value created by the investment), IRR gives an annualized rate of return.

Does the Excel PMT function serve loans?

Yes, PMT calculates a loan installment from capital, rate and duration.

Do I need to master Excel before this finance training?

Yes, good mastery of common Excel functions is required.

Does the training cover accounting depreciation?

Yes, SLN (linear) and DDB (declining balance) are studied with their accounting use cases.

Is this Excel finance training held in Geneva?

Yes, at the ITTA center in Carouge in Geneva, at Le Flon in Lausanne and in a virtual classroom.

How long to be comfortable with Excel financial functions?

The basics are acquired in a structured half day.

Which course should follow this Excel finance training?

The Excel Dashboards course to build complete financial dashboards.

Who this excel finance training is for

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.

Concretely, what will you be able to do at the end

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.

Concrete use cases in business

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.

Articulation with other ITTA courses

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.

Why this training makes a difference in professional environment

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.

Sustained anchoring after the course

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.

ITTA pedagogy oriented towards practice in Geneva and Lausanne

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.

Need to be finance expert?

The course addresses finance or controlling profiles. Some financial notions help.

Does it cover forecast models?

Yes, forecast model construction is treated with modeling best practices.

Are modern tools (Power BI) addressed?

Power BI is briefly positioned as Excel complement.

Where do sessions take place?

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.