Google Sheets

Course Topics at high-level

An Introduction to Google Sheets

·         Create a new Google Sheet

·         Name a Spreadsheet

·         Upload an Existing Excel Spreadsheet

·         Edit Cells

·         Use Auto-fill

·         Format Cells

·         Format Text and Numbers

·         Basic Formulas and Functions

·         Use the Sum function

·         Create and Copy Formula using Auto-fill

·         Sort and Filter data

·         Finding your way around Google Sheets

·         Opening Files

·         Move data from Excel Files to Google Sheets and vice-versa

·         What about saving files?

·         File Management

·         Adding/Deleting Worksheets

·         Renaming Worksheets

Basic Formatting

·         Formatting Numbers

·         Dealing with Dates

·         Changing the Typeface

·         Adding more fonts

·         Adding Colors

·         Format Painter

Formulas in Google Sheets

·         Basic Arithmetic

·         Operator Preference

·         Absolute References

·         Using Functions

·         Calculating between Worksheets

Printing Google Sheets

·         Selecting a print area

·         Fitting everything onto a page

·         Creating a PDF

·         Printing all sheets

Sharing a Google Sheet

·         Choosing people to share with

·         Restricting Editing

·         Preventing others from downloaded and printing

Google Sheets Content

·         Introduction

·         Menu Options - File

·         Menu Options - Edit

·         Menu Options - View

·         Menu Options - Insert

·         Menu Options - Format

·         Menu Options - Data and more

·         Entering Data and Filtering

·         Functions - Numeric Function

·         Functions - Text Function

·         Functions - Data Functions

·         Charts and Conditional Formatting

·         Pivot Tables

·         Saving, Sharing, Collaboration