Skip to content

Instantly share code, notes, and snippets.

@Max-Makhrov

Max-Makhrov/Topics.MD

Last active April 11, 2025 13:57
Show Gist options
  • Save Max-Makhrov/c93daf7de3554a6b6ac2135e9c3210b5 to your computer and use it in GitHub Desktop.
Save Max-Makhrov/c93daf7de3554a6b6ac2135e9c3210b5 to your computer and use it in GitHub Desktop.
Download ZIP
Google Sheets Theory
Raw
Topics.MD
  • interface
    • ecosystem
    • interface
    • shortcuts + navigation
    • limitations and alternatives
    • useful links + link theory
    • add-ons
    • collaboration
    • pivot tables
    • Looker Studio
    • Tables
  • cell theory + object theory
    • introduction to App Scripts
  • formula theory
    • normalization
    • what range types
    • what data types
    • what is date
    • history and localization
    • named functions
    • custom functions
    • number formats
    • most common functions (VLOOKUP, IMPORTRANGE, IF)
  • advanced formula theory
    • LET + LAMBDA
    • Array functions
    • QUERY
    • REGEX
    • Complexity + Benchmarking
  • Practice
    • CRM
    • Accounting
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment