Log In
Sign Up
Google Sheets Course
1. Introduction
2. Basics
3. Tables
4. Formats
5. Insertion of objects
6. Autofill
7. Formulas and functions
8. Charts
9. Conditional formatting
10. Data
11. Sharing
Apps Script Course
1. Introduction
2. Variables and arrays
3. Sheets and cells
4. Conditions
5. Loops
6. Functions
7. Advanced arrays
8. Triggers
9. Menus
10. Dialog boxes
11. Custom windows
12. Supplements
Functions
Array
Date
Filter
Google
Logical
Lookup
Math
Operator
Statistical
Text
Web
Query
1. Introduction and database
2. Column selection (SELECT)
3. Conditions (WHERE)
4. Partial search (LIKE...)
5. Aggregate functions (SUM, MAX...)
6. Group data (GROUP BY)
7. Sort data (ORDER BY)
8. Limit the number of rows (LIMIT...)
9. Dates and times (DATE...)
10. Scalar functions (YEAR, LOWER...)
11. Apply a format (FORMAT)
12. Modify headers (LABEL)
13. Pivot data (PIVOT)
14. Complements
Tips
Cells and text
Dates and times
Formatting
Functions
Miscellaneous
Ranges and arrays
Sheets
Codes
Apps Script
Arrays
Cells
Code examples
Custom functions
Dates and times
Interface
Miscellaneous
Numbers and generators
Sheets and documents
Text and formats
Forum
Downloads
Accounting
Budget, account management
Business management
Calendars
Converters
Finance, stock market
Games
Health, food
Hobbies
Mathematical tools
Other management tools
Personnel managment
Schedules
Sports
Utilities
Other Applications
Sheets-Pratique Apps
Sheets-Contact
My account
Log In
Email Address
Password
Remember Me
Forgot your password?
Resend the activation email