Excel VBA Introduction Part 58.12 - SQL for Excel Files - Aggregation Functions

Показать описание

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?

Рекомендации по теме

Комментарии

Good tutorial, you enriched our information, thanks.

youssefsedkey

Hello once again WiseOwl!
A little bit out of topic of your usual videos, but how can you use the mouse wheel in scroll bars of forms? I actually don't understand what's the point of scroll bars when you can't use the mouse wheel. :D

corneliuzabolotnic

Thank you very much. Shorter videos are better so as not to lose concentration :)

KhalilYasser

Baie Dankie Andrew brilliant tutorial as always 👏👌👍 the only downside I have is I didn't want this one to stop 😀 I was on the wrong track with this function by mixing the column 🙄 and couldn't understand why I was getting the alarm, thank you for pointing that out 👌

frikduplessis

Hi Andrew, thank you for the amazing videos. I was trying to connect to MS SQL installed on my machine when I gave the path for server, it threw an error but when I wrote localhost it worked. The error was something like this ' the machine actively refused to connect'. I tried to google it but no good answer.

tejamarneni

Thanks a lot sir,

Need help?

Want to set password in access database using excel vba
I have created the database and table using vba but can't set the password
Can you help me on this
Using office 365

minitv

Excel VBA Introduction Part 58.12 - SQL for Excel Files - Aggregation Functions

Excel VBA Introduction Part 58.1 - SQL for Excel Files - Basic Select Statements

Excel VBA Introduction Part 58.11 - SQL for Excel Files - Text Expressions

Excel VBA Introduction Part 58.5 - SQL for Excel Files - Adding Criteria to a Query

Excel VBA Introduction Part 58.10 - SQL for Excel Files - Date Expressions

Excel VBA Grundlagen einfach erklärt (2024)

Excel VBA Beginner Tutorial

Excel VBA Introduction Part 57.2 - Basic Web Scraping with Selenium and Google Chrome

Excel VBA Introduction Part 57.4 - Finding Web Elements in Selenium

Excel VBA: The Ultimate Cell Formatting Masterclass + FREE Cheat Sheet

Excel VBA Introduction Part 15a - Find and FindNext

Excel VBA Introduction Part 57.1 - Getting Started with Selenium Basic and Google Chrome

Excel 2021 VBA Full Course Tutorial (6+ Hours)

Excel VBA: Referring to Ranges & Writing to Cells (Range, Cells, Offset, Names)

Excel VBA Introduction Part 27.1 - Creating Word Documents

Spin Button in Excel VBA | Excel VBA user form part - 9 | Excel VBA lesson - 64| Excel VBA user form

Excel 2019 VBA Intermediate Tutorial

Excel VBA Introduction Part 19 - Error Handling (On Error, Resume, GoTo)

Learn Excel VBA Programming [Practical Tutorial for Building Excel Macros]

Mach deinen Code 10x schneller (Nutze Array statt Range) | Excel VBA

Excel VBA User form part - 1 | Excel VBA lesson 56 | Create Label in vba user form

Corso VBA Excel da 8 ore in Italiano - VBA Excel Tutorial Italiano

Microsoft Excel VBA Tutorial | Full Course

Excel VBA - Part # 12

Microsoft Excel VBA - Sending Outlook Emails with VBA Code