Efficient work with Excel
Practical Excel skills for the financial sector
09.04. - 10.04.2025 in Vienna
21.10. - 22.10.2025 in Mannheim
Basics
1 or 2 days
2 days: EUR 2.750- plus VAT
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: methods for the systematic and error-free collection of financial data
- Application of Excel formulas and functions: Introduction to basic Excel formulas and functions for financial calculations
- Data handling and productive work: Best practices for handling data in Excel and working efficiently
- Dealing with data errors: techniques for error detection and correction
- Data visualization: Introduction to simple visualization options to present data clearly and concisely
- Dos & Don'ts when using Excel: Important tips to avoid common mistakes and use Excel efficiently
Day 2: Analyses for the treasury
- Data queries & working with tables: Introduction to pivot tables, SVERWEIS and other powerful data query tools
- New Excel functions: Advanced functions such as dynamic arrays, LET function and more
- Creation of charts and reports: Applying advanced chart types and creating professional financial reports
- Automation of workflows: Tips and tricks for automating Excel tasks for more efficiency in your day-to-day work
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.