Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Skillshare

Google Sheets in 2021

via Skillshare

This course may be unavailable.

Overview

In this course, you will learn how both the basics of using spreadsheets with Google Sheets and more advanced features such as using functions to create dynamic spreadsheets that reference data from across multiple sources, and generate visual representations of what you have with pie charts and trend lines.

By the time you're done with this course, you'll have full confidence in most things that require you to use Google Sheets. In situations that require something beyond your current skill level, you will have the tools needed to acquire the  knowledge necessary without feeling overwhelmed.

Syllabus

  • Setup
  • Toolbar and Application Menu
  • Basic Vocabulary
  • Entering Data Into Cells
  • Selecting Multiple Cells
  • Selecting Rows and Columns
  • Adding Rows and Columns
  • Resizing Columns and Rows
  • Moving and Manipulating
  • Deleting and Clearing
  • Freezing Rows and Columns
  • Grouping
  • Grouping The other Way
  • Hiding
  • Merging Cells
  • Setup Part 2
  • Protecting Ranges
  • Range Select Syntax
  • Selecting Rows and Columns
  • Permissions and Protection
  • Special Paste and Two Sheets
  • Filling The 2nd Sheet
  • Renaming Sheets
  • Copying Duplicate Sheets
  • Formatting Numbeers
  • Custom Date and Time Formats
  • Custom Currencies
  • Right To Left Readings
  • Spreadsheet Settings
  • Inserting Images
  • Alt Text
  • Images Over Cells
  • Basic Math Functions
  • Refining Cells In Functions
  • Nesting Functions
  • Function Bar Sizing
  • Averages
  • Using Means or Medians
  • If Statements
  • Adding Ifs to Profiless
  • Comparing apples to Apples
  • Using The Function Button
  • Copy and Paste
  • Comparing Strings (intro)
  • NOT (the inverter)
  • Sorting
  • Filtering By Values
  • Saving Filter Views
  • Resorting Things Out
  • Dropdown List
  • Conditional Format
  • 7
  • Deleting Conditional Formats
  • Split Columns
  • Removing Duplicates
  • Trimming White Space
  • Checkboxes
  • Setup
  • Referencing Across Sheets
  • Inserting Objects
  • Styles
  • Titles
  • Gridlines
  • Column Colors
  • Loading Or P&L
  • Adding A Trendline
  • Reversing The Axis
  • MinMax and Gridlines
  • Adding Horizontal Axis
  • Publishing Charts

Taught by

Flow Speeches

Reviews

Start your review of Google Sheets in 2021

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.