Google Sheets: How to make spreadsheets better than Excel

2
16221
Learn to use Google Sheets
Excel Spreadsheets

It is known that the Excel is an excellent tool for working with spreadsheets, graphs, functions and other resources. If you use or have ever used, know the importance of having basic knowledge e in Excel.

However, on some occasions we need to work with spreadsheets on computers that do not have Excel installed. With this, Google brought the possibility of acting online with spreadsheets and other documents for free. The cool thing is that the logic of Google Sheets is the same, so if you already knew Excel, you will not need to learn everything again, it already has a very similar structure.

google spreadsheets

But what about you, do you know how to use Google spreadsheets (or Excel spreadsheets)? Thinking about this, we separate a step by step so that you can know this tool and use it to facilitate your daily activities when necessary. Follow our post and learn how to use Google spreadsheets!

Step 1: Login to the site

The first step to getting access to Google spreadsheets is through the link: https://drive.google.com

Learn to use Google Sheets

At this stage, in order to access Google Drive (the application that manages and stores the files), you need to get an email account in Gmail. If you do not already have an account, you can create it for free by visiting the following link: gmail.com

Once the Gmail account is provided, simply go to the Google Drive link and click the "Go to Google Drive". In this way, the login will be done with the created or existing email account. After accessing, a new screen will be displayed as below:

Learn to use Google Sheets

Step 2: Creating Worksheets

After accessing Google Drive, click the "New" button at the top left of the screen and choose "Sheets" as shown below:

Learn to use Google Sheets

A new tab will open the browser, where you will see the worksheet similar to Microsoft Office.

Google Sheet

3: Step Using the Worksheet

After accessing the Google spreadsheet, you can see that features, even though they are restricted, are still roughly the same as Microsoft Excel. In the image below we have a simple example of the use of the spreadsheet where we will calculate the commission of each seller based on 10% of total sales.

Learn to use Google Sheets

With this, just insert the following function.

Learn to use Google Sheets

At the end of the function, just hit enter and check the result.

Learn to use Google Sheets

With the use of the fill loop, we can still replicate the formula for the other cells.

Learn to use Google SheetsImportant: Google Drive features will be displayed in English. In this case, we recommend consulting the function translations (English - Portuguese) mentioned in this article.

4 Step: Saving and Renaming

Once you've created the spreadsheet, you can see that Google automatically saves all the transactions you've made. This does not run the risk of losing information created in cases of browser crashes or any other problem. In this way, the worksheet will be visible in a workspace just on the home page.

In any case, it is recommended to rename the spreadsheet with the desired name for later identification. To do this, just access: Aquivo> Rename ...

Learn to use Google Sheets

A new tab will open. In this case just enter the name you want and click OK and that's it, the worksheet will be saved with the new name.

Learn to use Google Sheets

5 Step: Sharing the Worksheet

To share the spreadsheet with others, just click on the "Share" button located in the upper right corner as shown in the image below:

Learn to use Google Sheets

This will open a new window where you can share it with specific people by entering their email addresses in the field.

If you want to make the spreadsheet accessible and editable for the whole audience, simply go to the Advanced option as shown in the image below.

Learn to use Google Sheets

Then select the "Change"

Learn to use Google Sheets

And finally, select the option "Enabled - Public Web" and click Save.

Learn to use Google Sheets

Note that Google will allow sharing of the spreadsheet through a link or through social networks.

Learn to use Google SheetsNote: To re-access the worksheet after it's closed, simply log in to Google Drive and access and click on the desired file under the "My Drive" option.

Learn to use Google Sheets

Based on the knowledge acquired here, it was possible to know the basic steps to use Google Spreadsheets.

Possible Applications:

At that point, you should be thinking about which types of spreadsheets would be well used in Google Sheets. Therefore, I will list below some applications that we believe are useful for your business:

Worksheet for Cost Control / Expenses: This is the most common type of spreadsheet use on google. You can make a quick list with total formula and also classify expenses both for managing your business and your home. Some people also call this type of personal budget worksheet or monthly expense control worksheet.

Inventory Control Worksheet: With a very similar spreadsheet structure you can create a quick list of all items in your inventory with check-in and check-out dates to control your flow and re-purchase time. If you are interested in this type of worksheet for excel, see this link our template template ready for use.

Spreadsheet for Financial Control: By slightly evolving the cost / expense worksheet, by adding revenue control, you can quietly make a complete financial spreadsheet of your business through google spreadsheets.

However, it should be noted that this tool has some feature restrictions compared to Microsoft Excel. On the other hand, it becomes an excellent resource when you do not have Excel installed on a computer or the flexibility of being able to share spreadsheets with other people and to be able to access it on any device that has an internet connection.

google spreadsheets

Did you like the tip? So to learn how to make spreadsheets in excel, see our courses and use your knowledge to make excel spreadsheets or spreadsheets online in google documents.

Excel Spreadsheets

2 COMMENTS

  1. Hi Bruno, LUZ does not develop custom spreadsheets. We have a forum that can help you find a developer (forum.luz.vc)

  2. Rafael, good afternoon.

    I wonder if you create spreadsheets on Google according to a certain request, if so, could you kindly contact bmgiacominiq@gmail.com, I will try by email, explain in detail what I need and so we get values.

    Thank you.

    Bruno.

LEAVE AN ANSWER

Please, write your comment
Please enter your name