In this seminar, participants will gain a comprehensive understanding of Excel functions, focusing on their sensible and purposeful application. Through hands-on exercises and practical examples, attendees will learn how to utilize Excel functions effectively, enabling them to make informed decisions and enhance productivity in various professional contexts.
By the end of the seminar, participants will master the art of employing functions sensibly, ensuring their relevance and significance in real-world scenarios.
Complex queries, processing, and filtering the data source
Data cleaning
Grouping data
Editing individual query steps
Creating custom columns for own calculations
Exemplary use of Power Query function language
Dynamic evaluations of Power Query queries
Consolidating files and folders in Power Query queries
Displaying evaluations with Excel PowerPivot
Dauer/zeitlicher Ablauf:
1 Tage
Zielgruppe:
Participants can include individuals with basic knowledge of Excel and familiarity with basic functions, as well as users interested in learning a specialized topic.
Wir setzen Analyse-Cookies ein, um Ihre Zufriedenheit bei der Nutzung unserer Webseite zu verbessern.
Diese Cookies werden nicht automatisiert gesetzt.
Wenn Sie mit dem Einsatz dieser Cookies einverstanden sind, klicken Sie bitte auf Akzeptieren.
Weitere Informationen finden Sie hier.
