Categorie
Tehnologii
Tutoriale Excel
Rămâneți la curent cu cele mai noi noutăți, tehnici și resurse pentru Excel. Tutorialele noastre sunt pline de ghiduri practice pas cu pas și cazuri de utilizare pe care le puteți folosi pentru a vă dezvolta competențele.
Alte tehnologii:
Instruirea a 2 sau mai multe persoane?Încercați DataCamp for Business
How to Highlight Duplicates in Excel
Explore how you can identify duplicate entries in Excel using Conditional Formatting, the COUNTIF() formula, and Power Query. Learn best practices and troubleshoot issues.
Laiba Siddiqui
13 noiembrie 2024
VLOOKUP() from Another Sheet: A How-to in Excel
See how to use VLOOKUP() to pull data from another sheet in your Excel workbook. Build confidence with practical examples and troubleshooting techniques.
Laiba Siddiqui
11 noiembrie 2024
How to Find P-Value in Excel: 3 Easy Methods
Learn how to find p-value in Excel using Excel functions like T.TEST() and Z.TEST(), by using the Data Analysis Toolpak, or through manual calculations. Equip yourself to make confident, data-backed decisions in Excel.
Jachimma Christian
31 octombrie 2024
VBA Excel: How to Get Started and Make Your Work Easier
Learn how to effectively use VBA in Excel to automate tasks, create macros, and enhance your data processing skills with practical examples and best practices.
Laiba Siddiqui
7 septembrie 2024
How to Use Goal Seek in Excel: A Guide with Real Examples
Simplify your data models with Excel’s Goal Seek, one of its powerful What-If Analysis tools. Solve real-world problems like loan payments and revenue targets.
Arunn Thevapalan
5 septembrie 2024
How to Compare Two Columns in Excel: A Step-by-Step Guide
Learn how to compare two columns in Excel for matches and for duplicates using methods like the equals operator, IF() function, EXACT(), XLOOKUP(), and more.
Laiba Siddiqui
27 februarie 2026
Excel Substring Techniques: Extract and Format Text
Learn how to extract and format text position or delimiter using Excel substring functions, including LEFT(), RIGHT(), MID(), and more, with step-by-step instructions.
Laiba Siddiqui
29 august 2024
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 decembrie 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 iulie 2024