R. Bambang Widiatmoko Personal Blog | Sharing Knowledge to the World
Tutorial untuk import / mengambil data dari tabel di PDF ke Excel dengan Power Query. https://youtu.be/Q486jSEGjk0 Biasanya kalau copy paste data dari tabel di PDF ke Excel hasilnya kurang memuaskan. Di Excel ada fitur Power Query yang dapat mengambil data...
Menggunakan formula LOOKUP Excel untuk memilih otomatis ukuran gland kabel dari kabel yang terpilih berdasarkan kabel diameter minimal yang diizinkan untuk masuk gland kabel.
This tutorial will show you how to combine table from multiple excel files produced from power query into one table also with power query.
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
Langkah-langkah membuat heading dengan penomoran di Microsoft Word
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...
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...
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...
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...
