Built-in engine

  • Querying Excel tables
    2:08
  • Exploring functions
    4:19
  • Formatting + SQL
    2:21
  • Calling VBA functions
    2:32
  • Working with individual cells
    3:04

External databases

    • Connecting to external databases
      2:38
    • Getting data back into Excel
      4:23

    Automation

    • Preprocessor
      3:41
    • Automation example 1
      3:32
    • Automation example 2
      4:00
    • QueryStorm VBA API
      5:39

      Tips & tricks

      • IDE tips & tricks
        4:59
      • Working with multiple workbooks
        1:20
      • Calling into .NET
        -:--

        Quick queries

        • Outliers
          2:51
        • Histogram
          1:05
        • Typo search
          1:19
        • Unpivot
          1:53
        • Regex split rows
          2:55
        • Regex replace
          3:01

          Examples

          • Master-detail dashboard
            -:--
          • Custom table-value functions
            -:--
          • ...