How to split cells in Google Sheets?
Occasionally you can import data into Google Sheets that does not split itself into columns. Let’s take a look at how to split data in...
About GoogleFinance function() in Sheets
GoogleFinance is a function in Google Sheets which allows users to retrieve current or historical financial information about stock prices, currency exchange rates, and financial...
How to publish data from a private sheet?
On one of my other websites, I have my stock portfolio page where I want to show my readers how successful my investment is. Today...
How convert unix timestamp to date in Sheets?
In today’s article, I will show you how to convert Unix time to a readable date time in Google Sheets. Unix time, also known as...
IFERROR function in Google Sheets
Today we will look on function IFERROR which you should use in Google Sheets to fix #N/A as results of other functions. For me IFERROR...
Basic arithmetic function in Sheets
Basic functions that you will use in Google Sheets on a daily basis are arithmetic functions. In today’s article I will show you arithmetic functions...