Fundamentals of Google Sheets for Beginners

Google Sheets is a cloud based spreadsheet application.

Google Sheets is easy to use and it is the best online spreadsheet program.

It is free to use if you have a Google account (for personal use) or Google Workspace account (for business use).

Using it you can create, edit, and collaborate from any device.

Multiple users can edit the same spreadsheet in real time.

All changes are automatically saved.

There is Version History option to see old versions of the spreadsheet, it is sorted by date and who made the change.

You can also make the Sheets file available offline to use it without internet.

Excel files can be opened in Google Sheets and you can download Google Sheets file as .xlsx that is in Excel format.

There are many helpful add-ons available for Sheets.

To access Google sheets just go to docs.google.com

  • Click on the 3 lines at top left
  • Select Sheets
  • Click on the + icon to create blank spreadsheet or you can choose one of those templates
Get started with Sheets by watching this video. Specially made for beginners:

Popular posts from this blog

Formula to Get Country Flags in Google Sheets

Image
I have created a formula to insert country flags in Google Sheets's cells. For this I've used IMAGE, IMPORTXML and SUBSTITUTE functions. In this formula we're taking flag images from Wikipedia.   You can paste below formula in your Google Sheets: =IMAGE("https:"&IMPORTXML("https://en.wikipedia.org/wiki/Gallery_of_sovereign_state_flags","//img/@src[contains(.,'"&SUBSTITUTE(A2," ","_")&"' )]"))  Change A2 with the cell address in which you are typing country name. You need to type first letter of country name in capital letter in order this to work. I have explained this formula in my below YouTube video. You can watch this video to understand how it works:
Read more

Steps to Turn On Offline Access for Google Docs, Sheets and Slides

Image
You aren't connected to the Internet but still want to work on Google Docs files? Then follow below steps to create, edit or view Google Docs, Sheets and Slides files while you're offline. Connect to the internet. Open or Install Google Chrome browser. Install Google Docs Offline Chrome extension. ( Click Here to Open Install Page ) Open Google Drive Click on Settings Check the box next to "Create, open, and edit your recent Google Docs, Sheets, and Slides files on this device while offline. Done Now you can click on File menu of any Google Docs, Sheets and Slides file and click Make available offline to use that file offline. Alternatively, you can right click on files in Google Drive and then click on Available offline. Watch detailed video on this:
Read more