Master the fundamentals of Google's free, web-based spreadsheet application in this comprehensive beginner tutorial. Learn to navigate the interface, create and share spreadsheets, and perform basic data operations. Discover how to calculate data using functions and formulas, filter and sort information, and utilize popular features like Pivot Tables, AutoFill, VLOOKUP, and Macros. Gain hands-on experience with essential skills such as formatting cells, working with templates, managing worksheets, and publishing your work. Perfect for anyone looking to gather, format, and interpret data in a spreadsheet environment, this tutorial covers everything from simple calculations to advanced features, preparing you to effectively use Google Sheets for various data management tasks.
Overview
Syllabus
Start
Introduction
Start Page
Interface
Search the Menus
Navigating and Selecting Cells
Entering and Editing Data
Explore
Performing Simple Calculations
Saving
Introduction to Google Drive
Building Basic Formulas
Using Simple Functions
Copying Formulas and Functions with AutoFill
Relative vs Absolute Reference
Inserting Rows and Columns
Moving, Copying, and Pasting Data
Using AutoFill to Complete a Series of Values
Cell Formatting - Align, Text Rotation, Text Wrapping
Formatting Worksheet Data and Using Cell Design
Using Sheets Templates
Inserting, Deleting, Renaming, Moving, and Copying Worksheets
Freeze Panes
Currency Formatting
Hiding Rows and Columns
Spell Check
Using the Full-Screen View
Printing
Download Options
Publishing Sheets to the Web
Sending Sheets as Emails
Conclusion
Taught by
Learnit Training
