Google Spreadsheets Tutorial

Learn how to create and customize spreadsheets in Google Sheets, work with formulas and functions, including logical operations, format data, and sort…もっと表示

90 人の学習者

すでに登録済み

初心者向けコース

8 モジュール

インタラクティブな環境

69 章

AIアシスタント

63 課題

共有可能な証明書

成果

コース内容

学習内容

Creating, renaming, and managing spreadsheets

Inserting hyperlinks, images, and notes

Applying arithmetic and statistical functions

Formatting cells, text, and borders effectively

Sorting, filtering, and cleaning data efficiently

Using logical functions for data analysis

Merging cells and adjusting row/column sizes

Building and customizing various chart types

Managing collaboration and securing data

コース内容

Learn how to create and customize spreadsheets in Google Sheets, work with formulas and functions, including logical operations, format data, and sort and filter information. Master data visu…

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

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

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

Challenge: Mastering Event Planning Challenge

Challenge: Your Event, Your Plan

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

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

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

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

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

Text Functions

Working with Dates and Time

Sort Function

Challenge: Sales Visualization Trends and Analytics

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

IFS Function

SUMIFS, COUNTIFS and AVERAGEIFS

Challenge: Employee Performance and Payroll Analysis with Excel Functions

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

あなたのテックスキルを強化！

最大55％オフで

What you'll get with our subscription:

500+ 人気コース修了証明書パーソナライズされた学習トラック40+ 実践的なプロジェクト

あなたのサブスクリプションには500以上のコースが含まれています：

オフィスパッケージ

このコースは、仕事や学習のためにGoogleの人気ツールの基本スキルを習得したい方を対象としています。Google ドキュメント、スライド、フォーム、ドライブの基本をカバーし、生産性を高めるための役立つヒントも紹介します。ドキュメントの作成、プレゼンテーションの操作、フォームを使ったデータ収集、Google ドライブでのファイルの安全な保存と共有方法を学びます。このコースは、これらのツールを迅速かつ効果的に習得し、日常のワークフローに役立てることができます。

test code

TEST SHORT VIDEO COURSE

TEST COURSE WITH ALL TYPES OF COLUMN CHAPTERS

test python course with 6 sections

Course without tasks for flow test

Course for E2E testing

Test mobile outline course

Super course

TEST PYTHON CASE STUDY

In the world of business, making decisions based on hard data rather than intuition can be the key to success. This course focuses on one crucial technique: analyzing A/B test data. The centerpiece of the course is a project where you'll conduct a detailed analysis of an A/B test. This project, which you can showcase in your CV, is hosted on Codefinity, allowing you to continually refine it and demonstrate your growing expertise.

オフィスパッケージ

test code

TEST SHORT VIDEO COURSE

TEST COURSE WITH ALL TYPES OF COLUMN CHAPTERS

test python course with 6 sections

Course without tasks for flow test

Course for E2E testing

Test mobile outline course

Super course

TEST PYTHON CASE STUDY

なぜ人々はCodefinityを選ぶのか

Web Developer

Kwizera Mugisha

The teaching methodology at Codefinity is excellent, and I particularly appreciate how it has prepared me to handle real-world coding problems. Currently, I am delving into Node.js and eagerly anticipate building full-stack projects that integrate all the knowledge I have gained.

Senior Business Analyst

Sherry Barnes-Fox

My first course was 4 hours, I did it in a few days, "nugget-style". The instructions are very clear and easy to understand. There is even a hint to help you get the answer. I love the learning style that is used, it engages me.

Accounts Payable Specialist

Bill Wagner

I have really liked the browser-based lessons that allow me to code within the lesson. The RUN button allows me to test the code I write before submitting for a grade.

IT Support Specialist

Daniel Chinea

I have gained a lot of practical and logical thinking skills, along with patience for myself and confidence in myself that I can learn programming. Years ago, I would have never thought that I could learn programming in any way, shape or form, and I was able to obtain these certifications and skills with Codefinity.

Technology Project Manager

Steve Bruening

The learning was progressive and made it easy to follow along and make progress. I could feel my skills increasing and building on each other as the course went along.

Project Manager

Stephanie Chan

As I went through the first course of the Python track, I liked the way the course was lay out (in easy and digestible modules) with little exercises at the end of each concept.