• Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us

No products in the cart.

  • Microsoft Office
  • Microsoft Windows
  • Other Software
    • Microsoft Visual
    • Microsoft Project
    • Microsoft Visio
  • Anti Virus
  • Blog
    • Word
    • Excel
    • Powerpoint
    • Software tricks/tips
  • POLICIES
    • PAYMENT GUIDE
    • SHIPPING POLICY
    • REFUND POLICY
    • TERMS & CONDITIONS
    • Contact Us
Software tricks/tips

5 Great Tips for Google Sheets Users to Know

0 Comments

Are you struggling with Google Sheets? Do you find it difficult to manipulate data in Google Sheets? Don’t worry, in this article, I will guide you through 5 great tips in Google Sheets that users should know. Let’s Buffcom.net explore them below!

Tip 1: Use Sparkline to insert small graphs

Sometimes, you may be dealing with a lot of numbers and you know that when working in a spreadsheet, you have rows and columns of numbers. Sometimes it’s hard to visualize extremely long numbers. Of course, you can create a chart in Google Sheets. But sometimes a chart is too much and you don’t want to use this large chart in your spreadsheet. You just want to quickly see the data that is happening in the spreadsheet. A great tip to help you do that is with the smart feature Sparkline.
The steps are as follows:
Step 1: Select any cell to display the Sparkline chart location.
Step 2: Type: =SPARKLINE(D2:D17)
Explanation: D2:D17: The range of data to analyze.Google Sheet 1

Tip 2: Share comments and notifications directly with others

Do you want to comment or add your opinion to the data so that everyone knows? It’s great that in Google Sheets, there is a feature that helps you do that. You just need to follow these steps:
First, at the cell where you want to insert a comment, right-click and select the Comment feature.

Google Sheet 2A box containing the comment will appear. Here, you can write what you want to comment or add to the data.

Google Sheet 3And people who access the sheet will see your comment and adjust accordingly.
Note: If you want people to see your comment quickly to adjust in time. You can tag everyone’s email in the comment box. By adding “@” after the comment line, you can type the email name of the person you want to send it to.

Google Sheet 4

Tip 3: Verify Email addresses in Google Sheets

During work, you want to send an email to the list of emails entered in the spreadsheet. But you want to check if that Email is correct or exists? A feature that cannot be missed helps you check it out!
First, you select the cell to check the email.
Next, you will type: =ISEMAIL(B3)
Explanation: B3: is the cell containing the email you want to check.

Google Sheet 5If the result displayed is True, then the email has been entered correctly and you can confidently send it to everyone!

Tip 4. Creating QR codes in Google Sheets

You want to create a QR code for your website. Usually, you would need to download an app or ask someone to do it for you. However, with this 4th tip, you won’t have to go through the trouble or ask anyone for help anymore!
In Google Sheets, there’s a feature that allows you to create QR codes quickly with the following syntax: =IMAGE(“https://chart.googleapis.com/chart?chs=200×200&cht=qr&chl=”&cell containing the website URL&””)
For example, let’s say you want to create a QR code for the website shown in the image below:

Google Sheet 6And you want to create QR codes for the other websites as well. Using the syntax above, you would type the following:
=IMAGE(“https://chart.googleapis.com/chart?chs=200×200&cht=qr&chl=”&A2&””)
Explanation: A2 is the cell containing the URL of the website you want to create a QR code for.

Google Sheet 7Tip 5. Removing spaces in the name field

When you have a spreadsheet containing a list of employee names in your company, sometimes the names are disorganized and have a lot of unnecessary spaces. You want to process that list, but don’t know how? Don’t worry, Google Sheets has a feature to help you with that!
First, in the cell where you want to display the result after processing, type: =TRIM(A2)
Explanation: A2 is the cell containing the data that needs spaces to be removed.

Google Sheet 8

And that’s it! I’ve just taught you 5 tips in Google Sheets that users need to know. I hope this article from Buffcom.net helps you. If you find it useful, don’t forget to rate the article below to help me out! Best regards.

Rate this post
45
345 Views
How to Create a CV on Word quickly and simplyPrevHow to Create a CV on Word quickly and simplyMarch 11, 2023
Replacing Values in the Source Query in ExcelMarch 11, 2023Replacing Values in the Source Query in ExcelNext

Leave a Reply Cancel reply

You must be logged in to post a comment.

Buy Windows 11 Professional MS Products CD Key
Buy Office 2021 Professional Plus Key Global For 5 PC
Top rated products
  • Kaspersky Total Security 2021 1 year 5 devices key Global Kaspersky Total Security 2021 1 year 5 devices key Global
    Rated 5.00 out of 5
    $46.00
  • Avast Premium Security 2021 Avast Premium Security 2021 1 Device 1 Year Global
    Rated 5.00 out of 5
    $11.00
  • Trend Micro Internet Security 3 Devices 1 Year Key GLOBAL Trend Micro Internet Security 3 Devices 1 Year Key GLOBAL
    Rated 5.00 out of 5
    $17.00
  • Windows 11 Pro Key Global Windows 11 Pro Key Global
    Rated 5.00 out of 5
    $6.00
  • AVG Internet Security 2021 10 Devices 2 Years Global AVG Internet Security 2021 10 Devices 2 Years Global
    Rated 5.00 out of 5
    $42.20
Products
  • Microsoft SQL Server 2019 Enterprise Microsoft SQL Server 2019 Enterprise $39.00
  • Windows Server 2019 Essentials Key Global Windows Server 2019 Essentials Key Global
    Rated 4.71 out of 5
    $7.00
  • Buy Office 2021 Professional Plus Key Global Bind To Your Microsoft Account Buy Office 2021 Professional Plus Key Global Bind To Your Microsoft Account
    Rated 4.71 out of 5
    $99.00
  • Microsoft Office Professional Plus 2019 CD Key Global Microsoft Office Professional Plus 2019 CD Key Global - 5 PC
    Rated 4.92 out of 5
    $32.00
  • Project Professional 2013 Microsoft Project Professional 2013 - 1 PC $9.00
  • Microsoft Office Professional Plus 2013 retail CD Key Global Microsoft Office Professional Plus 2013 retail CD Key Global
    Rated 4.97 out of 5
    $11.00
  • SQL Server 2019 Standard SQL Server 2019 Standard $20.00
  • AVG Internet Security 2021 10 Devices 2 Years Global AVG Internet Security 2021 10 Devices 2 Years Global
    Rated 5.00 out of 5
    $42.20
  • Microsoft Visio 2016 professional CD Key Global Microsoft Visio 2016 professional CD Key Global
    Rated 4.94 out of 5
    $28.50
  • Trend Micro Maximum Security 3 Devices 1 Year key Global Trend Micro Maximum Security 3 Devices 1 Year key Global
    Rated 5.00 out of 5
    $15.00
Product categories
  • Anti Virus
  • Microsoft Office
  • Microsoft Project
  • Microsoft Visio
  • Microsoft Visual
  • Microsoft Windows
  • Other Software
  • Uncategorized

Buffcom.net always brings the best digital products and services to you. Specializing in Office Software and online marketing services

BIG SALE 50% IN MAY

Microsoft Office
Microsoft Windows
Anti-Virus
Contact Us

Visit Us:

125 Division St, New York, NY 10002, USA

Mail Us:

buffcom.net@gmail.com

TERMS & CONDITIONS | PAYMENT GUIDE  | SHIPPING POLICY  | REFUND POLICY

Copyright © 2019 buffcom.net  All Rights Reserved.