Overview
This course is designed for experienced Excel users looking to transfer their skills to Google Sheets. By the end of the course, learners will be able to create conditional formatting, use privacy tools, collaborate in real-time, collect information through interactive sheets and forms, access real-time financial data, automate actions with Macros, and create visuals like charts and QR Codes. The teaching method includes comprehensive training through a series of tutorials. The intended audience is Excel users who want to expand their skills to Google Sheets.
Syllabus
Start
Introduction
Overview
Data Validation
Conditional Formatting
Named Ranges
Protected Sheets and Ranges
Filter Views
File Version History
Charts and Sparklines
Checkboxes
Forms and Responses
Importing HTML
Introduction to Queries
SQL and Google Query Overview
SQL Statements
Financial Data
Financial Data Dashboard
Introduction to Macros
Absolute vs Relative Macros
Formatting Macros
Sorting Macros
Apps Script Editor
Conclusion
Taught by
Learnit Training