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

Making Sense of Data
Google via Independent
Introduction to Spreadsheets and Models
University of Pennsylvania via Coursera
Comptabilité de gestion et pratique du tableur
Université Montpellier 2 via France Université Numerique
The Power of Data in Health and Social Care
University of Strathclyde via FutureLearn
Digital Media Analytics: Introduction
Purdue University via FutureLearn