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!

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! 🐍🤩

Import a local folder of images into Excel using Power Query and Python!

Excel LAMBDA - abstracting a common REDUCE/VSTACK pattern

Unstack data with missing attributes using PIVOTBY in Excel!

It's CRITICAL to understand your data | Python in Excel 19.2

Find the next Friday the 13th! - Python in Excel #24

SQL Server - Working with JSON Part 1: FOR JSON PATH

SQL Server - Working with JSON Part 3: Basics of OPENROWSET BULK for JSON files

Python in Excel! Part 7 - Cleaning Data With Regex! 🐍🤩

STOP creating summary statistics the hard way in Excel. Do this instead.

More on Excel's NEW GROUPBY function - the sort_order parameter

Level Up Your Python in Excel Experience with the Python Editor!

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