Beschreibung
Excel: Sensible and purposeful use of functions
Excel contains almost 400 tables. To make your work more effective, this Excel seminar will introduce you to the most important complex functions used in statistics, date, time and financial mathematics.Calculating with date and time values as well as calculating differences (travel expense accounting) are particularly important, as are functions used in larger calculations. Excel provides various tools to help with large spreadsheets: Dividing it into different worksheets, managing spreadsheets in workbooks, structuring and consolidating large worksheets, and sensible use of names in functions.
In large spreadsheets, there is always the danger of losing track of the calculated values. The professional use of formula monitoring helps you keep track of large and complex spreadsheets.
Kommende Starttermine
Inhalte / Module
- Overview of Power Query operation
- Query Editor overview
- Importing data from various sources
- Preparing and adjusting field data types
- Combining data (merging and appending)
- Linking data tables (creating relationships)
- 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
Zielgruppe / Voraussetzungen
Hinweis: Dieser Kurs richtet sich an Mitarbeitende aus Unternehmen und Institutionen.
Für Privatpersonen ist dieser Kurs leider nicht geeignet.
Eine Informationsanfrage zu diesem Kurs ist nur für Beteiligte aus dem B2B-Bereich sinnvoll.
Abschlussqualifikation / Zertifikat
Infos anfordern
GFU Cyrus AG
Erweitern Sie Ihre IT-Skills mit einem offenen IT-Training oder ganz nach Ihren Bedürfnissen durch eine individuelle IT-Schulung. Programmiersprachen (C#, Python, Java, …), Microsoft Office 365, Anforderungsmanagement, Projektmanagement, Business Intelligence, Data Science, Künstliche Intelligenz, IT-Sicherheit , Administration & Datenbanken, Softwareentwicklung, Testmanagement...
Erfahren Sie mehr über GFU Cyrus AG und weitere Kurse des Anbieters.