Google Sheets is the most popular cloud-based spreadsheet application. It is also one of the best alternatives to Microsoft Excel. The best thing is, Google has made this tool available for free. You only need to have a free Google account to access Google Sheets. On bpewebs.com, under this category, you can find some tips and tricks to improve productivity with Google Sheets.
In a previous post, I showed you “How to Create a Dependent Dropdown List in Google Sheets“. However, you can only apply …
Read moreHow to Create a Dependent Dropdown List in Google Sheets and apply to Multiple Rows
You may read several online articles/ blog posts a day. Sometimes you may forget what you read and again another day you …
When it comes to mass data entry works, it is very essential to use data entry forms in order to improve accuracy …
The drop-down lists are useful when you are creating data entry forms or creating interactive dashboards to present your data. While creating …
Read moreHow to Create a Dependent Drop-Down List in Google Sheets
With Google sheet app script, (similar to MS Excel VBA) you can extend the functionalities of the Google Sheet. In addition to …
Read moreAutomate Google Sheet to get Google Map Travel Time and Distance