- How to visualize matrix transformations with Python and matplotlib
- 5 ideas for new SQL features!
- SQL is changing into something new – are you ready?
- Exploring NumPy operations with a Python in Excel challenge
- Use XLOOKUP and XMATCH with regular expressions (regex)
- Portfolio – Tableau – Maven Remote Work Challenge
- Better regex results with look-behinds
- Unfold a list with this new function
- 8-Step Process For Writing Recursive Functions in Excel
- Learn A Powerful Technique For Scanning Arrays In Excel
- Professional SQL That Will Make Your Queries Shine: INTERSECT vs. INNER JOIN
- Free LAMBDA – SUMPRODUCT for 2D arrays
- Calculate all pairs from two lists in Excel
- The SWITCH and LET functions – Excel formula performance
- Excel LAMBDA: simplified rolling aggregate of any function
- Breadth-first search using Excel
- Excel LAMBDA: Create a list of integers
- Excel LAMBDA: parameter checks and function validation
- excel-lambda-ROTATE: rotate an array in Excel
- Excel LAMBDA: outlier detection functions
- Excel LAMBDA: Introducing the LAMB namespace
- How and why to use namespaces for Excel Lambda functions
- Video – Learn how to use functions as parameters in Excel
- Video – Detailed walkthrough of creating a Depreciation Schedule LAMBDA function
- Create a depreciation schedule in Excel with one function
- Lambda presentation to Microsoft Excel and Data Analysis Learning Community on July 31st, 2022
- Classify data using K-nearest neighbors (KNN) in Excel
- Create a simple frequency table in Excel with one function
- Lambda presentation to MS Excel Toronto Meetup Group on July 13, 2022
- Convert recipe ingredients to different units in Excel
- Calculate holiday dates for any year in Excel
- Calculate effective interest rate in Excel without iterative calculation
- Create a list of dates for a payment schedule in Excel
- What’s the difference between ROLLUP and GROUPING SETS in SQL?
- Excel – Introduction to Analyze Data (video)
- Calculate a correlation coefficient matrix in Excel
- SQL: Numerical row constructor comparisons in PostgreSQL and MySQL
- SQL: Use LAG and SUM window functions to group rows
- An Excel lambda function for DENSE_RANK from SQL
- Calculate rolling sum in Excel (and much more)
- What is a thunk in an Excel lambda function?
- Group a continuous variable into bins of equal counts
- Convert currency stored as B or M to a number with just one function
- Convert currency stored as B or M to a number in PowerQuery
- Transform, test and flag a variable for outliers in Excel with one function
- Build a forecast for comparison with actuals with a single formula
- Calculate % growth of current month over 12 months before
- UPDATED AND IMPROVED – Get descriptive statistics in Excel with just one formula
- Calculate the Levenshtein Distance in Excel
- Quickly create summary tables in Excel with just one formula
- Use Excel’s FILTER function with dynamic lists of filters
- Get descriptive statistics in Excel with this LAMBDA function
- One-hot encode categorical data with LAMBDA
- Get n-grams from a text string using this LAMBDA function
- Excel: Un-Merge Cells And Fill Each Cell With Original Value Using VBA
- Join Two Ranges Or Arrays Of Data Together Using This LAMBDA Function
- Format A Row Of Data For SQL INSERT
- Split An Alphanumeric String Into An Array Of Characters
- Filter Out Rows With Empty Cells
- Excel: Calculate The Difference Between “Percentage Of Column Total” Columns
- Excel: Use Names To Make Your Formulas Easier To Read