Efficient work with Excel

Practical Excel skills for the financial sector

Dates & Place

13.11. - 14.11.2024 in Mannheim




1 or 2 days


1 day: EUR 1.650,- plus VAT
2 days: EUR 2.300,- plus VAT

Christof Kornfeld

Christof Kornfeld


Schwabe, Ley & Greiner

Peter Schmid

Peter Schmid


Schwabe, Ley & Greiner


Our two-day practice-oriented Excel seminar is aimed equally at financial beginners and advanced users. On the first day, the basics in effective data processing and analysis are taught and the primary focus is on the fundamentals in daily work in Excel. On the second day, building on the basics from the first day, various practical examples are worked through together using advanced methods. Depending on your own qualifications, each day can also be booked individually.

Main topics


  • What are the tasks of the cash manager in the company?
  • What are the minimum standards to be taken into account in the organizational structure & process organization?
  • What are the differences in the accounting or treasury perspective? Which business management approaches do you need to understand?
  • What are the requirements vis-à-vis banks?
  • What are the current trends in cash management for large and small companies?

Day 1: Treasury basics

  • Principles of data collection
  • Application of Excel formulas and functions
  • Data handling and productive work
  • Dealing with data errors
  • Data visualization
  • Dos & Don'ts in dealing with Excel

Day 2: Analyses for the treasury

  • Data queries & working with tables
  • New Excel functions
  • Creation of charts and reports

Group of participants

Employees in operational areas who, in addition to their workflows in systems, perform activities in Excel and want to acquire basic skills in it or deepen their knowledge.


The aim of this Excel seminar is to provide participants with comprehensive knowledge and skills in the effective use of Microsoft Excel with regard to common tasks in the financial sector. Through practical exercises and examples, participants will learn how to organize and analyze complex data and create presentation-ready reports. At the end of the course, participants will be able to use Excel efficiently in treasury.

Do you have any questions?

Marc Baumgärtner

Marc Baumgärtner

Seminar organization

Treasury Training

Other seminars

Liquidity planning: simple, system-supported, future-proof

What to look out for when setting up modern liquidity planning

Risk management for advanced users

Exposure determination, risk calculation and strategy development with smart hedging

Credit agreements from a financial perspective

Structure, content, scope for design and stumbling blocks

Financial mathematics and interest calculation

From simple interest to the valuation of an interest rate swap

Supply Chain Finance & Working Capital Management

Recognize, understand and realize potentials

Financial strategy, rating and credit agreements

Creditworthiness as the basis for financial strategy considerations and its influence on financing options and contract content

Portfolio management for investors and debtors

From theory to risk and return calculation to policy and performance measurement

Hedge Accounting and Accounting for Treasurers

Presentation of derivatives and hedging relationships in the balance sheet according to HGB/BilMoG, UGB and IFRS

Treasury Training