Skip to content
bpwebs.com
bpwebs.com
  • Spreadsheets
  • Word Processing
  • Mapping
  • Other

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.

Importing CSV Into Google Sheets (import CSV, TSV, and XLSX)

December 18, 2020October 10, 2020 by zakiyung
importing CSV into Google Sheets

In the previous tutorials, we talked about importing data from another sheet in the same spreadsheet and from other spreadsheets to Google …

Read more

How to import data from one Google Sheet to another

May 10, 2021September 30, 2020 by Admin
import data from one Google Sheet to another

In the previous tutorial, we discussed how to import data from another Sheet in the same Google Spreadsheet. This tutorial will show …

Read more

How to import data from one Sheet to another in Google Sheets

December 18, 2020September 2, 2020 by Admin
import data from one sheet to another in google sheets

It is easy to do your analysis when your raw/ source data is in a separate Sheet. Because it makes your analysis …

Read more

How to Create an Online Data Entry Form that can Perform CRUD Operations on Google Sheets

July 17, 2021May 2, 2020 by Admin
How to Create an Online Data Entry Form that can Perform CRUD Operations on Google Sheets

Online data entry forms are a powerful tool that you can use to collect many types of data more easily and accurately. …

Read more

How to use Google Sheets for Project Management

December 16, 2020November 2, 2019 by Admin
How to use Google Sheets for Project Management

There are many Project Management Tools available in the market. Many of them have cloud versions that you can access with a …

Read more

Multi-Row Dependent Dropdown List in Google Sheets

July 18, 2021September 3, 2019 by Admin
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 …

Read more

8 ways to keep track of what you read online

December 16, 2020August 11, 2019 by Admin
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 …

Read more

How to Calculate Loan Repayments with Google Sheets

April 7, 2021July 7, 2019 by Admin
Calculate Loan Repayments

Are you planning to take a loan? If so, what is your monthly payment would be? Will you be able to afford …

Read more

How to create a Data Entry form in Google Sheets

July 17, 2021April 28, 2019 by Admin
Data Entry form in Google Sheet

When it comes to mass data entry works, it is essential to use data entry forms to improve accuracy and speed. This …

Read more

How to Create a Dependent Drop-Down List in Google Sheets

December 18, 2020February 27, 2019 by Admin
Dependent Drop-Down List

The drop-down lists are useful when you are creating data entry forms or creating interactive dashboards to visualize your data. Sometimes, you …

Read more

Post navigation
Older posts
Newer posts
← Previous Page1 Page2 Page3 Next →

Popular Posts

  • How to pull data from Google Sheets to HTML table
  • How to create a Data Entry form in Google Sheets
  • How to Calculate Loan Repayments with Google Sheets
  • How to Export Google My Maps Data Table to Excel
  • How to Create an Online Data Entry Form that can Perform CRUD Operations on Google Sheets

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Recent Posts

  • How to compare two columns in Google Sheets May 7, 2022
  • Create A Crypto Portfolio Tracker in Google Sheets February 27, 2022
  • Upload files to Google Drive with Google Apps Script Web Apps January 29, 2022
  • How to Generate a Data Entry form in Excel December 21, 2021
  • Excel Named Range – Make Your Work Easier! November 28, 2021

Topics

  • Spreadsheets
  • Word Processing
  • Mapping
  • Other

Follow Us

  • Facebook
  • Pinterest
  • YouTube
  • LinkedIn
  • Twitter

Subscribe to Blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

  • Contact Us
  • Privacy Policy
  • About
  • Terms and Conditions
© 2020 bpwebs.com
  • Home
  • Mapping
  • Spreadsheets
  • Word Processing
  • Other