This course aims to teach learners how to gather, format, and interpret data in a spreadsheet using Google Sheets. The learning outcomes include navigating the app, creating and sharing spreadsheets, calculating data with functions and formulas, filtering and sorting data, and utilizing features like Pivot Tables, AutoFill, VLOOKUP, Macros, and real-time collaboration. The course employs a hands-on approach with practical exercises and demonstrations. The intended audience for this course is anyone interested in enhancing their skills in spreadsheet management and analysis.
Overview
Syllabus
Start
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
