Entdecken Sie, was
Sie lernen können.Mit Videokursen für Beruf, Studium und Freizeit.
Are you looking to conquer Excel 365 like a pro? Our Microsoft Excel 365 Ultimate Beginner Guide is your ideal entry point into the world of number-crunching, data organization, and chart-making.
No Excel experience? No problem. We'll walk you through the basics, including understanding cells and columns, and help you navigate workbooks and worksheets effortlessly. Learn to enter data efficiently, format numbers, and use basic formulas and functions.
Unleash the power of Excel's charting tools and make impressive visualizations. Deal with messy data as we dive into sorting, filtering, and effective data management.
Learn to share your work, collaborate with peers, and ensure your Excel skills shine in group projects with our sharing options and teamwork tips.
Uncover shortcuts, hidden gems, and time-saving tips, transforming you into an Excel guru.
Upon completing this course, you should be able to confidently tackle Excel spreadsheets, leaving a lasting impression on professors and future employers.
In this course, you will learn how to:
Microsoft Excel 365 for Beginners: Course Introduction | 03:36 |
Excel 365 Online Portal | 06:49 |
Microsoft Excel 365 for Beginners: Exercise 01 | 00:59 |
Quiz zum Kurs „Microsoft Excel 365 for Beginners – Introduction (EN)“ |
Launch Excel | 03:47 |
Explore the Interface | 09:50 |
Work with Contextual Menus, Ribbons, and Panes | 04:43 |
Customize the Quick Access Toolbar | 07:08 |
Keyboard Shortcuts | 07:59 |
Microsoft Excel 365 for Beginners: Exercise 02 | 04:00 |
Quiz zum Kurs „Microsoft Excel 365 – Get Started (EN)“ |
Excel Templates | 06:39 |
Work with Workbooks and Worksheets | 06:40 |
Save Workbooks to OneDrive | 04:46 |
Enter Text, Numbers, and Dates | 07:07 |
Custom Lists | 06:30 |
Microsoft Excel 365 for Beginners: Exercise 03 | 04:03 |
Quiz zum Kurs „Microsoft Excel 365 – Create a Spreadsheet (EN)“ |
The Order of Operations (BODMAS Rule) | 06:51 |
A Simple Formula | 06:33 |
The 'Big 6' Functions | 06:28 |
Absolute vs. Relative Referencing | 07:28 |
Quick Calculations with Autosum | 05:35 |
Auto Fill and Flash Fill | 10:40 |
Microsoft Excel 365 for Beginners: Exercise 04 | 04:49 |
Quiz zum Kurs „Microsoft Excel 365 – Introduction to Formulas (EN)“ |
What are Named Ranges? | 03:24 |
Create Named Ranges | 04:16 |
Use Named Ranges in Formulas | 03:28 |
Microsoft Excel 365 for Beginners: Exercise 05 | 02:29 |
Quiz zum Kurs „Microsoft Excel 365 – Use Named Ranges (EN)“ |
Apply Number Formats | 12:19 |
Format Cells, Rows, and Columns Manually | 13:10 |
AutoFormat Data | 03:40 |
Find and Replace Formatting | 06:26 |
Copy Formatting: Format Painter | 04:37 |
Clear Cells | 05:18 |
Microsoft Excel 365 for Beginners: Exercise 06 | 04:02 |
Quiz zum Kurs „Microsoft Excel 365 – Format Numbers and Cells (EN)“ |
Excel Tables Explained | 07:50 |
Format Data as an Excel Table | 10:27 |
Table References in Formulas | 06:52 |
Microsoft Excel 365 for Beginners: Exercise 07 | 02:43 |
Quiz zum Kurs „Microsoft Excel 365 – Tables (EN)“ |
Work with Rows and Columns | 09:20 |
Align Text and Numbers | 08:53 |
Merge Cells vs. Center Across Selection | 06:56 |
Apply and Modify Themes | 08:30 |
Microsoft Excel 365 for Beginners: Exercise 08 | 03:04 |
Quiz zum Kurs „Microsoft Excel 365 – Format Worksheets (EN)“ |
How to Structure a List | 06:49 |
Sort a List: Single-level Sort | 05:27 |
Sort a List: Multi-level Sort | 05:52 |
Sort a List: Sort with Custom Lists | 03:55 |
Filter a List: Numbers and Text | 08:11 |
Filter and Sort by Color | 03:53 |
Add Subtotals to a List | 05:47 |
Microsoft Excel 365 for Beginners: Exercise 09 | 02:50 |
Quiz zum Kurs „Microsoft Excel 365 – Lists (EN)“ |
Cut, Copy, and Paste | 05:08 |
Paste Options | 08:55 |
Paste From Clipboard | 04:04 |
Move and Copy Worksheets | 06:38 |
3D Referencing | 06:03 |
Insert Hyperlinks to Worksheets | 07:37 |
Microsoft Excel 365 for Beginners: Exercise 10 | 07:39 |
Quiz zum Kurs „Microsoft Excel 365 – Move and Link to Data (EN)“ |
Lookup Functions: VLOOKUP Explained | 09:55 |
Lookup Functions: XLOOKUP Explained | 06:29 |
Logical Functions: IF, AND, OR | 09:56 |
Text Functions: PROPER, TRIM, CLEAN | 08:09 |
Time and Date Functions: TODAY, NOW, WORKDAY | 07:26 |
Microsoft Excel 365 for Beginners: Exercise 11 | 05:08 |
Quiz zum Kurs „Microsoft Excel 365 – Introduction to Intermediate Formulas (EN)“ |
Quick Analysis Button | 07:07 |
Choose the Right Chart Type | 06:49 |
Present Data with Charts | 05:55 |
Format a Chart | 11:23 |
In-cell Charts: Sparklines | 05:59 |
In-cell Charts: The REPT Function | 04:52 |
Microsoft Excel 365 for Beginners: Exercise 12 | 04:34 |
Quiz zum Kurs „Microsoft Excel 365 – Analyze Data (EN)“ |
Highlight Cell Values | 07:23 |
Data Bars | 06:42 |
Color Scales | 04:25 |
Icon Sets | 05:02 |
Microsoft Excel 365 for Beginners: Exercise 13 | 03:59 |
Quiz zum Kurs „Microsoft Excel 365 – Conditional Formatting (EN)“ |
Add Interest with Pictures and Icons | 09:32 |
Insert Shapes and Text Boxes | 09:50 |
Create Diagrams using SmartArt | 08:13 |
Insert Screenshots and Clips | 04:08 |
Insert and Respond to Threaded Comments | 05:32 |
Microsoft Excel 365 for Beginners: Exercise 14 | 04:34 |
Quiz zum Kurs „Microsoft Excel 365 – Insert Pictures and Other Graphics (EN)“ |
Workbook Views and Zoom | 08:11 |
Arrange Workbooks and Worksheets | 05:47 |
Freeze Panes | 03:34 |
Microsoft Excel 365 for Beginners: Exercise 15 | 01:51 |
Quiz zum Kurs „Microsoft Excel 365 – Work with Views (EN)“ |
Set Margins and Orientation | 03:59 |
Set and Clear the Print Area | 03:16 |
Insert Page Breaks | 04:13 |
Set Print Titles and a Background | 04:50 |
Insert Headers and Footers | 06:43 |
Print a Workbook | 06:50 |
Microsoft Excel 365 for Beginners: Exercise 16 | 02:54 |
Quiz zum Kurs „Microsoft Excel 365 – Prepare for Printing (EN)“ |
Protect Cells, Worksheets, and Workbooks | 06:37 |
Inspect the Workbook for Issues | 08:29 |
Save the Workbook in Different Formats | 04:11 |
Microsoft Excel 365 for Beginners: Exercise 17 | 03:09 |
Quiz zum Kurs „Microsoft Excel 365 – Finalizing the Spreadsheet (EN)“ |
Work with Files in Excel Online | 05:51 |
Share Workbooks with Others | 05:44 |
Co-author Workbooks in Real-time | 05:21 |
Add an Excel Workbook to Microsoft Teams | 03:10 |
Excel Live: Share a Workbook in a Teams Meeting | 03:27 |
Microsoft Excel 365 for Beginners: Exercise 18 | 03:44 |
Microsoft Excel 365 for Beginners: Course Close | 07:12 |
Quiz zum Kurs „Microsoft Excel 365 for Beginners (EN)“ |