Import CSV and Excel Data Into Google Sheets
In the previous tutorials, we’ve been talking about how you can import data from another sheet in the same spreadsheet and from …
Google Sheets
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.
Import Data in Google Sheets #2 Import Data from other Spreadsheets
This is part #2 of the import data in Google Sheets tutorials. In this tutorial I am going to show you how …
Read moreImport Data in Google Sheets #2 Import Data from other Spreadsheets
Import Data in Google Sheets #1 Import Data from another Sheet in the same Spreadsheet
When you are working with analysis works, it is a good practice to keep your row data in separate sheets. And you …
Read moreImport Data in Google Sheets #1 Import Data from another Sheet in the same Spreadsheet
Multi-Row Dependent Dropdown List in Google Sheets
In a previous post, I explained how to create a simple dependent dropdown list in Google Sheets. However, using that method you …
How to keep track of what you read online
You may read several online articles/ blog posts a day. Sometimes you may forget what you read and again another day you …
How to create a Data Entry form in Google Sheets
When it comes to mass data entry works, it is very essential to use data entry forms in order to improve accuracy …
How to Create a Dependent Drop-Down List in Google Sheets
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
Automate Google Sheet to get Google Map Travel Time and Distance
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