Entdecken Sie, was Sie lernen können.
Mit Videokursen für Beruf, Studium und Freizeit.
Entdecken Sie, was Sie lernen können.
Mit Videokursen für Beruf, Studium und Freizeit.
Welcome to the Microsoft Excel 365 Advanced course, designed to boost your data analysis and productivity skills with advanced Excel 365 features.
Delve into dynamic array formulas like SORT, FILTER, and XLOOKUP to manipulate data efficiently. Learn complex lookups and reference functions, even with multiple criteria.
Discover how to create custom functions with LET and LAMBDA, tailoring formulas to your needs. Master Power Pivot and Power Query for effortless data management and analysis.
Explore advanced PivotTable and Pivot Chart techniques and create interactive applications with form controls and checkboxes. Automate tasks and customize Excel with macros and VBA.
Finally, experience AI tools like Microsoft Copilot and ChatGPT to streamline your workflow.
By the end of this course, you should be able to confidently tackle complex data analysis tasks, boosting your productivity in Excel 365. Join us and unlock new levels of spreadsheet proficiency.
In the course, you will be able to:
Microsoft Excel 365 Advanced: Course Introduction
|
03:50 |
|
Microsoft Excel 365 Advanced: Exercise 01
|
01:02 |
What are Dynamic Array Functions?
|
02:25 |
|
Introduction to Spills and Arrays
|
06:09 |
|
Extract and Count Unique Entries
|
03:41 |
|
Unique vs. Distinct
|
04:10 |
|
Extract Multiple Unique Columns
|
02:21 |
|
Extract Unique Values by Column
|
03:36 |
|
The SORT Function
|
05:49 |
|
The SORT Function: Horizontal SORT
|
06:06 |
|
The SORTBY Function
|
04:21 |
|
The SORTBY Function: Horizontal SORTBY
|
03:59 |
|
The SEQUENCE Function
|
04:51 |
|
The FILTER Function
|
06:05 |
|
FILTER with Logic: + Operator (OR)
|
05:13 |
|
FILTER with Logic: * Operator (AND)
|
03:59 |
|
FILTER with Logic: = Operator (Both or Neither Criteria)
|
03:09 |
|
FILTER with Logic: - Operator (One or the Other but Not Both)
|
03:25 |
|
RANDARRAY and RANDBETWEEN
|
09:22 |
|
Use XLOOKUP to Perform Complex Lookups
|
07:28 |
|
The XMATCH Function
|
04:09 |
|
Microsoft Excel 365 Advanced: Exercise 02
|
01:27 |
| Quiz zum Kurs „Microsoft Excel 365 – Dynamic Array Formulas (EN)“ | |
|
Lookups with Multiple Criteria
|
06:18 |
|
Lookups with Duplicate Values
|
05:39 |
|
Microsoft Excel 365 Advanced: Exercise 03
|
01:48 |
| Quiz zum Kurs „Microsoft Excel 365 – Advanced Lookup and Reference Functions (EN)“ | |
|
The LET Function
|
09:34 |
|
Create Your Own Formulas with LAMBDA
|
11:27 |
|
Microsoft Excel 365 Advanced: Exercise 04
|
02:00 |
| Quiz zum Kurs „Microsoft Excel 365 – Create Your Own Functions (EN)“ | |
|
Create a Data Model in Power Pivot
|
06:37 |
|
Create Relationships Between Tables
|
04:24 |
|
Add Calculated Columns
|
05:58 |
|
Build a PivotTable from Multiple Sources
|
03:52 |
|
Microsoft Excel 365 Advanced: Exercise 05
|
01:14 |
| Quiz zum Kurs „Microsoft Excel 365 – Power Pivot (EN)“ | |
|
Import Data Using Power Query
|
05:25 |
|
Clean Data with Power Query
|
09:18 |
|
Combine Files from a Folder
|
06:28 |
|
Add More Files to the Data Model and Refresh
|
06:40 |
|
Microsoft Excel 365 Advanced: Exercise 06
|
04:25 |
| Quiz zum Kurs „Microsoft Excel 365 – Power Query (EN)“ | |
|
Create a Custom PivotTable Style
|
08:33 |
|
Apply Custom Number Formatting
|
06:40 |
|
Sorting Using a Custom Lists
|
03:36 |
|
Create Report Filter Pages
|
02:03 |
|
Adjust Slicer Settings
|
09:03 |
|
Lock Workbooks but not Slicers
|
03:11 |
|
Add a Calculated Field
|
04:01 |
|
Create a Calculated Item
|
04:40 |
|
Use GETPIVOTDATA with Data Validation
|
06:54 |
|
Create Dynamic Pivot Chart Labels
|
05:22 |
|
Microsoft Excel 365 Advanced: Exercise 07
|
01:59 |
| Quiz zum Kurs „Microsoft Excel 365 – Advanced PivotTables and Pivot Charts (EN)“ | |
|
Introduction to Form Controls
|
06:02 |
|
Combo Box: Select from a List
|
05:43 |
|
Check Box: Check/Uncheck Option
|
06:59 |
|
NEW Checkboxes
|
07:32 |
|
Option Button: Choose an Option
|
05:02 |
|
Spin Button: Move Up and Down a List
|
05:28 |
|
List Box: Select from a List of Items
|
05:52 |
|
Scroll Bar: Scroll Through a List
|
07:21 |
|
Microsoft Excel 365 Advanced: Exercise 08
|
01:51 |
| Quiz zum Kurs „Microsoft Excel 365 – Form Controls and Checkboxes (EN)“ | |
|
Use Macros to Automate Tasks
|
06:38 |
|
Record, Save, and Run Macros
|
09:59 |
|
Record Macros with Relative Referencing
|
06:58 |
|
Multi-Step Macros
|
07:09 |
|
The VBA Editor
|
07:55 |
|
Assign Macros to Buttons
|
06:43 |
|
Create a Custom Macro Ribbon
|
06:34 |
|
Generate VBA Code with Copilot
|
05:01 |
|
Microsoft Excel 365 Advanced: Exercise 09
|
01:25 |
| Quiz zum Kurs „Microsoft Excel 365 – Macros and VBA (EN)“ | |
|
Introduction to Copilot
|
03:18 |
|
Generate Sample Excel Datasets with AI
|
06:03 |
|
Ask Questions and Get Help
|
02:05 |
|
Copilot for Excel 365
|
08:18 |
|
Microsoft Excel 365 Advanced: Exercise 10
|
02:00 |
|
Microsoft Excel 365 Advanced: Course Close
|
03:48 |
| Quiz zum Kurs „Microsoft Excel 365 – AI Tools (Microsoft Copilot and ChatGPT) (EN)“ | |
| Quiz zum Kurs „Microsoft Excel 365 Advanced (EN)“ |
Die besten Dozenten, die besten Inhalte, das beste Lernergebnis. Davon sind wir 100%ig überzeugt. Daher auch unsere 100% Geld-zurück-Garantie. Sind Sie wirklich nicht zufrieden? Schreiben Sie uns. Bis fünf Tage nach dem Kauf erstatten wir Ihnen den vollen Preis zurück - ohne Wenn und Aber.
