Flex Your Data

SQL: Use GitHub Copilot to write SQL Automatically!

Gaps and Islands with Python in Excel!

Excel LAMBDA: Count Vowels (and two more)

Power Query M: Pivot table with row, column and grand totals

Summarize data EASILY with the GROUPBY function in Excel!

Excel LAMBDA: Simplify development by currying your multi-parameter lambda functions

Fill empty cells with the next value on the row! Python in Excel #23

Excel function to show clock emoji for time value

PYTHON IN EXCEL! Part 12 - Rolling Window Calculations! 🐍😍

Dastardly Data Files! 🐍🦹 Python in Excel 19.1! ‍

Python in Excel! Part 4 - Diagnostics, Errors and FORMULATEXT.PY! 🐍🤩

Python in Excel just got a LOT easier. Check this out.

Move over, Power Query! Dynamically scrape all tables from a webpage directly in Excel! 🐍

Default charts from pandas are AWFUL. Learn how to bend them to your will! 💪 🐍

SQL: Use GitHub Copilot to write SQL Automatically!

PYTHON IN EXCEL! Part 11 - Speed tests and changing the output type of xl!🐍😍

Learn about robust error reporting in Python in Excel!

Python in Excel! Part 3 - Power Query Data

Python in Excel! Part 5 - Create Python cells from GitHub scripts using VBA! 🐍🤩

Use Excel's PIVOTBY function to fix your data structure!

Python in Excel! Part 8 - Applying a data cleaning function to grouped data! 🐍🤩

Python in Excel 27 - Dates in Pandas DataFrames

Excel: Beware of CHOOSECOLS when used with SEQUENCE

Rolling aggregates of any function with one simple formula!

SQL: UNION ALL, ROLLUP and GROUPING SETS for sub-totals

Apply a custom function to grouped data! Python in Excel 28

Get FAST results with 3D NumPy arrays! Python in Excel #25

Excel: Introduction to Import Function From Grid in the Advanced Formula Environment

Cleaning data? ⚠️ TRUST BUT VERIFY ⚠️

Clean up your charts! Python in Excel #18.2

Clean up your charts! Python in Excel #18.3 🐍😄

Python in Excel! Part 10: Get top N rows from a DataFrame! 🐍😃

Python in Excel! Part 2 - Organization

Power Query M: Simple Table Joins

Excel: Use conditional formatting and ignore hidden rows

Functions as parameters with Excel LAMBDA

Apply image filters using Python in Excel!

Python in Excel 26 - Quickly display plots with this NEW shortcut!

Excel LAMBDA: create a Quarter function using "Import from Grid"

PYTHON IN EXCEL! Part 14 - f-strings, docstrings and extending a DataFrame with custom methods!

Excel LAMBDA: 15 functions for working with text strings

Python in Excel! Part 1 - Introduction

Don't write ugly code! Do this instead... Python in Excel # 20

Python in Excel! Part 9 - Basics of configurable plots! 🐍📊

Introduction to Anaconda Code including Python User Defined Functions!

How Fast Is Python in Excel? Speed Tests using Black-Scholes Option Pricing

Don't Forget Numpy Select! Python in Excel #22

POWERFUL NEW debugger for Excel formulas!

Cleaning multi-domain dimensions! Python in Excel #19.4

#SQL

Python in Excel! Part 6 - Using Python to restructure data! 🐍🤩