How to Sort Sheets and Create an Index (with Google Apps Script)
Using Google Apps Script to sort sheets and to create an index of every sheet in a document.
How to Underline in Google Sheets
How to underline in Google Sheets — a few quick and easy ways to do it.
How to Sum a Column in Google Sheets
How to sum a column in Google Sheets — multiple ways, including a quick shortcut.
How to Add Stacked Bar Totals in Google Sheets and Excel (an easier way)
How to make stacked bar totals in Google Sheets.
Build An API in Google Sheets and Google Apps Script
How to build a whole API in Google Sheets, sourcing data from a Google sheet you write, and retrieving it via HTTP Get.
How to use Google Sheets as JSON Database for Web Apps
How to use Google Sheets as the back-end database for a web application, producing JSON.
How to create Dynamic Arrays in Google Sheets with Concatenate, Split and Transpose
How to create dynamical arrays and tables in Google Sheets
How to Make a Table in Google Sheets (Native Tables)
Make a native table in Google Sheets, name its columns, use table references in formulas, and set up column types and views.
How to Use XLOOKUP in Google Sheets (Examples and Alternatives)
Google Sheets has XLOOKUP. Learn the exact-match formula, how to find the last match, and when FILTER is better for multiple results.
End of all posts :)
End of all posts :)