Become a Pro in Google Sheets
Home to a Rare Collection of Google Sheets Tutorials
Functionsguide
Excel vs. Sheets
See the comparisons of some of the very popular Excel and Google Sheets functions.
Charts in Google Sheets
Learn to create different types of charts in Google Sheets, including line, bar, column, waterfall, radar, scatter, bubble, geo charts, etc. Also, learn to plot a custom Gantt chart using Sparkline.
Recent Articles
Creating a Running Balance with Dynamic Array Formulas in Excel
For calculating a running balance, we can utilize the SCAN function, which is a dynamic array function available in Excel.
Before we proceed, it's important...
Comparing the FILTER Function in Excel and Google Sheets
I believe comparing the differences in how the FILTER functions work in Excel and Google Sheets is important. While they both do the same...
Quartile IF in Google Sheets
To calculate quartiles based on conditions, referred to as "Quartile IF," we will use a combination of formulas in Google Sheets.
Sometimes, you may want...