Programm
- Reporting in Excel
- Filtering and Formatting Data
- Charts
- Excel Tables
- Excel Data Tables
- Summarizing Data
- Pivot Tables and Pivot Charts
- Pivot Tables
- Pivot Charts
- Editing Pivot Tables and Pivot Charts
- Dashboards
- Creating a Dashboard
- Data Analysis in Excel Pivot Tables
- Hierarchies
- Hierarchies
- Time Data
- The Excel Data Model
- Using an Excel Data Model
- External Data
Ziele
The main purpose of the course is to give students the ability to add analysis capabilities to Excel spreadsheets and to provide students with a foundation to learn about more advanced data analytics with Excel or Power BI.
Nach Abschluss dieses Seminars haben die Teilnehmer Wissen zu folgenden Themen:
Nach Abschluss dieses Seminars haben die Teilnehmer Wissen zu folgenden Themen:
- Create an Excel report
- Create an Excel table
- Create a pivot table and pivot chart
- Create a dashboard and analyze data
- Create Hierarchies
- Create an Excel data model and connect to external data
Voraussetzungen
Für dieses Seminar werden folgende Kenntnisse empfohlen:
- Basic knowledge of the Microsoft Windows operating system and its core functionality.
- Advanced working knowledge of Excel spreadsheets including formulas.