Discover how to leverage your Excel expertise in Google Sheets with this comprehensive tutorial designed for experienced Excel users. Learn to create formulas, apply functions, and explore advanced features unique to Google's cloud-based spreadsheet application. Master conditional formatting, privacy tools, real-time collaboration, interactive sheets, and forms for data collection. Dive into retrieving real-time financial data, automating tasks with Macros, and creating visuals like charts, sparklines, and QR codes. Through 2+ hours of in-depth training, gain the skills to efficiently transition your spreadsheet proficiency to Google Sheets, covering topics such as data validation, named ranges, protected sheets, filter views, version history, SQL queries, and the Apps Script Editor.
Overview
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
