Google Sheets

Useful functions:

• QUERY: Simple SQL commands such as Groupby
• ARRAYFORMULA
• Indirect
• Xlookup
• AI function
• Sumproduct i.e. ${\sum }_{i,j}{\alpha }_i{\beta }_j$
• SWITCH: Like a nested if statements
• Percentile:
• Importrange:
• Unique: removes duplicates
• Forecast : Time Series Forecasting

Accessing google sheets from a script: https://www.youtube.com/watch?v=zCEJurLGFRk

Related:

• Excel vs Google Sheets
• Google Sheet Pivots Table