Канал: Flex Your Data

Learn about robust error reporting in Python in Excel!

Learn about robust error reporting in Python in Excel!

Learn Python in Excel - recursively swap letters in a string

Learn Python in Excel - recursively swap letters in a string

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

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

Learn 4 Methods for Regression in Excel!

Learn 4 Methods for Regression in Excel!

Calculate taxes from tax brackets using Python in Excel!

Calculate taxes from tax brackets using Python in Excel!

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

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

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

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

Python in Excel 27 - Dates in Pandas DataFrames

Python in Excel 27 - Dates in Pandas DataFrames

Navigate table #data on #excel for mobile using card view

Navigate table #data on #excel for mobile using card view

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

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

#Excel Shortcut 8 - Insert or Reply to Threaded Comment

#Excel Shortcut 8 - Insert or Reply to Threaded Comment

Excel Shortcut #7 - Format as number with 2 decimal places #excel #exceltips #exceltutorial

Excel Shortcut #7 - Format as number with 2 decimal places #excel #exceltips #exceltutorial

Rolling aggregates of any function with one simple formula!

Rolling aggregates of any function with one simple formula!

Unstack data with missing attributes using PIVOTBY in Excel!

Unstack data with missing attributes using PIVOTBY in Excel!

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

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

POWERFUL NEW debugger for Excel formulas!

POWERFUL NEW debugger for Excel formulas!

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

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

Summarize data EASILY with the GROUPBY function in Excel!

Summarize data EASILY with the GROUPBY function in Excel!

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

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

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

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

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

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

Cleaning multi-domain dimensions! Python in Excel #19.4

Cleaning multi-domain dimensions! Python in Excel #19.4

There's never just one way in #python 🙄 #data #datascience

There's never just one way in #python 🙄 #data #datascience

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

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

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

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

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

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

Cleaning data? ⚠️ TRUST BUT VERIFY ⚠️

Cleaning data? ⚠️ TRUST BUT VERIFY ⚠️

Gaps and Islands with Python in Excel! #dataanalytics #excel #python

Gaps and Islands with Python in Excel! #dataanalytics #excel #python

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

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

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

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.3 🐍😄

Clean up your charts! Python in Excel #18.2

Clean up your charts! Python in Excel #18.2

Clean up your charts! Python in Excel #18.1

Clean up your charts! Python in Excel #18.1

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

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

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.

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 14 - f-strings, docstrings and extending a DataFrame with custom methods!

PYTHON IN EXCEL! Part 13 - The dt accessor, method chaining and a frequency table

PYTHON IN EXCEL! Part 13 - The dt accessor, method chaining and a frequency table

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

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 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 10: Get top N rows from a DataFrame! 🐍😃

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

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 8 - Applying a data cleaning function to grouped data! 🐍🤩

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

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

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

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 5 - Create Python cells from GitHub scripts using VBA! 🐍🤩

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

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

Python in Excel! Part 3 - Power Query Data

Python in Excel! Part 3 - Power Query Data

Python in Excel! Part 2 - Organization

Python in Excel! Part 2 - Organization

Python in Excel! Part 1 - Introduction

Python in Excel! Part 1 - Introduction

Excel: Use conditional formatting and ignore hidden rows

Excel: Use conditional formatting and ignore hidden rows

Split multi-part names in Excel

Split multi-part names in Excel

This chart is bananas

This chart is bananas

Excel function to show clock emoji for time value #excel #microsoftexcel #exceltips #exceltricks

Excel function to show clock emoji for time value #excel #microsoftexcel #exceltips #exceltricks

What *do* you mean? #microsoftexcel #humor #excel #data #datavisualization

What do you mean? #microsoftexcel #humor #excel #data #datavisualization

SQL: Use GitHub Copilot to write SQL Automatically!

SQL: Use GitHub Copilot to write SQL Automatically!

Excel LAMBDA: Simple function to duplicate a row

Excel LAMBDA: Simple function to duplicate a row

Excel: Beware of CHOOSECOLS when used with SEQUENCE

Excel: Beware of CHOOSECOLS when used with SEQUENCE

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

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

Intro to the SCAN function in #excel!

Intro to the SCAN function in #excel!

7 Examples of List Slicing in Python

7 Examples of List Slicing in Python

5 Tips for better LinkedIn Job Search Results!

5 Tips for better LinkedIn Job Search Results!

VS Code SQL Shortcuts

VS Code SQL Shortcuts

Excel LAMBDA: 15 functions for working with text strings

Excel LAMBDA: 15 functions for working with text strings

Excel LAMBDA: Quick confidence interval and quartile functions

Excel LAMBDA: Quick confidence interval and quartile functions

Excel LAMBDA: Clone and manage gists using git bash

Excel LAMBDA: Clone and manage gists using git bash

Excel LAMBDA: MAP function in under 3 minutes

Excel LAMBDA: MAP function in under 3 minutes

Excel LAMBDA: Count Vowels (and two more)

Excel LAMBDA: Count Vowels (and two more)

Power Query M: Simple Table Joins

Power Query M: Simple Table Joins

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

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

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

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

Power Query Challenge: Conditional row-duplication and value distribution

Power Query Challenge: Conditional row-duplication and value distribution

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

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

Power Query M: Search for functions with a specific parameter

Power Query M: Search for functions with a specific parameter

Excel: COUNTIF vs. COUNT/FILTER

Excel: COUNTIF vs. COUNT/FILTER

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

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

Excel LAMBDA - abstracting a common REDUCE/VSTACK pattern

Excel LAMBDA - abstracting a common REDUCE/VSTACK pattern

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

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

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

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

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

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

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

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

SQL Server - Working with JSON Part 2: Basics of OPENJSON & JSON_VALUE

SQL Server - Working with JSON Part 2: Basics of OPENJSON & JSON_VALUE

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

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

Excel LAMBDA - Using defined names to simplify functions

Excel LAMBDA - Using defined names to simplify functions

Excel LAMBDA - Depreciation waterfall

Excel LAMBDA - Depreciation waterfall

Excel LAMBDA - multiple depreciation schedules with one function

Excel LAMBDA - multiple depreciation schedules with one function

Power Query Function documentation vs Intellisense

Power Query Function documentation vs Intellisense

Excel LAMBDA - Parameter checks and function verification

Excel LAMBDA - Parameter checks and function verification

Apply multiple substring replacements in Power Query using List.Accumulate

Apply multiple substring replacements in Power Query using List.Accumulate

Functions as parameters with Excel LAMBDA

Functions as parameters with Excel LAMBDA

Excel LAMBDA Walkthrough - Depreciation Schedule

Excel LAMBDA Walkthrough - Depreciation Schedule

Use LAMBDA in Excel to create a depreciation schedule

Use LAMBDA in Excel to create a depreciation schedule

Excel - INDEX vs. CHOOSEROWS

Excel - INDEX vs. CHOOSEROWS

Excel LAMBDA - Extract Zip Codes From Addresses

Excel LAMBDA - Extract Zip Codes From Addresses

Customize Autocorrect in Excel (and 8 other customizations)

Customize Autocorrect in Excel (and 8 other customizations)

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

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

Excel - Introduction to Analyze Data

Excel - Introduction to Analyze Data