This article contains formulae and solution to real life challenges that people face in Google Sheets. It will help you learn Google Sheets and elevate your skills from beginner to professional.
Google Workspace formerly known as G-Suite was launched in 2006. It provides a comprehensive cloud-based solution to manage your business operations, including email, document creation, spreadsheet analysis, presentation design, and more.
It consists products like Gmail, Contacts, Calendar, Meet, Chat, Drive, Google Slides, Google Sheets, Google PPT and many more.
What is Google Sheets
You can open Google Sheets from here.
Google Sheets represents ~5% of market share of Google Workspace (~84%) in global market of office suite.
Google Sheets is a free online spreadsheet software which is similar to Microsoft Excel. You can use it in any modern browser, and it supports various file formats, including .xlsx, .csv, and .txt. You can also integrate Google Sheets with other Google Workspace products using Google’s coding platform, Google Apps Script
Google Sheets Facts – You can add up to 10 Million rows and 18,278 columns. It also has a file limit up to 100 MB and you can create up to 200 tabs in one single Google Sheet
You can share Google Sheets with multiple people and all can View/Edit/Comment at the same time.
Having said that, it can also help you at times when you don’t have internet connectivity with its offline Editing feature
Getting Started with Google Sheets
If you are completely new and want to learn Google Sheets with a mentor on call, you can contact us at datainnutshellsolutions@gmail.com.
We update this web page frequently to summarize all types of latest formulas and queries in one place.
Google Sheets – Formulae & General Queries
In case if you don’t find what you are looking for then please email us or comment us and we will help you.
| Formulae | General Queries |
|---|---|
| VlookUp() | VlookUp() between sheets |
| VlookUp() from another sheet | |