Sari la conținutul principal
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:
GroupInstruirea a 2 sau mai multe persoane?Încercați DataCamp for Business

openpyxl: Automate Excel Tasks with Python

Learn how to read, write, and style Excel files using openpyxl. Discover practical examples for working with modern Excel formats (.xlsx) and advanced features.

29 mai 2025

SUBTOTAL() Formula in Excel: A Full Calculation Guide

Learn how the SUBTOTAL() function dynamically summarizes filtered or grouped data. Understand its syntax, explore practical examples, and compare it with similar functions.

28 mai 2025

XMATCH in Excel Tutorial: Overview, Syntax, and Practical Applications

Discover XMATCH, a powerful Excel function to find the relative position of an item that matches a specified value.

27 mai 2025

IFS() Excel: Learn to Simplify Multiple Conditions

Say goodbye to complex nested IF() logic. Learn how to build readable formulas using the IFS() function instead.

27 mai 2025

#NAME? Error in Excel: Causes, Fixes, and Prevention Tips

Learn why the #NAME? error occurs in Excel formulas and discover practical steps to troubleshoot, fix, and prevent it for smoother spreadsheet workflows.

26 mai 2025

How to Sum in Excel: A Full Guide

Learn how to add numbers in Excel using built-in tools. Explore multiple methods for quick calculations, including formulas, keyboard shortcuts, and table formatting.

23 mai 2025

How to Divide in Excel: A Beginner-Friendly Breakdown

Learn how to divide numbers, cells, and columns in Excel using simple formulas and tools. Discover how to handle errors, use functions like QUOTIENT and MOD, and ensure results sum to whole numbers when needed.

13 mai 2025

Flash Fill Excel: Tips, Tricks, and Limitations to Know

Learn how to speed up your work in Excel with Flash Fill. Discover practical examples, usage tips, limitations, and troubleshooting strategies to get the most out of this smart feature.

13 mai 2025

Bullet Points in Excel: 8 Easy Ways to Organize Your Lists

Discover simple ways to insert bullet points in Excel using keyboard shortcuts, formulas, symbols, and formatting tricks. Learn how to create clean, organized lists even inside a single cell.

13 mai 2025

Sensitivity Analysis in Excel Tutorial: Overview, Types, and Best Practices

Discover how to perform a sensitivity analysis in Excel, a popular “what-if” method used to identify the most relevant inputs in a model outcome.

11 mai 2025

Fill Handle Excel: How to Speed Up Data Entry

Learn how to use the Fill Handle in Excel to copy formulas, extend data patterns, customize AutoFill options, and troubleshoot common issues with step-by-step guidance and examples.

8 mai 2025

How to Move Columns in Excel: Simple Techniques and Pro Tips

Learn different methods to rearrange your spreadsheet by moving single or multiple columns in Excel. Discover practical shortcuts, hidden tricks, and expert tools to speed up your workflow.

7 mai 2025