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

Inserting Internal and External Hyperlinks

Adding Internal Links

Adding internal links allows you to link cells or ranges within the same document for easy navigation.

Select the cell where you want to insert the internal link;
Go to the Insert menu → Link or use the keyboard shortcut Ctrl + K (Windows) or Cmd + K (Mac);
In the window that opens, in the Link field, enter the address of the cell or range on another sheet using the format:
SheetName!CellReference, for example, Sheet2!A1.
If the sheet name contains spaces, use quotes: ’Internal Link Source’!A1;
In the Text field, enter the text that will be displayed in the cell (if needed);
Click Apply to add the link.
You can also select a cell or range by clicking Sheets and named ranges and then choosing the needed cells.

You can insert a link to cell A2 on the Inserting Internal Hyperlinks sheet so that when you click the text, it takes you directly to cell A2 on the Internal Link Source sheet.

Adding External Links

Adding external links allows you to create a link to resources outside the document, such as other documents or websites.

Select the cell where you want to insert the external link;
Go to the Insert menu → Link or use the keyboard shortcut Ctrl + K (Windows) or Cmd + K (Mac);
In the window that opens, in the Link field, enter the URL of the external site or document:
- To add a link to another website, enter the URL, for example, https://www.example.com;
- To add a link to another Google Document, use the name of your document (for example, Trimming Whitespaces from the last lesson) or the full link to the document, which looks like this: https://docs.google.com/document/d/your-document-id;
In the Text field, enter the text that will be displayed in the cell (if needed);
Click Apply to add the link.

When you click the link text, you will be able to visit the specified website or document located outside of the current spreadsheet.

Everything was clear?

Thanks for your feedback!

Section 3. Chapter 3

some-alt