Excel for Controllers

Intensiv-Seminar

Startseite > Excel-Seminare > Excel für Ihr Spezialgebiet > Excel for Controllers

DEU ENG

Effective reporting with pivots and macros

Use Excel even more efficiently and save time
Professional solutions for analyses, budgeting and reporting
Automating routine tasks

Dieses Seminar ist als 2-tägiges Präsenz-Seminar buchbar.

As a controller and employee in the financial sector, Excel is your most important working tool. Save time with professional Excel knowledge! We will show you proven solutions to problems that you can use specifically for controlling and accounting areas with immediate effect. Meaning that you will always successfully achieve your goals!

Exellent

4,8 / 5

Der Trainer war sehr gut und hat es verständlich vorgetragen

MEHR ERFAHREN

Excel for Controllers als Firmenseminar anfragen

Who’ll be taking part in the seminar?

The seminar is suitable for anyone who often has to work with large quantities of figures and is confident in their use of Excel. But at the same time, you know that you are not making maximum use of all the possibilities. The Excel for Controllers intensive seminar is just right for you if you would like to fully apply techniques to simplify your tasks and work significantly more effectively and professionally.

By the end of the seminar, you will be able to

create ad hoc analyses with pivot tables;
recognise methods and functions for successful controlling;
ensure the quality of data imported into Excel and effectively protect sensitive corporate data;
save time through efficient application;
use tips & tricks to your benefit.

Seminar schedule
Tips & Tricks for time-saving work
- Quickly identifying and changing data, number formats and calculations
- Using range names
- Learning and using helpful keyboard shortcuts
Importing, cleaning and structuring data more efficiently
- Importing data from different sources
- Preparing and cleaning imported data
- Converting texts, figures and data without errors
- Retrieving and filtering external data
- Using various search and reference functions
Performing basic data analyses in controlling
- Working with dynamic data tables
- Structuring data efficiently
- Managing large amounts of data swiftly and securely
- Statistics and database functions for data analysis
- Calculating partial results
- Useful functions for the calculation and evaluation of data lists
- Using advanced filter functions to generate data stocks
Performing ad hoc analysis of large amounts of data with the help of pivot tables
- Preparing the database to be analysed
- Applying basic working techniques for field selection, structuring, calculation and data display
- Grouping data and creating calculated fields
- Using data slicers in the selection of data
- Creating pivot charts
Comparing data for budget management and liquidity planning
- Creating target-performance comparisons for budgeting
- What-if analysis: using target value searches, solver and scenarios
- Applying layouts in liquidity planning and other extensive spreadsheets
Dynamic reports and data models
- Creating structures and user-friendly workbooks
- Using conditional formatting to evaluate data more quickly
- Recognising and mastering important calculation functions for controllers
- Developing dynamic data models
- Visualising series of data with sparklines
- Applying design rules for comprehensible charts
Creating simple macros
- Recording, applying and editing macros
Avoiding errors and ensuring data quality in calculation models
- Using validity checks in a targeted manner to avoid input errors
- Using control elements
- Protecting formulas, functions, cells, table structures and workbooks
- Using resources to troubleshoot formulas and functions
Expert tips from the trainer
- Time-saving tricks: shortcuts and efficient working techniques
- Further sources of information on the Internet

Diese Seminare könnten Sie auch interessieren

Jetzt anmelden

Alle Informationen zum Excel for Controllers Kurs finden Sie hier im Überblick als PDF
Download Broschüre Cover of the information brochure: Excel for Controllers

Cover of the information brochure: Excel for Controllers

Hilfe bei der Auswahl. Sie wissen nicht, welche Schulung für Sie die richtige ist? Rufen Sie uns an unter der kostenfreien Nummer 0800 – 4200 500 oder schreiben Sie uns eine E-Mail an kundenservice@confex.de - wir unterstützen Sie gerne, das optimale Seminar für Ihren Bedarf zu finden.
Rückrufwunsch angeben

Unsere Treueprämie. Viele unserer Kundinnen und Kunden kommen wieder, weil sie die Vielfalt und die Aktualität unseres Kursangebotes schätzen. Darüber freuen wir uns sehr und schenken jedem Teilnehmenden nach der Schulung als Dankeschön einen Gutschein im Wert von 100 Euro.

Unser Schulungs-Team. Nur zusammen sind wir erfolgreich. Dank der unterschiedlichsten beruflichen Hintergründe unserer Referent*innen können wir auf Ihre individuellen Anforderungen eingehen. Werfen Sie doch einen Blick auf unser Team an Dozentinnen und Dozenten.
Alle Trainer*innen

Excel for Controllers

Effective reporting with pivots and macros

Registration

Who’ll be taking part in the seminar?

By the end of the seminar, you will be able to

Seminar schedule

Diese Seminare könnten Sie auch interessieren

Cookie – Einstellungen