Главная
Study mode:
on
1
Start
2
Introduction
3
List, Format, and Sort
4
Multi-Column Sort
5
Filters
6
Conditional Filters and Filtered Views
7
Creating Charts
8
Editing Charts
9
Removing and Deleting Chart Data
10
Sparklines
11
Formatting with Alternating Row Colors
12
Pivot Tables
13
Pivot Charts
14
Named Ranges
15
IF Functions
16
Nested Functions
17
VLOOKUP
18
SUMIF and AVERAGEIF
19
SUMIFS
20
AVERAGEIFS
21
IFERROR
22
LEFT and RIGHT
23
CONCATENATE
24
Sharing Files
25
Real-Time Authoring
26
Google Sheets Add-Ons
27
Introduction to Google Apps Scripts
28
Conclusion
Description:
Master advanced techniques in Google Sheets with this comprehensive tutorial designed for anyone looking to enhance their data management and analysis skills. Learn to navigate the application, create and share spreadsheets, and perform complex calculations using functions and formulas. Explore data manipulation through filtering, sorting, and pivot tables. Dive into advanced features such as AutoFill, VLOOKUP, macros, and real-time collaboration. Create visually appealing charts, use conditional formatting, and leverage add-ons to extend functionality. Gain hands-on experience with popular functions like IF, SUMIF, AVERAGEIF, and CONCATENATE. Discover the power of Google Apps Scripts for automation and customization. By the end of this 1-hour 11-minute tutorial, you'll have the skills to efficiently gather, format, and interpret data in Google's free, web-based spreadsheet application.

Google Sheets Advanced Tutorial

Learnit Training
Add to list
0:00 / 0:00