Google Sheets

<< Chapter Activities
 
 

Course Description

Google Sheets is a cloud-based application that empowers you to create sophisticated spreadsheets like Microsoft Excel. Whether you are working at your desk or from your smartphone or tablet on-the-go—Google Sheets helps you organize, analyze, and share your most important data. In this course for Sheets users, you’ll learn how to make your own supercharged spreadsheets. First, you’ll learn how to input and format your data. Next, you’ll learn how formulas, functions and a few exclusive Google Sheets features can accelerate your data analysis. Finally, you’ll get tips for sharing your spreadsheets and collaborating on them with your team.   


Course Objectives

  • Create a spreadsheet
  • Format cells, rows, columns, and entire worksheets so they fit and match your data
  • Enter data into a spreadsheet
  • Use formulas and functions for calculations
  • Create formulas and functions
  • Calculate data
  • Create charts for your data
  • Create forms
  • Create pivot tables and pivot charts.
  • Work with templates
  • And much more

Course Requirements

  • Gmail Account and able to use Internet on Mobile or Laptop.

Course Details

  • Introduction to Google Sheets
  • Navigating Google Sheets
  • Getting Started in Google Sheets
  • Spreadsheets and Workbooks
  • Entering Information into Google Sheets
  • Introduction to Working with Cells, Rows, and Columns
  • Formatting Data and Cells
  • Formatting Cells, Rows, and Columns
  • Introduction to Formulas and Calculations
  • Working with Formulas and Functions
  • Working with Data Using Pivot tables and Data Validation
  • Inserting Images into a Spreadsheet
  • Inserting Additional Elements into Google Sheets
  • Publishing and Printing Spreadsheets in Google Sheets
  • Sharing and Collaborating on Spreadsheets in Google Sheets
  • Other Helpful Tools in Google Sheets

Course Conduction Mode

  • Online Zoom Platform