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

Basic Calculations

Select the cell where you want to see the result;
Type an equals sign (=) — this signals to the spreadsheet that you are starting to write a formula;
Enter the numbers, cell references, or ranges you want to use;
Specify the operation (addition, subtraction, multiplication, etc.) or function;
Press Enter to see the result.

Using Elements in Formulas

Numbers: You can directly enter numbers. For example, the formula =5+3 will return the result 8;
Cell References: Refer to values in other cells. The formula =A2+B2 adds the values in cells A2 and B2;
Ranges: You can specify ranges of cells to use in calculations, like SUM(A1:A3);
Dates: Formulas support working with dates, including adding, subtracting, and converting them. For example, the formula =TODAY() returns the current date, and =A1+7 adds 7 days to the date in cell A1;
Functions: Use built-in functions to perform calculations, process text, analyze data, or work with logic. For example:
- SUM(A1:A3) adds the values in the range;
- IF(A1>10, "Large", "Small") checks a condition and returns one of two values;
- YEAR(A1) extracts the year from the date in A1.

Automating Formula Updates

When you copy a formula to another cell:

Cell references in the formula automatically change to the corresponding new cells;
For example, if the formula =A2+B2 is in C2 and you drag it down, the formula in C3 will become =A3+B3.

Example Usage

Value (A)	Value (B)	Formula	Result	Explanation
4	6	`=2+4`	6	Example of adding numbers directly.
-5	3	`=A2-A3`	9	Subtracting the value in A3 from A2.
3	1	`=A2-B4`	3	Subtracting the value in B4 from A2.
		`=SUM(3, 6, 8)`	17	Sum of individual numbers.
		`=SUM(A2:B4)`	12	Sum of all values in the range A2:B4.
		`=SUM(A2:A4,B2:B3)`	11	Sum of values from ranges A2:A4 and B2:B3.
		`=SUM(A2,B2)`	10	Summing two cells: A2 and B2.
		`=SUM(A3,B3)`	-2	Summing two cells: A3 and B3.

Tudo estava claro?

Obrigado pelo seu feedback!

Seção 6. Capítulo 1

some-alt