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.
WheeQo.web.id Blog
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
Project Gantt Chart with Google Sheet
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...
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...
