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.
Category: Tutorial
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,...
Update Padfone S from Lollipop to Marshmallow
Recently ASUS has publish Android 6.0.1 Marshmallow firmware for Padfone S (WW SKU). This tutorial will show how to update Padfone S from Lollipop version 12.2.2.43 to Marshmallow 13.6.5.35.
Integrate FastCopy to FreeCommander for Copy and Move Operations
FreeCommander is an excellent tool for managing files and folder in Windows, also it free. But for file/folder operations like copy or move, it’s not the best in its class. While FastCopy is one of the best file/folder operations tool,...
