Excel OFFSET function
The OFFSET function lets you create a reference to a range of cells that is a certain number […]
Blog
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 […]
Office Scripts in Excel
What are Office Scripts? Office Scripts in Excel let you automate tasks. You can create and edit scripts […]
Learning with YouTube
You can learn a lot from watching a video on a topic. On this website, I have included […]
Excel Sorting
Sorting a list or set of information can be straightforward or more complex. In Excel, you can sort […]
SQL COALESCE() Function
COALESCE() returns the first non-null value in the list. If you have a list of arguments that you […]
Excel’s VLOOKUP Function
Use VLOOKUP when you need to find things in a table or a range by row. For example, […]
Excel COUNTIF Function
Use COUNTIF, one of the statistical functions, to count the number of cells that meet a criterion; for […]
Central Bank Digital Currency (CBDC)
CBDC is a digital currency issued by a central bank rather than by a commercial bank. CBDC is […]
Data Cleaning Introduction
As a data analyst or data scientist, you want to analyze data that is clean, not dirty. In […]