Главная
Study mode:
on
1
Start
2
Introduction
3
Overview
4
Data Validation
5
Conditional Formatting
6
Named Ranges
7
Protected Sheets and Ranges
8
Filter Views
9
File Version History
10
Charts and Sparklines
11
Checkboxes
12
Forms and Responses
13
Importing HTML
14
Introduction to Queries
15
SQL and Google Query Overview
16
SQL Statements
17
Financial Data
18
Financial Data Dashboard
19
Introduction to Macros
20
Absolute vs Relative Macros
21
Formatting Macros
22
Sorting Macros
23
Apps Script Editor
24
Conclusion
Description:
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.

Google Sheets for Excel Users Tutorial

Learnit Training
Add to list