Google LLC Google Sheets E-Learning

Google Sheets: Getting Started

Course: 17 Minutes

Accessing Google Sheets
Using the applicatio
Customizing your spreadsheet view
Customizing the application's display
Adding features to the application

Google Sheets: Creating, Opening & Saving Documents

Course: 48 Minutes

Creating & opening documents
Using templates
Importing a document
Saving your document
Organizing your sheets
Using the undo & redo tools
Protecting your document
Recovering a previous version of your document
Exporting your document in PDF format
Downloading a document to your computer
Printing your document

Google Sheets: Inserting & Manipulating Data

Course: 1 Hour, 7 Minutes

Selecting a cell
Inserting data into your cells
Deleting data from your spreadsheet
Creating automatic data lists
Hiding columns & rows
Moving data
Moving data from one sheet to another
Copying & pasting values
Transposing a data range
Adding headers
Using the spell-check
Freezing & unfreezing columns & rows
Inserting drop-down menus
Inserting menus with predefined options
Validating your data
Avoiding duplicate values

Google Sheets: Formatting Data

Course: 46 Minutes

Changing your cell's data type
Formatting data
Applying colors
Aligning your text
Inserting borders
Moving your formatted styles
Resizing your columns & rows
Inserting rows & columns into your spreadsheet
Using conditional formatting
Using advanced conditional formatting

Google Sheets: Illustrating Documents

Course: 22 Minutes

Inserting an image
Inserting a drawing
Editing your drawing
Inserting a hyperlink

Google Sheets: Finding, Sorting & Filtering Data

Course: 28 Minutes

Using the Find & Replace tool
Using the Find & Replace tools in a formula
Sorting the data in your spreadsheet
Filtering the data in your spreadsheet
Using the advanced filtering tools
Using filtered views

Google Sheets: Referencing Data

Course: 36 Minutes

Referencing cells
Choosing between absolute & relative cell references
Defining a new data range
Using data from several sheets
Calculating with constant values
Using cell references indirectly

Google Sheets: Basic Formulas

Course: 55 Minutes

Selecting & using formulas
Performing simple calculations
Repeating your formula within your spreadsheet
Creating automated cumulative totals
Changing number units
Factorizing the results of a division
Counting cells in a range
Ranking a value
Rounding a number
Using replacement formulas
Generating random numbers

Google Sheets: Charts & Graphs

Course: 1 Hour, 3 Minutes

Creating a quick chart
Inserting a chart
Customizing your chart
Customizing your chart's axes
Creating a pie chart
Creating a scatter chart
Creating a bubble chart
Creating a radar chart
Combining two types of charts
Placing data on a map
Creating a chart using symbols
Using Sparklines
Publishing your chart

Google Sheets: Pivot Tables

Course: 24 Minutes

Analyzing your data with a pivot table
Developing your pivot table
Sorting & filtering a pivot table
Adding calculated fields to your pivot table
Copying & exporting your pivot table

Google Sheets: Conditional Formulas

Course: 53 Minutes

Using conditional formulas
Inserting a conditional sum formula
Creating multiple conditions
Performing complex conditional formulas
Using IF & OR in conditional formulas
Using reference positions in conditional formulas
Keeping your table up to date with conditional formulas
Viewing data in different languages
Creating a multi-language version of your worksheet

Google Sheets: Solving Complex Problems with Formulas

Course: 33 Minutes

Calculating the interest on a loan
Comparing loans
Creating automatic reports
Finding duplicate values in your spreadsheet
Finding duplicates in your document
Managing duplicate entries

Google Sheets: Extracting Information with Formulas

Course: 1 Hour, 2 Minutes

Getting to know your data
Retrieving date information
Displaying information on your data
Retrieving information on your text
Finding the largest & smallest values in a list
Separating your data
Combining data
Comparing two lists
Inserting data automatically
Finding data in a database
Performing calculations using your database
Finding a value in a double entry table
Performing a search across two tables
Identifying errors in formulas

Google Sheets: Sharing & Collaboration Tools

Course: 25 Minutes

Adding a comment or note to your document
Sending your document via email
Publishing your document on the web
Adjusting the share settings for your document
Working with another user on the same document
Sending an email to your collaborators
Adjusting the discussion notification settings

Google Sheets: Creating, Opening & Saving Documents

Course: 53 Minutes

Creating & opening documents
Using templates
Importing a document
Saving your document
Organizing your sheets
Using the undo & redo tools
Protecting your document
Recovering a previous version of your document
Exporting your document in PDF format
Downloading a document to your computer
Printing your document
Creating custom templates

Google Sheets: Inserting & Manipulating Data

Course: 1 Hour, 26 Minutes

Selecting a cell
Inserting data into your cells
Deleting data from your spreadsheet
Creating automatic data lists
Hiding columns & rows
Moving data
Moving data from one sheet to another
Copying & pasting values
Transposing a data range
Adding headers & footers
Using the spell-check
Freezing & unfreezing columns & rows
Working with data via the Explore tool
Grouping data
Inserting drop-down menus
Inserting menus with predefined options
Validating your data
Avoiding duplicate values
Automating tasks with the Macro tool

Google Sheets: Basic Formulas

Course: 1 Hour

Selecting & using formulas
Performing simple calculations
Repeating your formula within your spreadsheet
Creating automated cumulative totals
Changing number units
Factorizing the results of a division
Counting cells in a range
Ranking a value
Rounding a number
Using replacement formulas
Generating random numbers
Inserting checkboxes

Google Sheets: Extracting Information with Formulas

Course: 1 Hour, 5 Minutes

Getting to know your data
Retrieving date information
Displaying information on your data
Retrieving information on your text
Finding the largest & smallest values in a list
Separating your data
Combining data
Comparing two lists
Inserting data automatically
Finding data in a database
Performing calculations using your database
Finding a value in a double entry table
Performing a search across two tables
Identifying errors in formulas
Customizing the formula options in your spreadsheet