QueryStorm is an add-in for Excel that lets you use SQL and C# in Excel. It has an IDE, a distributable runtime and app store. In this video, I give you an overview of the C# functionality that QueryStorm provides in Excel.
Check out QueryStorm at: https://querystorm.com/
00:00 - Introduction
00:38 - Processing data with LINQ
05:40 - Automating workbooks with C#
16:55 - Custom Excel functions with C#
26:14 - Publishing custom functions
28:32 - Installing custom functions and extensions