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.

  • Sumif
  • Vlookup
  • Indirect and a few more...

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.

Make Charts in Google Sheets

Recent Articles

Creating a Running Balance with Dynamic Array Formulas in Excel

0
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

0
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

0
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...