Efficient work with Excel
Practical Excel skills for the financial sector
27.05. - 28.05.2024 in Vienna
13.11. - 14.11.2024 in Mannheim
Basics
1 or 2 days
1 day: EUR 1.650,- plus VAT
2 days: EUR 2.300,- plus VAT
Christof Kornfeld
Manager
Schwabe, Ley & Greiner
Peter Schmid
Manager
Schwabe, Ley & Greiner
Content
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
Basics
- 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.
Targets
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
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