Efficient work with Excel
Practical Excel skills for the financial sector
09.04. - 10.04.2025 in Vienna
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
- 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.