Google Spreadsheets

Kursinhalt

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 Formatting Text 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

Text Functions

In this chapter we will explore Text Functions. Functions for working with text allow you to manipulate strings of data: measuring the length of text, replacing parts of a string, combining multiple strings, and splitting text by a given delimiter. In this section, we will look at four key functions: LEN, SUBSTITUTE, CONCAT, and SPLIT.

Calculating Length

The LEN function returns the number of characters in a string, including spaces. This function is useful for analyzing the length of textual data, such as when checking whether entered text meets a character limit.

Substituting Text

The SUBSTITUTE function replaces all or some occurrences of a part of a string with another text. It is useful for correcting typos or replacing data, such as replacing outdated values with current ones.

Concatenating Text

The CONCATENATE function combines two texts or strings into one. This is useful for joining data from different cells, such as last names and first names, or other pieces of information.

Splitting Text

The SPLIT function divides a string into multiple parts using a specified delimiter. This is useful for breaking down data, such as a list of words, dates, or complete sentences.

Task: Working with LEN, SUBSTITUTE, CONCATENATE, and SPLIT Functions

You have the following spreadsheet formulas:

A	Formula	Expected Result
OpenAI GPT	`=LEN(A1)`	?
banana	`=SUBSTITUTE(A2, "a", "o", 2)`	?
Code	`=CONCATENATE(A3, " ", "Master")`	?
Apple;Orange;Banana	`=SPLIT(A4, ";")`	?

War alles klar?

Danke für Ihr Feedback!

Abschnitt 6. Kapitel 8

some-alt