Master Google Sheets from the ground up in this comprehensive beginner tutorial. Learn to navigate the interface, create and share spreadsheets, and harness powerful features like formulas, functions, and data manipulation tools. Explore essential skills including AutoFill, VLOOKUP, Pivot Tables, and real-time collaboration. Gain hands-on experience with practical exercises and discover how to leverage Google Sheets for efficient data gathering, formatting, and interpretation. Perfect for anyone looking to enhance their spreadsheet skills and maximize productivity in this free, web-based alternative to Microsoft Excel.
Google Sheets Beginner Tutorial - 2023 Update
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
Taught by
Learnit Training
