Kategorie
Technologien
Excel-Tutorials
Halte dich mit den neuesten Nachrichten, Techniken und Ressourcen für Excel auf dem Laufenden. Unsere Tutorials sind voller praktischer Beispiele und Anwendungsfälle, die du nutzen kannst, um dich weiterzubilden.
Andere Technologien:
Training für 2 oder mehr Personen?Probiere es mit DataCamp for Business
XLOOKUP() vs. VLOOKUP(): A Comparison for Excel Users
XLOOKUP() searches in any direction, defaults to exact matches, and has built-in error handling, while VLOOKUP() only searches right and needs manual column indexing.
Laiba Siddiqui
27. August 2024
How to Separate Names in Excel: 3 Easy Methods
Discover how to separate names in Excel with features like Text to Columns, Flash Fill, and custom-built formulas. Make your spreadsheets cleaner and easier to work with.
Laiba Siddiqui
26. August 2024
How to Do a VLOOKUP() with Multiple Criteria
Master the art of using VLOOKUP() with multiple criteria in Excel. Explore advanced techniques like helper columns and the CHOOSE() function.
Laiba Siddiqui
7. August 2024
How to Calculate Standard Deviation in Excel
To calculate standard deviation in Excel, enter your data into a range of cells and use either =STDEV.S() for sample data or =STDEV.P() for population data.
Arunn Thevapalan
23. Dezember 2025
How to Combine VLOOKUP() with IF() in Excel
Combine VLOOKUP() with IF() for efficient data analysis, including conditional lookups, error handling, and dynamic column indexing.
Laiba Siddiqui
18. Juli 2024
How to Create Data Models in Excel: A Comprehensive Guide
We create data models by formatting data, creating relationships, using Power Query, and leveraging Power Pivot for seamless data integration and analysis.
Vikash Singh
5. Juli 2024
How to Create and Customize a Box and Whisker Plot in Excel
To create a box and whisker plot in Excel, select your data, open the Insert tab, click on Recommended Charts, choose the Box & Whisker chart, and press OK.
Elena Kosourova
18. Dezember 2024
A Comprehensive Guide to Calculating Frequency Distributions in Excel
Follow our step-by-step guide to create frequency distributions in Excel by using the FREQUENCY() function with just two arguments: data_array and bins_array.
Arunn Thevapalan
28. Juni 2024
Data Types in Excel and Their Uses: A Complete Guide
Learn to identify and format all types of data in Excel, then explore valuable tips on converting between data types to make your spreadsheet more functional.
Laiba Siddiqui
21. Juni 2024
How to Calculate Cube Roots in Excel: A Step-by-Step Guide
There are three easy ways to calculate cube roots in Excel: the caret ^ operator, the POWER() function, and custom VBA functions.
Laiba Siddiqui
14. Juni 2024
How to Create and Format a Combo Chart in Excel
To create a combo chart in Excel, select your data, go to the "Insert" tab, go to the "Charts" group, and choose "Combo Chart."
Elena Kosourova
12. Juni 2024
A Comprehensive Guide to Calculating Skewness in Excel
Calculating skewness in Excel is a straightforward process: we use either the SKEW() or SKEW.P() function.
Arunn Thevapalan
12. Juni 2024