16:05

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

05:35

Python in Excel 27 - Dates in Pandas DataFrames

03:19

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

08:18

Rolling aggregates of any function with one simple formula!

09:28

Unstack data with missing attributes using PIVOTBY in Excel!

08:55

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

01:18

POWERFUL NEW debugger for Excel formulas!

06:30

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

09:05

Summarize data EASILY with the GROUPBY function in Excel!

14:14

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

04:49

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

00:58

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

13:45

Cleaning multi-domain dimensions! Python in Excel #19.4

07:14

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

04:43

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

05:11

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

07:26

Cleaning data? ⚠️ TRUST BUT VERIFY ⚠️

06:21

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

04:52

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

06:19

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

04:46

Clean up your charts! Python in Excel #18.2

02:33

Clean up your charts! Python in Excel #18.1

09:54

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

09:27

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

03:32

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

10:52

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

02:10

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

05:28

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

04:01

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

05:47

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

08:22

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

06:03

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

06:41

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

03:23

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

06:53

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

07:49

Python in Excel! Part 3 - Power Query Data

07:44

Python in Excel! Part 2 - Organization

05:13

Python in Excel! Part 1 - Introduction

00:56

Excel: Use conditional formatting and ignore hidden rows

01:12

Split multi-part names in Excel

04:51

SQL: Use GitHub Copilot to write SQL Automatically!

01:00

Excel LAMBDA: Simple function to duplicate a row

01:23

Excel: Beware of CHOOSECOLS when used with SEQUENCE

12:36

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

17:00

Excel LAMBDA: 15 functions for working with text strings

05:50

Excel LAMBDA: Quick confidence interval and quartile functions

04:05

Excel LAMBDA: Clone and manage gists using git bash

02:54

Excel LAMBDA: MAP function in under 3 minutes

02:48

Excel LAMBDA: Count Vowels (and two more)

20:23

Power Query M: Simple Table Joins

22:31

#SQL: Dynamic UNPIVOT of columns, add sub-totals, then PIVOT

14:06

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

05:38

Power Query Challenge: Conditional row-duplication and value distribution

02:03

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

06:56

Power Query M: Search for functions with a specific parameter

01:09

Excel: COUNTIF vs. COUNT/FILTER

13:43

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

12:19

Excel LAMBDA - abstracting a common REDUCE/VSTACK pattern

12:25

Power Query M: Add multiple columns at once using Table.TransformRows

03:02

Excel: More on Import Function From Grid in the Advanced Formula Environment