This handy reference and cheat sheet contains tips, examples, and easy-to-read annotated screenshots of Google Sheets, the free online spreadsheet program and Microsoft Excel alternative. Topics include:
Overview of Google Sheets on the Web, including annotated screenshots of the main page and formatting toolbar
Sheets basics: Creating, renaming, saving, and copying spreadsheets
How to edit while offline
How to add, edit, and hide data
How to import and export .txt, .csv, .pdf, and .xlsx files
Examples of basic formulas, functions, auto-fill
How to perform simple math and calculate averages
Sorting and filtering data
How to create a chart or graph
Keyboard shortcuts for Chromebooks, Windows, and OS X
