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
Index Match Excel: A Better Way to Look Up Data
See how INDEX() and MATCH() are used to look up values within a table or range of cells Compare INDEX() and MATCH() to VLOOKUP().
5 august 2025
Excel Drop Down List: Setup, Tips, and Troubleshooting
Master Excel drop-down lists with step-by-step tips for setup, troubleshooting, and advanced techniques like cascading and searchable lists.
1 august 2025
Excel TEXT() Function: Format Numbers as Readable Text
Learn how to convert numbers into formatted text in Excel using the TEXT() function. Customize dates, times, percentages, and more with format codes for clear, user-friendly spreadsheets.
31 iulie 2025
How to Make a Bar Graph in Excel: A Beginner's Guide
Learn how to create a bar graph in Excel with this beginner-friendly guide. Explore chart types, formatting tips, dynamic features, and troubleshooting techniques.
29 iulie 2025
How to Change Date Format in Excel: What You Need to Know
Learn how to create a bar graph in Excel with this beginner-friendly guide. Explore chart types, formatting tips, dynamic features, and troubleshooting techniques.
28 iulie 2025
Excel UNIQUE(): The Fastest Way to Filter Duplicates
Discover how to use the Excel UNIQUE() function to instantly remove duplicates and extract distinct values from any list. Learn how to apply it to both rows and columns.
25 iulie 2025
Excel TEXTSPLIT(): Split Text into Multiple Cells in Excel
Easily separate text into columns or rows in Excel using the TEXTSPLIT() function.
17 iulie 2025
Connecting Tableau With Excel: Turn Spreadsheets into Dynamic Dashboards
Learn how to seamlessly integrate Tableau with Excel to transform static spreadsheets into powerful, interactive dashboards. Boost insights, streamline analysis, and improve your data-driven decisions.
16 iulie 2025
How to Find Median in Excel: The Easy Way and the Long Way
Learn how to use Excel’s MEDIAN() function to find the middle value in a dataset. Compare it with AVERAGE(), handle common quirks, and apply it your own work.
16 iulie 2025
Python in Excel: Advanced Analysis in Your Excel Spreadsheet
Learn how to use Python in Excel to run advanced analytics, create visuals, and apply machine learning within your existing spreadsheet workflows.
15 iulie 2025
EOMONTH(): Calculate End-of-Month Dates in Excel
Calculate the last day of any month with Excel's EOMONTH() function. Use it to streamline financial schedules, reporting periods, and monthly workflows.
15 iulie 2025
MMULT() Excel: How to Do Matrix Multiplication in Excel
Unlock matrix multiplication in Excel with the MMULT() function. This guide explains how to use MMULT(), its syntax, and you will learn its applications in data analysis.
14 iulie 2025