This course teaches learners how to navigate Google Sheets, create and share spreadsheets, calculate data with functions and formulas, filter and sort data, and utilize features like Pivot Tables, AutoFill, VLOOKUP, Macros, and real-time collaboration. The course covers basic formulas, cell formatting, data manipulation, chart creation, named ranges, IF functions, and more. The intended audience includes anyone interested in gathering, formatting, and interpreting data in a spreadsheet. The teaching method involves a hands-on approach with practical exercises and demonstrations.
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
