Google Sheet Class 1
Before using Google Sheets, you need to create a Gmail account. Since this course is from beginner to advanced level, we will cover everything from the beginning.
It’s important to understand what Gmail is and what email means. Gmail is a service name, and email is a method of sending and receiving electronic messages over the internet.
Creating a Gmail Account
To use Google Sheets, you first need to create a Gmail account. Follow these steps:
- Go to gmail.com.
- Click on “Create Account.”
- Fill in your details (name, username, password, etc.).
Copying and Pasting Data into Google Sheets for Lead Generation
In Google Sheets, you can copy and paste data in various ways. For lead generation, it’s best to use “Values Only” paste to avoid formatting or formulas, ensuring a clean sheet design when copying data from multiple sources.
Here are the shortcuts for Copy-Paste and Values Only Paste in Google Sheets. These shortcuts allow for faster data handling in Google Sheets!
Copy:
- Windows: Ctrl + C
- Mac: Cmd + C
Paste (Standard):
- Windows: Ctrl + V
- Mac: Cmd + V
Paste Values Only:
- Windows: Ctrl + Shift + V
- Mac: Cmd + Shift + V
Freezing and Unfreezing Columns & Rows
Freezing rows or columns keeps them visible while scrolling through large datasets.
To freeze a row or column:
- Open your Google Sheet.
- Click on View > Freeze.
- Select 1 row, 2 rows, or 1 column, etc.
To unfreeze a row or column:
- Click on View > Freeze > No rows or No columns.
Today, we’ll learn how to split and combine data using different ways.
To split text, you can use:
- =SPLIT(A2, ” “)
- Or use the menu in Google Sheets: go to Data > Split text to columns
To combine text (e.g., first and last names), you can use:
- =CONCATENATE(A2, ” “, B2)
- Or the shorter version: =A2 & ” ” & B2
These functions are commonly used to separate or combine names, such as first and last names. With a bit of creativity, these functions can be used in many different ways.
How to check and remove duplicate data using different methods in Google Sheets.
You can do this in several ways:
- Count duplicates using a formula like =COUNTIF(A:A, A1)
- Use a Format > Conditional formatting rule > Custom formula to highlight duplicates =COUNTIF(A:A, A1)>1
- Go to Data > Data cleanup > Remove duplicates to delete them automatically
