Excel LOOKUP Formula: Memilih Otomatis Ukuran Gland Kabel dari Kabel
Menggunakan formula LOOKUP Excel untuk memilih otomatis ukuran gland kabel dari kabel yang terpilih berdasarkan kabel diameter minimal yang diizinkan untuk masuk gland kabel.
Category: Tutorial
Combine Multiple Power Query Excel Files
This tutorial will show you how to combine table from multiple excel files produced from power query into one table also with power query.
Use QUERY Formula in Google Sheet as Replacement of PivotTable Function
QUERY formula can be used as replacement of PivotTable function. However this formula can only be used in Google Sheet not other spreadsheet application.
Membuat Kalender Cetak dengan Libur Nasional dari Google Calendar
Membuat Kalender Cetak dengan Libur Nasional dari Google Calendar
Membuat Heading dengan Nomor di Microsoft Word
Langkah-langkah membuat heading dengan penomoran di Microsoft Word
Summarize Cable Schedule Easily with Google Sheet
This tutorial will show how to summarize cable size & length, cable gland, and cable lug from cable schedule easily with Google Sheet. Steps: Copy Cable Size & Cable Length column from cable schedule spreadsheet to Google Sheet. Rename this...
Fix Windows 10 File Explorer “Working on It” – Not Responding
The problem: when open File Explorer, it become not responding and shows “Working on it” with circling blue cursor. After several attempts fixing the problem from Internet and fail, I experiment these simple steps to Fix Windows 10 File Explorer...
Custom Content Control Microsoft Word
One of the uses of content control is to add consistency in repeated use of word or sentence. When one of the sentence is changed, the same sentence in another place will automatically changed. Therefore can minimize writer error. To...
[Tips Word] Menggunakan Quick Parts untuk Konsistensi Identitas Document
Bagi pengguna Microsoft Word terkadang direpotkan oleh identitas dokumen, seperti judul dokumen dan nomor dokumen, yang tersebar di beberapa lokasi (lihat screenshot), seperti di cover, di revision sheet, di header atau di footer; sehingga apabila ingin dirubah identitas tersebut, maka...
Kustomisasi Jumlah Halaman di Microsoft Word
Kadangkala user mengedit satu judul dokumen yang terbagi menjadi beberapa file, bisa gabungan file Word dan/atau Excel. Manakala user memasukkan jumlah halaman (field code: NUMPAGES ) di file Word, maka yang terhitung hanya jumlah halaman di file Word itu sendiri,...
