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

Spreadsheets

A spreadsheet is a computer application for organization, analysis, and storage of data in tabular form. Under this category, you will learn tips and tricks for using various types of spreadsheet applications. Mainly we will be discussing spreadsheets applications such as Microsoft Excel and Google Sheets.

How to compare two columns in Google Sheets

May 10, 2022May 7, 2022 by Admin
How to compare two columns in Google Sheets

When working with data, you may come across situations where you need to compare two or more datasets. For example, you may …

Read more

Create A Crypto Portfolio Tracker in Google Sheets

May 10, 2022February 27, 2022 by Admin
Crypto Portfolio Tracker in Google Sheets

This post will show you how to create a Crypto Portfolio Tracker in Google Sheets. With this Google Sheet, you can track …

Read more

Upload files to Google Drive with Google Apps Script Web Apps

May 10, 2022January 29, 2022 by Admin
Upload files to Google Drive with Google Apps Script Web Apps

We have created a number of Google Apps Script Web Apps that can be used for data collection purposes in our previous …

Read more

How to Generate a Data Entry form in Excel

May 10, 2022December 21, 2021 by Admin
How to Generate Data Entry form in Excel

Using the “Form” command, you can easily generate a data entry form in Excel. Data entry forms provide a convenient means to …

Read more

Excel Named Range – Make Your Work Easier!

May 10, 2022November 28, 2021 by Admin
Excel Named Range – Make Your Work Easier!

We identify each cell in the spreadsheet by a combination of its column letter and row number. A range of cells is …

Read more

The Ultimate Guide to Handle Duplicates in Excel

July 14, 2021June 20, 2021 by Admin
The Ultimate Guide to Handle Duplicates in Excel

This post will show you how to handle duplicate entries or, in other words, repeated data in your data set in Microsoft …

Read more

How to Embed Google Apps Script Web Apps in Websites

July 18, 2021May 30, 2021 by Admin
How to Embed Google Apps Script Web Apps in Websites

In previous tutorials, we created some Web Apps with Google Apps Script and Google Sheets. This post will show you how to …

Read more

How to Create a Button in Google Sheets to Run Scripts

May 10, 2022May 12, 2021 by Admin
How to Create a Button in Google Sheets to run Scripts

You can create a button in Google Sheets to run Apps Script from its user interface. The button is essential when you …

Read more

How to Create Tables in Google Sheets

December 22, 2021March 15, 2021 by Admin
How to Create Tables in Google Sheets

This post will show you how to create tables in Google Sheets to manage your data easily. In Microsoft Excel, the table …

Read more

How to pull data from Google Sheets to HTML table

December 6, 2021February 9, 2021 by Admin
How to pull data from Google Sheets to HTML table

You can build several types of Web Apps using Google Sheets Apps Script. In previous posts, we discussed creating several types of …

Read more

Post navigation
Older posts
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