Cuma mau ambil nama depan… eh malah kepikiran: “Ini paling rapi pakai cara apa ya?” 😅 Awalnya orang mikir: “Ya udah, pakai Text to Columns aja.” Padahal… Excel punya cara yang lebih gokil. 🔥 Cara 1 – Flash Fill Kasih contoh → tekan Ctrl E → boom! Nama depan langsung jadi. ⚡ Cara 2 – TEXTBEFORE (dinamis) Nama berubah? Hasil ikut berubah. Cocok buat data yang hidup. 🤯 Cara 3 – Find & Replace Wildcard Cari: spasi * → ganti kosong → yang tersisa? Nama depan doang. Ini yang sering bikin orang bila
1:46
Cuma mau ambil nama depan… eh malah kepikiran: “Ini paling rapi p…
5.3K views1 month ago
TikTokbossexcel.id
Lookup the Second, the Third, or the Nth Value in Excel
12:20
Lookup the Second, the Third, or the Nth Value in Excel
Jul 5, 2017
trumpexcel.com
Display sorted values with helper column
Display sorted values with helper column
Oct 26, 2022
exceljet.net
Double (Nested) XLOOKUP - Dynamic Columns - Excel
Double (Nested) XLOOKUP - Dynamic Columns - Excel
Jul 26, 2023
automateexcel.com
INDEX Function
INDEX Function
Aug 30, 2024
exceljet.net
List sheet index numbers
List sheet index numbers
Nov 28, 2017
exceljet.net
VLOOKUP on Two or More Criteria Columns - Excel University
VLOOKUP on Two or More Criteria Columns - Excel University
Jan 10, 2014
excel-university.com
INDEX and MATCH all matches
Apr 5, 2023
exceljet.net
INDEX and MATCH with multiple criteria
May 12, 2024
exceljet.net
How to Use INDEX MATCH With Multiple Criteria in Excel
Jun 16, 2022
spreadsheeto.com
0:33
How to Find 1st, 2nd & 3rd Position in Excel | Rank Students by Name
204 views2 weeks ago
YouTubePrakash_Info_Point
1:48
عكس ترتيب البيانات في الاكسل Reverse Data Order in Excel INDEX Formula vs …
2 views1 month ago
YouTubeEssam Khwealeh
0:46
XLOOKUP in Excel 🔥 | Total Sales by Name in Seconds (Better than VL…
115 views3 weeks ago
YouTubeExcel Expert
4:05
Stop Using Helper Columns in Excel (Smarter VLOOKUP Formula)
25 views1 month ago
YouTubeEasy Click Learning
0:05
Google Sheet Expert on Instagram: "📊 Excel Functions That Go Well Tog…
2.6K views4 weeks ago
Instagramadvance.excel
5:52
The Excel TRANSPOSE Function
464.2K viewsDec 7, 2020
YouTubeTechnology for Teachers and Students
1:54
How to use COLUMN function in Excel
33K viewsOct 14, 2015
YouTubeExcel Tip
7:08
VLookup on Multiple Sheets in Excel
313.5K viewsDec 16, 2019
YouTubeSyed Shah Zahurullah Hussaini
2:39
MS Excel - Index Function
949.9K viewsJan 15, 2018
YouTubeTutorialsPoint
13:34
How to Use the NEW & IMPROVED Excel XLOOKUP (with 5 Examples)
3.9M viewsNov 28, 2019
YouTubeLeila Gharani
15:29
INDEX MATCH Excel Tutorial
557.4K viewsJul 14, 2021
YouTubeKevin Stratvert
10:47
Excel: INDEX and MATCH
255.1K viewsFeb 8, 2021
YouTubeTechnology for Teachers and Students
5:07
Excel Index Match Tutorial
1.2M viewsNov 4, 2017
YouTubeTEKNISHA
6:14
Rename Column Headers Based on Excel Table | Power Query
40.1K viewsApr 2, 2021
YouTubeExcel Newb
10:18
TECH-002 - Find a value in intersecting rows and columns in …
76.2K viewsApr 7, 2017
YouTubeThe Excel Challenge
8:21
Creating Cascading Dynamic Drop Downs in Excel | Everyday Office …
22K viewsApr 28, 2017
YouTubeNeil Malek
7:13
Adding a Category column to Excel data - using Excel techniques
184.7K viewsMay 8, 2014
YouTubePrepYourData
9:22
How to Use the Excel FILTER Function - Lookup to Return Multi…
762.8K viewsJan 9, 2020
YouTubeLeila Gharani
10:27
3 Easy Ways to Flip Data in Excel (Reverse the Order in Columns / R…
196.8K viewsMar 2, 2021
YouTubeTrumpExcel
2:47
How to use the INDEX function in Excel
591.1K viewsOct 16, 2018
YouTubeTechOnTheNet
See more videos
Static thumbnail place holder