Google Spreadsheets

Conteúdo do Curso

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

Opening Google Sheets

Accessing a Document from an Open Google Sheets Tab

A quick way to open a recently used file without searching elsewhere.

Click on the green Google Sheets icon;
Find the desired document in the list of recent files;
Click on the document to open it.

Accessing a Document via the File Menu

Use this method to access all saved documents, including those recently used or uploaded.

Open Google Sheets at sheets.google.com or in the Google Sheets app;
In the top menu, click File → Open.
In the dialog box that appears, you will see several tabs:
- Recent - contains a list of recently opened documents, convenient for quick access to recently used files;
- My Drive - shows all documents saved on your Google Drive. Here you can find files organized in folders and subdirectories;
- Shared with me - contains files and documents that have been shared with you by other users. You can open files available to you through sharing;
- Starred - displays files and documents you have marked as favorites. This tab helps you quickly find important documents;
- Computers - allows you to access files synced from your computers through Google Drive. Here you can find documents available on devices connected to your account;
- Upload - allows you to upload files from your computer to Google Drive. You can select a file to upload and add it to your Google Drive or open it directly in Google Sheets.

Tudo estava claro?

Obrigado pelo seu feedback!

Seção 1. Capítulo 3

some-alt