Google Sheets Tips
How to Make a Table in Google Sheets (with Formatting Tips)
If you work with the data in Google Sheets, it would be safe for me to assume that you have it in a tabular format (i.e., have the data in a table). While you can
Google Sheets Tips Articles
Charting
How to Make an Organization Chart in Google Sheets (Org Chart)
An organization chart is quite commonly used in presentations and reports. it’s a simple chart that shows the hierarchy of who reports to whom in an organization. Below is an example of a simple org
Google Sheets Tips
How to Highlight Highest or Lowest Value in Google Sheets (Easy Way)
When working with data in Google Sheets, you may have a need to highlight the highest value (the maximum value) or the lowest value (minimum value) in the data set. And you can easily do
Formulas
Convert Decimal to Fractions in Google Sheets (2 Easy Ways)
Google Sheets is a smart spreadsheet tool that has been made to be user intuitive. This means that sometimes when you enter data in Google Sheets, it will try to understand what you mean and
Google Sheets Tips
How to Get the Last Value in a Column in Google Sheets (Lookup Formula)
If you work with ever-expanding data (where you keep adding more values in the column or in the row), then sometimes you may have a need to know what’s the last value in the column
Google Sheets Tips
How to Get the Column Letter in Google Sheets (Easy Formula)
Recently I got this query from a reader on whether there’s a formula to get the column letter instead of the column index number in Google Sheets. For example, column #7 in Google Sheets is
Formulas
How to Get the Sheet Name in Google Sheets (Formula)
Sometimes, you may want a quick way to get the name of the current sheet in a cell (or a list of all the sheets in the Google Sheets documents in cells). One common scenario
Formulas
How to Scrape Websites Using Google Sheets Formulas (Examples)
Google Sheets has some kick-ass functions that can do a lot of heavy lifting. As a part of my online work, I often need to go to some websites and extract specific data points or
Google Sheets Tips
Count Cells based on the Cell Color in Google Sheets
The more I use Google Sheets, the more I realize how powerful it is. And at the same time, there are some things that I wish were an inbuilt part of Google sheets. One such
