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