Google Sheets-Google Sheets

Google Sheets - Course Outline

Pdf Summary

This course outline covers foundational through intermediate skills for using Google Sheets as part of G Suite. It begins with spreadsheet fundamentals: creating new files (including from templates), naming, saving/closing, opening from Drive or Sheets, and navigating within cells, sheets, and pages. It also introduces core file-management tasks such as renaming, starring, copying, moving, deleting, printing, and finding help using command search and help topics.<br /><br />Next, the course focuses on editing spreadsheets. Learners practice selecting cells, rows, columns, and ranges; entering, replacing, editing, and clearing data; and using cut/copy/paste, undo/redo, repeat, and Paste Special (formulas, values, and transposing data). It also covers inserting, moving, deleting, hiding/unhiding rows, columns, and cells, plus find/replace and spell check.<br /><br />Formatting is covered in depth, including text formatting (fonts, sizes, effects), alignment and wrapping, merging/unmerging cells, borders and fill colors, number/date formatting (currency, custom formats), and adjusting row height/column width manually or automatically. Additional topics include freezing rows/columns, copying formatting, and applying/removing conditional formatting rules.<br /><br />The formulas and functions section teaches formula basics, autofill, common functions (SUM, AVERAGE, MIN, MAX, COUNT and related functions), inserting functions with built-in help, absolute vs. relative references, and naming cell ranges for easier formula use and navigation.<br /><br />Data and sheet management includes inserting/renaming/deleting sheets, duplicating/moving/hiding/unhiding sheets, sorting by single or multiple columns, filtering (including advanced filters), clearing filters, data validation, and protecting spreadsheets.<br /><br />Finally, learners insert and customize objects (charts, images, links) and master sharing and collaboration features: uploading/converting files, downloading/emailing, sharing permissions, commenting workflows, version history (view/restore/named versions), and installing/accessing add-ons.

Keywords

Google Sheets

G Suite

spreadsheet basics

file management

cell editing

formatting

formulas and functions

sorting and filtering

data validation and protection

sharing and collaboration