Google Spreadsheets

Зміст курсу

Google Spreadsheets

Google Spreadsheets

1. Introduction to Google Sheets

Why do you need Google Sheets?Creating Google Sheets Opening Google Sheets Renaming Google Sheets Copying Google Sheets Deleting Google Sheets Moving Google Sheets Downloading Google Sheets

2. Formatting of Cells and Ranges

Basic Editing Operations Formatting Data Working with Fonts Formatting Text and Filling with Color Formatting Borders Merging Cells and Text Alignment Clear Formatting and Paint Format Tools Selecting Cells and Ranges Adjusting Column and Row Size and Position Copying and Deleting Columns and Rows Freezing and Grouping Rows and Columns

3. Advanced Formatting of Cells

Splitting Text to Columns Trimming Whitespaces Inserting Internal and External Hyperlinks Autocompleting Cells Creating Checkboxes Creating Forms Adding Notes Adding Images Creating Drawings Challenge: Mastering Event Planning Challenge Challenge: Your Event, Your Plan

4. Sorting, Filtering and Cleaning Data

Find and Replace Sorting Range Searching Filter and Filter by Condition Custom Filter Views Conditional Formatting and Color Scale Using Slicers Named Range Removing Duplicates Challenge: Library Book List Management

5. Creating Charts

Line Chart Basic Chart Settings Chart Style and Chart and Axis Titles Legend, Gridlines and Ticks Horizontal and Vertical Axis Customization Area Chart Columns and Stacked Columns Pie Chart Challenge: Data Visualization Sprint Sales Insights

6. Basic Functions

Basic Calculations Arithmetic Functions Statistical Functions Rounding Functions Working with Numbers and Integers Working with Roots and Powers Random Number Generation Text Functions Working with Dates and Time Sort Function Challenge: Sales Visualization Trends and Analytics

7. Logical Functions

AND and OR Functions IF and Nested IF Functions IFS Function SUMIFS, COUNTIFS and AVERAGEIFS Challenge: Employee Performance and Payroll Analysis with Excel Functions

8. Collaboration and Security

Access Control and Real-Time Document Collaboration Notification Rules Chatting with Other Users Protecting Sheets and Ranges Comments and Google Meet Integration Version History and Data Recovery

Removing Duplicates

In this chapter we will cover the topic Removing Duplicates. This tool is used to find and remove duplicate entries, which is especially useful when working with data that contains duplicate rows or values.

Deleting Duplicates

Select the range of data:
- Highlight the area of the table where you want to remove duplicates;
Go to Data → Data cleanup → Remove duplicates;
Check the box for Data has header row;
Set the parameters:
- Make sure all the columns you want to check for duplicates are selected;
- Click Remove duplicates.

The tool checks for matching values across all selected columns by row to identify duplicate records.

Example of Use

Open our employee data table.

Removing duplicate records by Employee ID and Name:

Select the entire data range:
- Go to Data → Data cleanup → Remove duplicates;
- Click Remove duplicates.

The duplicate rows for employees with Employee ID2 and ID2 in rows 3 and 6 are removed, as they contained duplicate records in all columns.

Why Rows 2 and 4 Were Not Removed

Rows 2 and 4 contain unique data combinations, despite having the same values in the Name, Department, Salary columns. While the values in row 2 match those in row 4, the Employee ID is different. Since they do not match completely, they were not removed as duplicates.

Все було зрозуміло?

Дякуємо за ваш відгук!

Секція 4. Розділ 8

some-alt