- 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
- excel-lambda-depn.schedule – Create a depreciation schedule in Excel with one function
- Lambda presentation to Microsoft Excel and Data Analysis Learning Community on July 31st, 2022
- excel-lambda-KNN – classify data using K-nearest neighbors (KNN) in Excel
- excel-lambda-FREQ.SIMPLE – create a simple frequency table in Excel with one function
- Lambda presentation to MS Excel Toronto Meetup Group on July 13, 2022
- excel-lambda-CONVERTRECIPE – Convert recipe ingredients to different units in Excel
- excel-lambda-GETHOLIDAYS – Calculate holiday dates for any year in Excel
- excel-lambda-INTRATE.EFFECTIVE – calculate effective interest rate in Excel without iterative calculation
- excel-lambda-PMT.DATES – 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)
- excel-lambda-CORRELMATRIX – 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
- excel-lambda-RANK.DENSE – An Excel lambda function for DENSE_RANK from SQL
- excel-lambda-pd.rolling.aggregates – calculate rolling sum in Excel (and much more)
- What is a thunk in an Excel lambda function?
- excel-lambda-pd.qcut – Group a continuous variable into bins of equal counts
- excel-lambda-CLEANCURRENCYTEXT – Convert currency stored as B or M to a number with just one function
- powerquery-m-clean-currency-text – Convert currency stored as B or M to a number in PowerQuery
- excel-lambda-OUTLIER.TEST – transform, test and flag a variable for outliers in Excel with one function
- excel-lambda-FORECAST.ETS.COMPARE – Build a forecast for comparison with actuals with a single formula
- excel-lambda-GROWTHFROMOFFSET – Calculate % growth of current month over 12 months before
- excel-lambda-DESCRIBE: UPDATED AND IMPROVED – Get descriptive statistics in Excel with just one formula
- excel-lambda-LEV: Calculate the Levenshtein Distance in Excel
- excel-lambda-GROUPAGGREGATE: Quickly create summary tables in Excel with just one formula
- excel-lambda-RECURSIVEFILTER: Use Excel’s FILTER function with dynamic lists of filters
- excel-lambda-DESCRIBE (simple): Get descriptive statistics in Excel with this LAMBDA function
- excel-lambda-ONEHOT: One-hot encode categorical data with LAMBDA
- excel-lambda-NGRAMS: Get n-grams from a text string using this LAMBDA function
- Excel: Un-Merge Cells And Fill Each Cell With Original Value Using VBA
- excel-lambda-ARRAYUNION: Join Two Ranges Or Arrays Of Data Together Using This LAMBDA Function
- excel-lambda-SQLVALUES: Format A Row Of Data For SQL INSERT
- excel-lambda-CHARACTERS: Split An Alphanumeric String Into An Array Of Characters
- excel-lambda-NONEMPTYROWS: 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