SQL Server COUNT DISTINCT
You can count the number of unique values in a column with COUNT DISTINCT. The Microsoft Press book […]
Blog
Excel Filtering
This post is about filtering in Excel. For information on the FILTER function have a look at our […]
Excel Sort Function
The new Excel SORT function is one of the new dynamic arrays that are available in Microsoft 365. […]
Excel Dynamic Arrays
What are dynamic arrays in Excel? Dynamic arrays are new to Excel and are available in Microsoft 365 […]
Excel’s Hash Reference
What is the hash symbol that you see in some formulas? What does it do? If you have […]
Sorted Data Validation List
In Excel, in Microsoft 365, how do you sort your dropdown data validation list? You have a cell […]
SQL Temp Tables
Let’s discuss temporary tables in Microsoft’s T-SQL. Temporary tables have a hash (#) at the start of their […]
Cleaning Data with Alex
This post is based on a video on YouTube by Alex the Analyst. Thanks Alex. Learn with YouTube […]
Excel OFFSET function
The OFFSET function lets you create a reference to a range of cells that is a certain number […]
Excel Recursive Lambda Function
LAMBDA functions in Excel are recursive! This means they can call themselves. One classic example of recursion is […]
Simple Linear Regression in Excel
Linear regression analysis is used to predict the value of a variable based on the value of another […]
Excel Lambda Function
Have you ever used VBA in Excel to create your own functions? LAMBDA allows you to create your […]