false
OasisLMS
Login
Catalog
Google Sheets
Google Sheets - Student Guide
Google Sheets - Student Guide
Back to course
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
×
Please select your language
1
English