Writing SQL for Excel with ADODB playlist https://youtube.com/playlist?list=PLNIs-AWhQzckUd5i0E1xeSFeBAonYIurK
VBA Working with Databases playlist https://youtube.com/playlist?list=PLNIs-AWhQzclbRVLCZlsFvpz6fz2nPGbt

Get files here https://www.wiseowl.co.uk/vba-macros/videos/vba-ado-net-recordsets/sql-excel-aggregation-functions/

If you'd like to help fund Wise Owl's conversion of tea and biscuits into quality training videos, you can click this link https://www.wiseowl.co.uk/donate?t=1​ to make a donation. Thanks for watching!

This video teaches you how to use aggregation functions in SQL queries for Excel to summarise data in a column. You'll learn how to use the Sum, Count, Min, Max, Avg, StDev and Var functions to generate aggregated values for all the rows in a dataset. You'll also see how to use the results of aggregation functions to create new calculations and how to deal with Nulls in the columns you're aggregating.

Chapters
00:00 Topic List
00:41 The Basic Setup
02:56 Calculating the Sum of a Column
05:03 Mixing Aggregated and Non-Aggregated Columns
06:23 Counting Values and Rows
08:21 Finding the Minimum and Maximum Values
10:09 Calculating the Average
11:32 Standard Deviation and Variance
13:30 Including a Where Clause in the Query
15:24 Using Aggregates in Other Calculations
16:49 Aggregating a Calculated Value
17:54 Counting Column Values with Nulls
19:10 Averaging a Column with Nulls
21:17 Replacing Nulls with a Value
23:30 Filtering Out Nulls
24:30 What's Next?

Visit www.wiseowl.co.uk for more online training resources in Microsoft Excel, Power BI, DAX, SQL Server, Reporting Services, Analysis Services, Integration Services, ASP.NET, C#, Visual Basic, Microsoft Access and more