Google Spreadsheets Tutorial

Conditional Formatting and Color Scale

Conditional formatting allows you to highlight cells with a specific color if their value meets a given condition. This helps visually emphasize important data and makes it easier to analyze information.

Applying Conditional Formatting with Color Scale

Conditional formatting with a color scale allows you to visualize data using a color gradient, where the value of cells is displayed according to a predefined color range. This helps quickly assess data distribution and identify trends.

Var allt tydligt?

Tack för dina kommentarer!

Avsnitt 4. Kapitel 5

Fråga AI

Fråga vad du vill eller prova någon av de föreslagna frågorna för att starta vårt samtal

some-alt

Google Spreadsheets Tutorial

0%

1. Introduction to Google Sheets

Learn how to create, rename, copy, delete, move, and download spreadsheets in Google Sheets. Acquire basic skills for organizing and managing data in a cloud-based environment.

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

Master the basics of editing and formatting data in Google Sheets. Learn how to adjust fonts, borders, colors, merge cells, and resize rows and columns to create clean and professional-looking tables.

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

Enhance your cell formatting skills: learn how to split text into columns, add hyperlinks, images, notes, and forms. Explore creating interactive and dynamic spreadsheets.

Splitting Text to Columns

Trimming Whitespaces

Inserting Internal and External Hyperlinks

Autocompleting Cells

Creating Checkboxes

Creating Drawings

Challenge: Mastering Event Planning Challenge

Challenge: Your Event, Your Plan

4. Sorting, Filtering and Cleaning Data

Develop skills to sort, filter, and clean data efficiently. Learn to use search and replace, conditional formatting, remove duplicates, and create named ranges to analyze large datasets.

Find and Replace

Searching Filter and Filter by Condition

Custom Filter Views

Conditional Formatting and Color Scale

Removing Duplicates

Challenge: Library Book List Management

5. Creating Charts

Discover how to build charts and graphs to visualize data. Learn to customize line, column, pie, and area charts for clear and insightful reporting.

Basic Chart Settings

Chart Style and Chart and Axis Titles

Legend, Gridlines and Ticks

Horizontal and Vertical Axis Customization

Columns and Stacked Columns

Challenge: Data Visualization Sprint Sales Insights

6. Basic Functions

Understand the core functions in Google Sheets for working with numbers, text, and dates. Learn to apply arithmetic, statistical, text functions, and date-time functions for automated calculations and data analysis.

Basic Calculations

Arithmetic Functions

Statistical Functions

Rounding Functions

Working with Numbers and Integers

Working with Roots and Powers

Random Number Generation

Working with Dates and Time

Challenge: Sales Visualization Trends and Analytics

7. Logical Functions

Explore logical functions for conditional data analysis. Learn how to use AND, OR, IF, and conditional formulas like SUMIFS, COUNTIFS, and AVERAGEIFS to create flexible calculations.

AND and OR Functions

IF and Nested IF Functions

SUMIFS, COUNTIFS and AVERAGEIFS

Challenge: Employee Performance and Payroll Analysis with Excel Functions

8. Collaboration and Security

Discover how to manage collaboration and secure data. Learn to set access permissions, create notification rules, protect sheets and ranges, track version history, and recover data.

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