Google Sheets Analytics
Google Sheets Analytics
17 900 Ft
QUERY function, ArrayFormula, ImportRange, Apps Script — the Google Sheets features that Excel users do not know about.
QUERY function, ArrayFormula, ImportRange, Apps Script — the Google Sheets features that Excel users do not know about.
Google Sheets Analytics focuses on the features unique to Google Sheets that make it powerful for analytics and automation. You will learn: QUERY function (SQL-like syntax), ArrayFormula, ImportRange (cross-spreadsheet references), IMPORTHTML/IMPORTXML (web scraping), Google Finance functions, conditional formatting, pivot tables, Explore feature (AI insights), chart types, data validation with dropdowns, Google Apps Script (custom functions, triggers, automation), and dashboard creation. 30 hours. From 17,900 Ft.
Online now