How to use the notorious VLOOKUP function in Google Sheets?

And how to overcome the various challenges it poses. One of the most amazing (and confusing) function of Google Sheets (or Microsoft Excel) is VLOOKUP.

Google Finance - Stocks & Currency Exchange Data to a Spreadsheet - Google Sheets

Learn how to get Google Finance stock market & currency exchange data to a Google Sheets spreadsheet using GOOGLEFINANCE function.

Set up Google Sheets API in Minutes

Set up Google Sheets API in Minutes - Using local Excel files can be a pain. In this post we are going to learn how to activate the Google Sheets API so we can access and write…

How to send data from Google BigQuery to Google Sheets and Excel

How to send data from Google BigQuery to Google Sheets and Excel. Learn how to automatically and quickly send data from Google BigQuery to Google Sheets and Excel.

How to Use Google Sheets with D3.js and Google Visualization

The D3.js visualization library can be used for creating beautiful graphs and visualizations using data from external sources including CSV files and JSON data. In this post, you'll see How to Use Google Sheets with D3.js and Google Visualization