Dive into a comprehensive 2+ hour tutorial on Google Sheets, covering everything from basic navigation to advanced features like Pivot Tables and Google Apps Scripts. Learn to create, format, and share spreadsheets, calculate data using functions and formulas, and master essential skills such as filtering, sorting, and data visualization. Explore popular features including AutoFill, VLOOKUP, Macros, and real-time collaboration. Gain hands-on experience with practical exercises and discover how to leverage Google Sheets for efficient data management and analysis. Perfect for beginners and intermediate users looking to enhance their spreadsheet skills in Google's free, web-based application.
Overview
Syllabus
Start
Introduction
Accessing Google Sheets
Navigating in Cells and Menus
Keyboard Shortcuts
Editing Cell Contents
Templates
Using Explore
Opening and Saving Sheets
Using Google Drive with Google Sheets
Showing and Using the Formula Bar and Gridlines
Basic Formulas
Using Autofill to Copy Formulas
Using Autofill to Create Redundant Data
Simple Formulas
Formulas with Absolute References
Cut, Copy, and Paste
Inserting Rows and Columns
Wrapping Text, Rotating, and Aligning Cells
Cell Formatting
Hiding Rows and Columns
Freeze Panes and Full Screen View
Spell Check and Printing
Sharing and Emailing Sheets
Publishing to Web
Conclusion
Introduction
List, Format, and Sort
Multi-Column Sort
Filters
Conditional Filters and Filtered Views
Creating Charts
Editing Charts
Removing and Deleting Chart Data
Sparklines
Formatting with Alternating Row Colors
Pivot Tables
Pivot Charts
Named Ranges
IF Functions
Nested Functions
VLOOKUP
SUMIF and AVERAGEIF
SUMIFS
AVERAGEIFS
IFERROR
LEFT and RIGHT
CONCATENATE
Sharing Files
Real-Time Authoring
Google Sheets Add-Ons
Introduction to Google Apps Scripts
Conclusion
Taught by
Learnit Training
