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 Project Gantt Chart is made with Google Sheet and not compatible with Microsoft Excel, because some important formula is not available on Excel. It’s not as complicated like Microsoft Project, but not very simple neither. You can input project...
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...
