Enhancements to GROUPBY in Excel - Meetup July 2025

From 100 Sheets to One Report Smart Data Consolidation for Finance Teams with Aditya Kumar Darak

Deep dive on Excel Range Names with Neale Blackwood!

Introduction to Anaconda Code including Python User Defined Functions!

Robust Dynamic Charts with Dynamic Arrays and Names with Jon Peltier

Excel's DATE function has a problem. This video solves it.

Apply image filters using Python in Excel!

Create thumbnails from a folder of images using Python in Excel!

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

Expert tips on Formula efficiency, Power Query types and Python in Excel!

Learn about robust error reporting in Python in Excel!

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

Learn 4 Methods for Regression in Excel!

Calculate taxes from tax brackets using Python in Excel!

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

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

Python in Excel 27 - Dates in Pandas DataFrames

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

Rolling aggregates of any function with one simple formula!

Unstack data with missing attributes using PIVOTBY in Excel!

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

POWERFUL NEW debugger for Excel formulas!

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

Summarize data EASILY with the GROUPBY function in Excel!

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

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

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

Cleaning multi-domain dimensions! Python in Excel #19.4

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

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

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

Cleaning data? ⚠️ TRUST BUT VERIFY ⚠️

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

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

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

Clean up your charts! Python in Excel #18.2

Clean up your charts! Python in Excel #18.1

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

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

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

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

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

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

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

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

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

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

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

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

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

Python in Excel! Part 3 - Power Query Data

Python in Excel! Part 2 - Organization

Python in Excel! Part 1 - Introduction

Excel: Use conditional formatting and ignore hidden rows

Split multi-part names in Excel

SQL: Use GitHub Copilot to write SQL Automatically!

Excel LAMBDA: Simple function to duplicate a row

Excel: Beware of CHOOSECOLS when used with SEQUENCE

Power Query - Clean up pairwise matches (and much more) with a simple custom function

Excel LAMBDA: 15 functions for working with text strings