Recent Posts
- Sumit
- June 15, 2023
The Google Sheets SWITCH function is a helpful tool for changing how a cell behaves based on the value in another cell. Learn how to use it properly here!...
- Sumit
- June 15, 2023
Rounded numbers make your spreadsheets easier to read. So learning the Google Sheets ROUND, ROUNDUP , and ROUNDDOWN are all but necessary for sharing sheets....
- Sumit
- July 22, 2021
The following processes will teach you how to calculate weighted average using the weighted average formula in Google Sheets....
- Sumit
- April 22, 2022
VLOOKUP formula (or Vertical lookup) in Google Sheets is a formula that you can use to look for a value in a columnar data set. For example, if you have a list of student names and their scores, you c...
- Sumit
- April 11, 2023
You need to use custom formatting to apply Google Sheets phone number format by heading to Format > Number > Custom number format. Click here for more details....
- Sumit
- June 15, 2023
Google Sheets is a complex program and when others use your sheet it can be hard to understand. Learn how to make Google Sheets show formulas to make it easier....
- Sumit
- September 22, 2023
Learn how to highlight duplicates in Google Sheets with this comprehensive guide. We' cover several examples, including how to highlight every nth instance....
- Sumit
- September 15, 2023
Can Google Sheets VLOOKUP from another sheet? Yes, and it's pretty simple to do. Follow this guide to learn how....
- Sumit
- September 19, 2023
If you've been asking yourself, "Can Google Sheets convert text to number?" The answer is yes, in 6 different ways, learn them all here....
- Sumit
- November 10, 2020
If you work with text data in Google Sheets, there are many useful text functions that can help you slice and dice the text data or modify it easily. One of the common tasks that many people need to d...
- Sumit
- June 15, 2023
When working with data in Google Sheets, sometimes you may have a need to remove the last character from a string (or remove the last 2 or 3 or 5 characters). This can easily be done using some basic ...
- Sumit
- October 26, 2022
In this tutorial, you'll learn how to use the Google Sheets day of week (WEEKDAY) function to get the weekday numbers/name for a date. All in one easy step!...