Видео

This file contains unredacted top secret information. Detective C is tasked with finding the top 3 salespeople in each quarter.

Denver & Boulder Excel Meetup - December 2024 This is a recording of the very first Denver & Boulder Excel Meetup with three presentations from three Excel MVPs - Diarmuid Early, Aditya Kumar Darak and Owen Price. 0:00 Diarmuid Early - Formula Efficiency and Timing 25:00 Aditya Kumar Darak - Structured Types in Power Query 36:01 Owen Price - Predictable Python in Excel

By default, the xl() method in #pythoninexcel will convert Excel error values to NaN values in your DataFrame. If you don't want that to happen, and you want Python in Excel to alert you to Excel errors, here's how to change the default behavior of the xl() method to raise those errors and not return the DataFrame until they're fixed. #excel #python #pythoninexcel #data #analytics

In this quick video, I show you how to use the Python Editor. As of the date of publication, the editor is available in the beta channel only. #python #excel #pythoninexcel

Let's look at four methods of calculating a linear regression in Excel: 1. Analysis Toolpak 2. Analysis Toolpak via VBA 3. LINEST function 4. Python in Excel The Analysis Toolpak has a user form to allow you to select what type of output you want. It's easy to use and it's very fast, but the output comes in a fixed format and aside from selecting which tables you do or don't want to see, there'...

In this video I walk through a few ways to calculate tax on an income given a table of known tax brackets. We look at how to do this with an Excel formula and then with DataFrame.clip.

It's been 12 months since this video was published: ruclips.net/video/74RDI3tA48I/видео.htmlsi=3_LbR4kmnXABsZEf It shows rather abysmal performance from Python in Excel. In this video, I show that with a better approach, we can get significantly faster runtimes of the same calculation and the same amount of data. Thanks for watching!

This video is a solution to the Excel BI Challenge Power Query 161 It's a deceptively tricky challenge and there are many ways to go about it. In this video I use df.groupby.apply with a custom function. #data #excel #python #coding #analytics

Working with dates in Pandas DataFrames is an important skill for an analyst or data scientist. Here's a quick example of how using date properties can shortcut the solution to a common grouping challenge. Challenge data courtesy of Crispo Mwangi, Microsoft Excel MVP mvp.microsoft.com/en-US/MVP/profile/c8e93563-95fb-ed11-8f6d-000d3a560942 The challenge: www.linkedin.com/posts/crispo-mwangi-6ab4...

Just seen this new shortcut for quickly displaying Python plots over cells. 👏 Quality of life 1 💡Ctrl Alt Shift C or use the context menu #data #analytics #excel #python #coding

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