Google Spreadsheets

Course Content

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

Copying and Deleting Columns and Rows

Copying Columns and Rows

Copying columns and rows allows you to duplicate data without changing its original placement.

Copying via Context Menu

Data can be copied using the Copy option in the context menu.

Right-click on the header of the column or row you want to copy;
Select Copy in the context menu;
Go to the new location where you want to insert the column or row;
Right-click on the header of the new location and select Paste.

Copying through Menu

Data can also be copied via the Copy command in the main menu.

Select the column or row you want to copy;
Go to the Edit menu → Copy;
Go to the new location where you want to insert the copied column or row;
Go to the Edit menu → Paste.

Copying with Keyboard Shortcuts

Keyboard shortcuts allow you to quickly copy data without using the menu.

Select the column or row you want to copy;
Press Ctrl + C (Windows) or ⌘ + C (Mac) to copy;
Go to the new location where you want to insert the copied column or row;
Press Ctrl + V (Windows) or ⌘ + V (Mac) to paste.

Deleting Columns and Rows

Deleting columns and rows helps to clean up the sheet from unnecessary data.

Both methods work for any number of rows and columns.

Deleting via Context Menu

Data can be deleted by selecting the Delete option in the context menu.

Select the column or row you want to delete by clicking its header;
Right-click on the selected header;
Select Delete column or Delete row in the context menu.

Deleting through Menu

Data can also be deleted using the Delete command in the main menu.

Select the column or row you want to delete by clicking its header;
Go to the Edit menu → Delete;
Choose the deletion method:
- Values – deletes only the values;
- Column or Row – deletes the entire column or row.

Everything was clear?

Thanks for your feedback!

Section 2. Chapter 10

some-alt