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

Creating Google Sheets

Creating a new spreadsheet is the first action you need to master to start working in Google Sheets. There are several ways to create a document, and you can choose the one that is most convenient for you.

Creating Sheets via sheets.google.com/create

This method allows you to instantly create a new file through the address bar.

In the address bar, enter https://sheets.google.com/create.

Creating Sheets through the Google Apps Menu

A convenient option for those who already use other Google applications, allowing for quick switching between them.

Go to google.com or be in any standard Google applications;
In the top right corner of the screen, find the icon of 9 dots, which opens the Google Apps menu. Click on this icon;
In the opened menu, find and click on the Sheets icon;
In Google Sheets, click the Blank Spreadsheet button.

Creating Sheets via Google Drive

If you frequently work with files in Google Drive, this method will help you create a spreadsheet directly from your storage.

Go to Google Drive at drive.google.com;
In the top left corner of the screen, click the New button;
In the dropdown menu, select Google Sheets.

Generating a New Sheet Using an Existing Table

This is useful when you are already in a spreadsheet and want to create a new one without closing the current one.

In an open spreadsheet, go to the File menu;
In the dropdown menu, select New;
In the submenu, select Spreadsheet.

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

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

Секція 1. Розділ 2

some-alt