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 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 moreHow to use Google Sheets for Project Management

Multi-Row Dependent Dropdown List in Google Sheets

December 18, 2020September 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 moreMulti-Row Dependent Dropdown List in Google Sheets

How to Calculate Loan Repayments with Google Sheets

December 23, 2020July 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 moreHow to Calculate Loan Repayments with Google Sheets

How to Create Data Entry Form with Google HTML Service and Submit Data to Google Sheets

December 20, 2020June 5, 2019 by Admin
How to Create Data Entry Form with Google HTML Service and Submit Data to Google Sheets

Data entry is one of the important steps in the data analysis process. It is important that the data collected is correctly …

Read moreHow to Create Data Entry Form with Google HTML Service and Submit Data to Google Sheets

How to create a Data Entry form in Google Sheets

December 25, 2020April 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 moreHow to create a Data Entry form in Google Sheets

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 moreHow to Create a Dependent Drop-Down List in Google Sheets

20 Excel Tips and Tricks to Save Time

December 16, 2020May 8, 2018 by Admin
Excel tips and tricks

Microsoft Excel is the most widely used spreadsheet application. We can use it in many ways to achieve the same result. However, …

Read more20 Excel Tips and Tricks to Save Time

10 Benefits of Converting Data into Excel Tables

December 19, 2020December 13, 2017 by Admin
10 Benefits of Converting Your Data into Excel Tables

The table feature of Microsoft Excel allows you to manage and analyze related data easier. With Excel tables, you can manage rows …

Read more10 Benefits of Converting Data into Excel Tables

10 Microsoft Excel Tips to Save Time and Work Faster

December 19, 2020November 14, 2017 by Admin
10 Microsoft Excel Tips to Save Time and Work Faster - new

Microsoft Excel is one of the most used productivity tools out there. The things that you can do with it is endless. …

Read more10 Microsoft Excel Tips to Save Time and Work Faster

Visualizing and Presentation Styles in Excel – Conditional Formatting

December 11, 2020November 2, 2017 by Sampath Chandrasena
Conditional Formatting

in Microsoft Excel conditional formatting is one of basic style for visualizing a set of data using colour ranges without changing the …

Read moreVisualizing and Presentation Styles in Excel – Conditional Formatting

Post navigation
Newer posts
← Previous Page1 Page2

Popular Posts

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

Subscribe to Blog via Email

First Name
Your Email

Recent Posts

  • How to easily remove image background for free December 27, 2020
  • How to share a single Sheet in Google Sheets December 11, 2020
  • How to use Google Sheets Checkbox – [6 Examples] December 8, 2020
  • How to create a web form to get data from Google Sheets November 5, 2020
  • Importing CSV Into Google Sheets (import CSV, TSV, and XLSX) October 10, 2020

Subscribe to Blog via Email

First Name
Your Email

Topics

  • Spreadsheets
  • Word Processing
  • Mapping
  • Other

Follow Us

  • Facebook
  • Pinterest
  • YouTube
  • LinkedIn
  • Twitter
  • Contact Us
  • Privacy Policy
  • About
  • Terms and Conditions
© 2020 bpwebs.com
  • Home
  • Mapping
  • Spreadsheets
  • Word Processing
  • Other
  • Write for Us