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

Arithmetic Functions

Addition is an operation that allows you to find the total sum of two or more numbers. You can use the addition operator + or the SUM function.

Syntax and Examples

value1 + value2

SUM(value1, value2,...value2, ...)

value1 - The first value or range to be considered in the summation.
- value2, ... - OPTIONAL - Additional values or ranges to include in the summation.

Value (A)		Formula	Result	Comment
5		A2 + A3 + A4	30	Returns the sum of values in A2, A3, and A4 using the + operator.
10		SUM(A2:A3)	15	Returns the sum of values in the range A2:A3.
15		SUM(A2:A4)	30	Returns the sum of values in the range A2:A4.

Subtracting

Subtraction is an operation that allows you to find the difference between two numbers. Simply use the subtraction operator -.

Syntax and Examples

value1 - value2

Value (A)		Formula	Result	Comment
5		A2 - A3	-5	Returns the difference between values in A2 and A3.
10		A3 - A4 - A2	-10	Returns the difference of values in A3, A4, and A2.
15		A4 - A2	10	Returns the difference between values in A4 and A2.

Using Multiplication and PRODUCT Function

Multiplication is an operation that allows you to find the product of two or more numbers. You can use the multiplication operator * or the PRODUCT function.

Syntax and Examples

value1 * value2

PRODUCT(value1, value2,...value2, ...)

value1 - The first value or range to be considered in the product calculation.
value2, ... - OPTIONAL - Additional values or ranges to include in the product calculation.

Value (F)		Formula	Result	Comment
-3		F2 * F3	15	Returns the product of F2 (-5) and F3 (-3), which equals 15.
-5		F3 * F4	-10	Returns the product of F3 (-2) and F4 (5), which equals -10.
2		F2 * F3 * F4	30	Returns the product of F2 (-5), F3 (-3), and F4 (2), which equals 30.

Dividing

Division is an operation that allows you to find the quotient of two numbers. Use the division operator /.

Syntax and Examples

value1 / value2

Value (F)		Formula	Result	Comment
-3		F2 / F3	0.6	Returns the quotient of F2 (-5) and F3 (-10), which equals 0.5.
-5		F3 / F4	-2.5	Returns the quotient of F3 (-10) and F4 (5), which equals -2.
2		F2 / F3 / F4	0.3	Returns the quotient of F2 (-5), F3 (-10), and F4 (5), which equals 0.2.

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

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

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

some-alt