動画検索
関連広告
検索結果
Start
Introduction
Start Page
Interface
Navigating and Selecting Cells
Entering and Editing Data
Explore
Saving
Introduction to Google Drive
Building Basic Formulas
Using Simple Functions
Relative vs Absolute Reference
Inserting Rows and Columns
Moving, Copying, and Pasting Data
Cell Formatting - Align, Text Rotation, Text Wrapping
Formatting Worksheet Data and Using Cell Design
Using Sheets Templates
Inserting, Deleting, Renaming, Moving, and Copying Worksheets
Currency Formatting
Hiding Rows and Columns
Spell Check
Printing
Download Options
Publishing Sheets to the Web
Conclusion
how to create a new spreadsheet using drive.google.com and sheets.new
how to convert .csv and .xlsx files to Google Sheets files
how to create sheets inside of a spreadsheet - how to color, organize, and navigate through them
how to add columns in Google Sheets, how to freeze columns and rows
using Google Sheets as database
format data and cells
most useful shortcuts
smart spreadsheet features: pasting values, format, transposed, sequences, using Math operators (* / + -)
formulas in Google Sheets: SUM, AVERAGE, COUNT
using comments and notes to collaborate right in the spreadsheet
Start
Introduction
Single and Multi-Level Sorting
Filtering Records in a List
Search Filter and Filter by Condition
Custom Filter Views
Inserting Data Charts
Formatting and Editing Chart Elements
Adding and Removing Data from Charts
Inserting Sparklines
Alternating Colored Rows
Alternating Colors Button
Creating a Pivot Table
Creating a Pivot Chart
Filtering Within Pivot Tables Using Slicers
Using the IF Function
Introduction to Nesting Functions
VLOOKUP Function
Using the IFERROR Function
Creating and Applying Names in a Worksheet
Summary-Based Functions SUMIF(S) and AVERAGEIF
Text Functions Left, Right, Mid, Concatenate, and Split Text-To-Columns
Sharing and Managing Permissions
Macros
Conclusion
Introduction
Official Google Sheets training
How to get Google Sheets
Start page
Cells, columns, & rows
Zoom level
Format numbers
Adjust column widths & row heights
Alternating colors
Conditional formatting
Insert columns & rows
Freeze columns & rows
Explore
Subtraction
Multiplication
Functions
SUM function
Named ranges
VLOOKUP function
Sort & filter
Filter views
Pivot tables
Create a new form
Version history
Wrap up
Introduction to Google Sheets
Opening and navigating your Google Sheets
Creating a new blank spreadsheet in Google Sheets
Google Sheet layout
Rows, columns, ranges, and sheets in Google Sheets
Adding some data to your spreadsheet
Creating and formatting column widths and row height
How to format your sheet in Google Sheets
Adding borders and colors
Formatting for currency and decimal places in Google Sheets
Creating basic formulas in Google Sheets
Freeze rows or columns in Google Sheets
Basic Google Sheet functions
How to add a chart in Google Sheets
How to print your spreadsheet in Google Sheets
Download your spreadsheet as a PDF or Excel file
Sharing your spreadsheet with other
Start
Accessing Google Sheets
Keyboard Shortcuts
Templates
Opening and Saving Sheets
Showing and Using the Formula Bar and Gridlines
Using Autofill to Create Redundant Data
Formulas with Absolute References
Inserting Rows and Columns
Cell Formatting
Freeze Panes and Full Screen View
Sharing and Emailing Sheets
Introduction
Multi-Column Sort
Conditional Filters and Filtered Views
Editing Charts
Sparklines
Pivot Tables
IF Functions
VLOOKUP
SUMIFS
IFERROR
CONCATENATE
Real-Time Authoring
Conclusion