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 Intermediate" course. In this course, you'll improve your Excel skills to manage data and efficiently make informed decisions.
You'll learn to design better spreadsheets, improve readability, and control data input with cell styles and validation. You'll streamline data analysis and comparison tasks by mastering logical functions, lookup formulas, and sorting techniques.
Additionally, you'll delve into statistical and math functions, formatting, date and time manipulation, text and array operations, pivot tables, charts, and formula auditing.
With hands-on exercises, you'll gain practical experience effectively using Excel's intermediate features.
By the end of this course, you should be equipped with the skills to handle complex data tasks confidently, enhancing your productivity and analytical abilities in both personal and professional contexts.
In this course you will learn how to:
Microsoft Excel 365 Intermediate: Course Introduction
|
02:46 |
|
Microsoft Excel 365 Intermediate: Exercise 01
|
01:01 |
Design Better Spreadsheets
|
11:54 |
|
Improve Readability with Cell Styles
|
07:34 |
|
Control Data Input: Data Validation
|
06:32 |
|
Add Navigation Buttons
|
06:00 |
|
Create a Summary Sheet
|
02:53 |
|
Use Forms to Input Data Quickly
|
04:00 |
|
Microsoft Excel 365 Intermediate: Exercise 02
|
01:17 |
| Quiz zum Kurs „Microsoft Excel 365 – Spreadsheet Fundamentals for Good Design (EN)“ | |
|
Logical Functions: Basic Recap
|
06:09 |
|
Logical Functions: AND and OR
|
07:00 |
|
Nested IF Statements
|
05:33 |
|
The IFS Function: Simplified Nested Ifs
|
02:53 |
|
Conditional IF: COUNTIFS and SUMIFS
|
07:29 |
|
Error Handling with IFERROR and IFNA
|
04:20 |
|
Use Logical Functions with Conditional Formatting
|
05:03 |
|
Microsoft Excel 365 Intermediate: Exercise 03
|
01:32 |
| Quiz zum Kurs „Microsoft Excel 365 – Make Better Decisions with Logical Functions (EN)“ | |
|
VLOOKUP: Exact and Approx Match
|
08:37 |
|
Horizontal Lookups: HLOOKUP
|
06:28 |
|
Flexible Lookups: INDEX and MATCH
|
07:44 |
|
Modern Lookups: XLOOKUP and XMATCH
|
07:43 |
|
Lookups with Duplicates
|
06:59 |
|
Lookups with the CHOOSE Function
|
04:19 |
|
The SWITCH Function
|
04:32 |
|
Microsoft Excel 365 Intermediate: Exercise 04
|
01:15 |
| Quiz zum Kurs „Microsoft Excel 365 – Work with Lookup Formulas (EN)“ | |
|
Sort on Multiple Columns
|
05:39 |
|
Sort with a Custom List
|
04:41 |
|
The SORT and SORTBY Functions
|
07:48 |
|
The FILTER Function
|
10:04 |
|
Extract and Sort Unique Values
|
04:42 |
|
Microsoft Excel 365 Intermediate: Exercise 05
|
01:12 |
| Quiz zum Kurs „Microsoft Excel 365 – Sort and Filter Like a Pro (EN)“ | |
|
Find Duplicates with Conditional Formatting
|
04:41 |
|
Find Duplicates with Formulas
|
02:31 |
|
Microsoft Excel 365 Intermediate: Exercise 06
|
00:58 |
| Quiz zum Kurs „Microsoft Excel 365 – Compare Data (EN)“ | |
|
Use Mean, Median, and Mode
|
06:51 |
|
The LARGE and SMALL Functions
|
09:19 |
|
Rank and Rank Average
|
08:05 |
|
The SUBTOTAL and AGGREGATE Functions
|
11:37 |
|
Microsoft Excel 365 Intermediate: Exercise 07
|
00:59 |
| Quiz zum Kurs „Microsoft Excel 365 – Statistical Functions (EN)“ | |
|
ROUND Values
|
07:02 |
|
Special Rounding
|
05:31 |
|
Microsoft Excel 365 Intermediate: Exercise 08
|
01:03 |
| Quiz zum Kurs „Microsoft Excel 365 – Math Functions (EN)“ | |
|
Custom Formatting Explained
|
09:28 |
|
Practical Uses of Custom Formatting
|
07:16 |
|
Advanced Conditional Formatting
|
10:52 |
|
Microsoft Excel 365 Intermediate: Exercise 09
|
01:28 |
| Quiz zum Kurs „Microsoft Excel 365 – Formatting (EN)“ | |
|
Understand Dates and Times
|
05:05 |
|
Apply Custom Formats
|
05:49 |
|
Common Time and Date Functions
|
08:42 |
|
WORKDAY and NETWORKDAYS
|
07:31 |
|
Calculate Dates with EDATE and EOMONTH
|
06:36 |
|
Microsoft Excel 365 Intermediate: Exercise 10
|
01:29 |
| Quiz zum Kurs „Microsoft Excel 365 – Move and Link to Data (EN)“ | |
|
Import Data from a Text File
|
04:44 |
|
Clean a Dataset
|
08:16 |
|
Clean a Dataset with Power Query
|
07:57 |
|
Split Data: Text to Columns
|
06:53 |
|
Split Data: The TEXTSPLIT Function
|
09:30 |
|
Split Data: TEXTBEFORE and TEXTAFTER
|
07:02 |
|
Join Data: CONCAT and TEXTJOIN
|
07:29 |
|
TOCOL and TOROW
|
03:36 |
|
WRAPROWS and WRAPCOLS
|
05:04 |
|
TAKE and DROP
|
04:49 |
|
CHOOSECOLS and CHOOSEROWS
|
03:05 |
|
Microsoft Excel 365 Intermediate: Exercise 11
|
01:32 |
| Quiz zum Kurs „Microsoft Excel 365 – Text and Array Manipulation (EN)“ | |
|
PivotTables Explained
|
03:47 |
|
Create a PivotTable from Scratch
|
07:01 |
|
Pivot the Fields
|
03:14 |
|
Apply Number Formatting and Totals
|
04:22 |
|
Show Values As and Summarize By
|
05:53 |
|
Group PivotTable Fields
|
05:33 |
|
Format Error Values and Empty Cells
|
03:46 |
|
Choose a Report Layout
|
05:19 |
|
Apply and Modify PivotTable Styles
|
07:21 |
|
Microsoft Excel 365 Intermediate: Exercise 12
|
01:41 |
| Quiz zum Kurs „Microsoft Excel 365 – Analyze Data with PivotTables (EN)“ | |
|
Create a Pivot Chart
|
07:31 |
|
Formatting a Pivot Chart – Part 1
|
09:12 |
|
Formatting a Pivot Chart – Part 2
|
10:28 |
|
Using Map Charts
|
05:18 |
|
Microsoft Excel 365 Intermediate: Exercise 13
|
02:13 |
| Quiz zum Kurs „Microsoft Excel 365 – Pivot Charts (EN)“ | |
|
Insert Slicers
|
06:12 |
|
Format Slicers
|
09:03 |
|
Insert Timeline Slicers
|
07:37 |
|
Connect Slicers to Pivot Charts
|
05:37 |
|
Update PivotTable Data
|
03:00 |
|
Microsoft Excel 365 Intermediate: Exercise 14
|
01:52 |
| Quiz zum Kurs „Microsoft Excel 365 – Add Interaction to PivotTables and Charts (EN)“ | |
|
Troubleshoot Common Errors
|
09:56 |
|
Trace and Evaluate Formulas
|
07:19 |
|
Microsoft Excel 365 Intermediate: Exercise 15
|
01:28 |
| Quiz zum Kurs „Microsoft Excel 365 – Formula Auditing (EN)“ | |
|
Dynamic Drop-down Lists
|
05:39 |
|
Input Messages and Error Alerts
|
03:39 |
|
Microsoft Excel 365 Intermediate: Exercise 16
|
01:42 |
|
Calculate Repayments on a Loan: PMT Function
|
09:58 |
|
Goal Seek
|
05:52 |
|
Data Tables: One and Two Variable
|
05:49 |
|
Scenario Manager
|
06:44 |
|
Microsoft Excel 365 Intermediate: Exercise 17
|
01:03 |
|
Microsoft Excel 365 Intermediate: Course Close
|
02:35 |
| Quiz zum Kurs „Microsoft Excel 365 – What-If Analysis Tools (EN)“ | |
| Quiz zum Kurs „Microsoft Excel 365 Intermediate (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.
