YoVDO

Google Sheets in 2021

Offered By: Skillshare

Tags

Google Sheets Courses Data Visualization Courses Data Filtering Courses Data Protection Courses Data Formatting Courses Data Entry Courses

Course Description

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

Related Courses

Cryptography II
Stanford University via Coursera
Microsoft Enterprise Mobility Suite
Microsoft via edX
Social Media - What No One has Told You about Privacy
openHPI
Windows 10 Features for a Mobile Workforce: Identity Management and Data Access
Microsoft via edX
Health Professional Teaching Skills – Level 3 - Professionalism
University of Toronto via edX