FLEX YOUR DATA

  • blog
  • Excel
  • LAMBDA
  • Power Query
  • VBA
  • Video
  • SQL
  • 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
© 2022 FLEX YOUR DATA