Google Sheets-Google Sheets

Google Sheets - Student Guide

Pdf Summary

This document is a CustomGuide (2019) training manual for Google Sheets that walks learners through core spreadsheet skills, from setup to collaboration. It begins with instructions for preparing course practice files: adjusting Google Drive settings to automatically convert uploaded Excel files to Google Sheets format, creating a dedicated practice folder, uploading module folders, and noting that unnecessary system files (e.g., desktop.ini) may appear.<br /><br />The manual then covers Sheets fundamentals, including creating new spreadsheets (blank or from templates), naming files, understanding automatic saving, opening files from Google Drive or within Sheets, and navigating workbooks. Navigation topics include selecting cells and moving around with mouse, scrollbars, and keyboard shortcuts, as well as switching between sheets.<br /><br />A large section focuses on editing spreadsheets: selecting cells, rows, columns, and ranges; entering, replacing, editing, and clearing cell contents; and using cut/copy/paste with keyboard shortcuts. It introduces undo/redo/repeat and explains Paste Special options such as pasting formulas only, values only, formatting, transposing data, and transferring validation or conditional formatting.<br /><br />Formatting guidance includes changing fonts and text effects, alignment, wrapping and merging cells, adding borders and fill colors, applying currency/date/custom number formats, adjusting row height and column width, freezing panes, and using the paint format tool. Conditional formatting is explained with common rule types and how to remove rules.<br /><br />Formula and function basics include building formulas with operators, using common functions (SUM, AVERAGE, MIN, MAX, COUNT and related variants), autofill for series and copying formulas, understanding relative vs. absolute references, and naming ranges for clearer formulas and navigation.<br /><br />Data and sheet management sections explain inserting/renaming/deleting/duplicating/moving/hiding sheets, sorting (single or multi-column), filtering (including conditional filters), data validation rules, and protecting sheets or ranges with permissions.<br /><br />Finally, it covers inserting objects (charts, images, links), sharing and permission settings, real-time collaboration with comments, version history (view/restore/name versions), uploading/converting/downloading/emailing spreadsheets, and extending functionality with add-ons.

Keywords

Google Sheets training manual

Google Drive Excel conversion settings

Spreadsheet navigation keyboard shortcuts

Cell editing cut copy paste

Paste Special options

Conditional formatting rules

Formulas and functions SUM AVERAGE

Relative and absolute cell references

Sorting filtering data validation

Sharing permissions collaboration version history