Category: Excel

Excel – Create an NBA Shot Chart Using Python & Copilot | LeBron James – 16 Playoffs – Episode 2657

Posted on by Annie D

Microsoft Excel Tutorial: Create an NBA Shot Chart Using Python & Copilot | LeBron James – 16 Playoffs

In this video, I’m excited to show you a demo I saw from Microsoft that’s seriously cool! We’re diving into how to use the new Python integration with Excel Copilot to create an NBA basketball shot chart. With data sensors installed in every NBA arena since 2013, we now have detailed info on every shot, including the exact X and Y coordinates and whether the shot was made or missed. This data opens up a whole new world of possibilities for sports analytics Continue reading “Excel – Create an NBA Shot Chart Using Python & Copilot | LeBron James – 16 Playoffs – Episode 2657” →

Excel Find Active Cell With New Focus Cell (in Beta Now)

Posted on by Annie D

In this Microsoft Excel tutorial, learn how to add a crosshair to locate the active cell with the new Focus Cell feature, now in beta! As our eyes age and screen resolutions increase, it can be tough to spot the active cell. But with the Focus Cell feature, Excel highlights the entire row and column of the active cell, making it much easier to find.

In this video, I’ll walk you through how to enable the Focus Cell setting, which is located on the View tab (next to View Gridlines). You can choose from eight different colors, and the crosshair appears Continue reading “Excel Find Active Cell With New Focus Cell (in Beta Now)” →

Excel Word Cloud Using Copilot And Python In Excel – Episode 2656

Posted on by Annie D

Microsoft Excel Tutorial: Word Cloud Using Copilot And Python In Excel – Episode 2656

Creating a word cloud in Microsoft Excel has never been easier! In this video, I walk you through how to generate a word cloud using the new Copilot – Advanced Analysis feature. With just a few clicks, I transformed 3000 rows of data from the Title column into a visually stunning word cloud. The best part? Excel automatically excludes common stop words like “The,” “A,” and “of” so you can focus on the key terms.

I was amazed at how Excel leverages Python to make this happen behind Continue reading “Excel Word Cloud Using Copilot And Python In Excel – Episode 2656” →

Highline College Busn 210 Excel Statistical Analysis Fall, 2024 Introduction

Posted on by Annie D

For Fall 2024 matriculating students at Highline College in Seattle, Washington. This is the introduction to the Busn 210 Excel Statistical Analysis class. For non-matriculating students, the class is free here at YouTube: https://www.youtube.com/playlist?list=PLrRPvpgDmw0m3oqpp1XcPuaxyM4Bpi0dN

Lookup Manager Name in Column Headers to Create Report: Excel Magic Trick 1866

Posted on by Annie D

Download Excel File: https://excelisfun.net/files/EMT1866.xlsx
Buy M Code Book at Mr Excel site: https://www.mrexcel.com/products/the-… or Amazon: https://www.amazon.com/Transformative… Mike “excelisfun” Girvin’s 4th book: The Transformative Magic of Power Query M Code in Power BI & Excel. Book about Power Query M Code to help data analysts transform and shape data into useful, actionable information for decision makers.

Topics in Video:
1) (00:00) Introduction
2) (00:55) Worksheet function to create column of employee names from a table using TOCOL and UNIQUE functions.
3) (01:30) Worksheet function to lookup manager names and join with a comma between each name using Continue reading “Lookup Manager Name in Column Headers to Create Report: Excel Magic Trick 1866” →

Excel 365 to Make Your Teaching Job Easy: Dynamic Spilled Arrays, XLOOKUP, Power Query & PivotTables

Posted on by Annie D

Highline College Professional Development Day 2024 presentation by Mike “excelisfun” Girvin
Download Excel file: https://people.highline.edu/mgirvin/M365Excel-HighlineProDevDay.xlsx
Pdf file with video notes: https://people.highline.edu/mgirvin/M365Excel-HighlineProDevDay.pdf
In this video learn how to: Create Gradebook with Dynamic Spilled Arrays Formulas and the XLOOKUP function, Use Dynamic Spilled Arrays Formulas to Create Budget, Use Power Query to Import Student Grade Data from Canvas, Use PivotTables to Create Summary Reports from Student Survey Data.

Topics:
1. (00:00) Introduction
2. (01:25) Create Gradebook with Dynamic Spilled Arrays Formulas and the XLOOKUP function.
3. (12:05) Don’t be Tricked by Number Formatting
4. (16:05) BYROW and BYCOL functions to spill aggregate totals and Continue reading “Excel 365 to Make Your Teaching Job Easy: Dynamic Spilled Arrays, XLOOKUP, Power Query & PivotTables” →

DAME 07: How to Make Effective Dashboard. Three Examples in Power BI

Posted on by Annie D

Download files: https://excelisfun.net/files/DAMEwithMPT07.zip
Free YouTube Data Analysis Class about Microsoft Power Tools in 2024 taught by Excel MVP and Highline College Professor, Mike “excelisfun” Girvin.
In this video learn about the guidelines for how to build effective dashboards. See three examples in Power BI.
Topics:
1. (00:00) Introduction
2. (00:27) Guidelines for how to build effective dashboards
3. (09:03) Files to build Three Dashboards.
4. (09:35) Dashboard #1: Average Daily & Monthly Metrics across various attributes
5. (19:33) Dashboard #2: Grade Analysis Dashboard
6. (26:42) Dashboard #3: YOY Sales Dashboard
7. (31:27) Summary
8. (31:40) Conclusion

#dashboard #powerbi #powerbidesktop #visualization

Excel Slow Workbook Speeds Up Instantly With ForceFullCalculation Toggled Off – 2644

Posted on by Annie D

Microsoft Excel Tutorial: Make workbook calculate faster by toggling off the ForceFullCalculation setting.

Welcome back to MrExcel! Today, I’ve got an incredible tip that can make your Excel workbooks run dramatically faster. Have you ever heard of ActiveWorkbook.ForceFullCalculation = False? Probably not, because it’s a setting that’s rarely documented. But it can make a huge difference in calculation speed, as shown in this example sent by Matt from Chicago, a member of the MrExcel message board.

Matt provided us with a file containing 7,000 rows and 27 columns, which is just a fraction of the size of his client’s actual files. With Continue reading “Excel Slow Workbook Speeds Up Instantly With ForceFullCalculation Toggled Off – 2644” →

DAME 06: DAX Fundamentals in Power BI & Power Pivot: 2.5 Hour Free Class

Posted on by Annie D

Download files: https://excelisfun.net/files/DAMEwithMPT06.zip, pdf notes: https://excelisfun.net/files/06-DAMEMPT.pdf
This video teaches how the fundamentals of Columnar Database, DAX Calculated Columns, DAX Measures, Row Context, Filter Content, Context Transition, Overwrite Operation, DAX X Iterator functions, DAX CALCULATE function and much more!
Free YouTube Data Analysis Class about Microsoft Power Tools in 2024 taught by Excel MVP and Highline College Professor, Mike “excelisfun” Girvin.
In this video learn about
This video covers.
1. (00:00:00) Introduction and video topics
2. (00:00:25) Topics in Video
3. (00:01:49) Why we use DAX, M Code & Worksheet Formulas: What makes Each Special?
4. (00:05:30) Review data, data structure, Excel Continue reading “DAME 06: DAX Fundamentals in Power BI & Power Pivot: 2.5 Hour Free Class” →

Excel – RegEx Building Blocks – 2643

Posted on by Annie D

Microsoft Excel Tutorial: Learning the Building Blocks for RegEx in Excel
Learn the basic building blocks of RegEx in Excel.

To download the RegEx Cheat Sheet and workbook from today: https://www.mrexcel.com/youtube/fbHQgDM0P1E/

Welcome back to MrExcel’s YouTube channel! In this video, we’ll dive into the building blocks for mastering Regular Expressions (RegEx) and their integration in Excel. If you find this video helpful, don’t forget to click the Like button below – it helps us reach more viewers. We’ve got over 2,500 videos on various Excel topics, so there’s plenty to explore!

Our focus today is on RegEx, specifically the new functions Continue reading “Excel – RegEx Building Blocks – 2643” →