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: Google
Membuat Kalender Cetak dengan Libur Nasional dari Google Calendar
Membuat Kalender Cetak dengan Libur Nasional dari Google Calendar
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...
Menulis Arab dengan Input Suara di Android
Demo cara menulis Arab dengan input suara di Android menggunakan aplikasi keyboard Swype. Dalam video demo ini, saya mencoba menulis surat Al-Fatihah. Yang paling susah saat ayat ke-6 dan ke-7, cukup sulit bagi saya melafazkan huruf shad dan tha sehingga...
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.
Review Security Checkup on Google Account for 2GB Drive Storage Bonus
To celebrate Safer Internet Day 2016, Google will give 2GB Drive storage bonus, just go to Security Checkup link and review your account security.
Update Android Nexus with Factory Image without Wipe Data
This tutorial will show how to update Android Nexus with Factory Image without Wipe Data with Nexus Root Toolkit. Be warn that this process only recommended for minor number update only and stock ROM, for this case update Nexus 4...
Create Table in WordPress from Google Sheets
Creating table from spreadsheet application (such as Excel, Calc, or Google Sheets) is much faster than to do it from HTML editor. Converting table from spreadsheet application to HTML code is not too difficult but the problem is the generated...
Control Location Mode to Save Battery with Tasker [Android Tips]
Location Mode on Android when turned on is quite draining the battery, but user still make use of it for particular condition or apps. This tutorial will show how to control Location Mode to save battery from rooted Android Lollipop...
