Kategori
Teknologi
Tutorial Excel
Tetap mengikuti berita, teknik, dan sumber daya terbaru untuk Excel. Tutorial kami penuh dengan panduan praktis langkah demi langkah dan use case yang dapat Anda gunakan untuk meningkatkan keterampilan.
Teknologi lainnya:
Pelatihan untuk 2 orang atau lebih?Coba DataCamp for Business
RANDARRAY() Function in Excel: Generate Random Numbers in Your WorkBook
Generate random numbers in Excel easily with the RANDARRAY() function. Learn how to use RANDARRAY() to create dynamic arrays of random numbers for your spreadsheets.
Josef Waples
8 Agustus 2025
MODE() Function in Excel: Find the Most Frequent Number
Find the most common value in your data. Learn to use MODE() function in Excel for quick statistical insights. Master basic and advanced use cases with clear examples.
Josef Waples
8 Agustus 2025
NORM.DIST() Function in Excel: Calculate Probabilities and Curve Heights
Learn how to calculate cumulative probabilities and probability density using NORM.DIST in Excel. Understand its syntax, key arguments, and real-world examples.
Josef Waples
8 Agustus 2025
Excel CORREL(): Analyze Relationships Between Variables in Excel
Analyze the strength and direction of relationships between variables using built-in Excel tools.
Josef Waples
7 Agustus 2025
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().
Laiba Siddiqui
5 Agustus 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.
Allan Ouko
1 Agustus 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.
Allan Ouko
31 Juli 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.
Samuel Shaibu
29 Juli 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.
Laiba Siddiqui
28 Juli 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.
Josef Waples
25 Juli 2025
Excel TEXTSPLIT(): Split Text into Multiple Cells in Excel
Easily separate text into columns or rows in Excel using the TEXTSPLIT() function.
Josef Waples
17 Juli 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.
Josep Ferrer
16 Juli 2025