Microsoft Excel Tutorial: Checkboxes arrive in Microsoft Excel

To download the workbook from today: https://www.mrexcel.com/youtube/kunbe45v7-E/

In this YouTube video, Bill Jelen enthusiastically announces the arrival of checkboxes in Microsoft Excel. They reminisce about the challenges they faced with checkboxes in the past, particularly when working on a report card system for a school district.

Jelen demonstrates how to use the new checkbox feature, emphasizing its location on the “Insert” tab. They show how to insert checkboxes into cells, toggle them on and off, and even use the space bar for quick toggling. The video also explores the underlying true Continue reading “Excel – Exciting! Checkboxes Arrive In Excel – Episode 2628” →

Microsoft Excel Tutorial: Calculate Average Cost per Year in Excel.

Derek has a fleet of vehicles and a list of all repairs made in the last 20 years. He wants to figure out how the annual repair and maintenance costs change as the vehicle ages.

In this video, MrExcel discusses how to calculate annual repair costs based on the age of a vehicle. He provides a data set of repairs made on a fleet of vehicles and explains how to determine the first date each vehicle was placed in service. He suggests using an approximation for vehicles without records by subtracting Continue reading “Excel – Uncover Vehicle Repair Cost Secrets – Episode 2627” →

Microsoft Excel Tutorial: Microsoft Labs in Cambridge releases a great Python editor for Excel.

Just 27 days after Python preview appears in Excel, Microsoft has added a dramatically better Python editor.

To download the workbook from today: https://www.mrexcel.com/youtube/UKpmNAMjygg/

This new editor in the task pane offers AutoComplete, Intellisense, and automatic code coloring. Take a walkthrough the editor in today’s video.

#excel
#microsoft
#microsoftlabs
#microsoftexcel
#exceltricks
#excelpython
#microsoft365
#walkthrough

Buy Bill Jelen’s latest Excel book: https://www.mrexcel.com/products/latest/

Table of Contents
(0:00) Python Editor Added to Excel
(0:10) Free Silo Photos
(0:20) Theories on backstory
(0:59) Get Add-Ins moving from Insert to Home tab
(1:22) Update Excel Labs add-in twice
(1:49) Open Excel Labs & Continue reading “Excel Adds Python Editor 27 Days After Python Debuts – Episode 2625” →

Microsoft Excel Tutorial: How to use Excel’s Filter Search Box to remove items from Filter.

Melvin from Orlando shared a great Excel trick with me during yesterday’s live Power Excel seminar in Daytona Beach.

To download the workbook from today: https://www.mrexcel.com/youtube/Od5IwswzWnI/

We all know you can use the Filter drop-down Search Box to find all cells that contain Apple. But what if you want everything that does not contain Apple? Rather than use the old Text Filters for Does Not Contain, you can use this great trick from Melvin:
1. Search for Apple
2. Uncheck Select All Items
3. Check Add Current Continue reading “Excel Hack Use Filter Search Box to Remove Items from Filter! – Episode 2623 #excel #excelhacks” →

Microsoft Excel Tutorial: Sum across worksheets when rows do not line up?

Today’s question from Rebaz on podcast 1984 – Excel Sum Across Worksheets: “if we have different cell in different sheet, how can I Sum?”

Download the workbook from today: https://www.mrexcel.com/youtube/UO11Ase1_Ys/

This video shows you an easy way to build a 3-D reference in Excel, also known as a spearing formula. Excel functions include SUM, XLOOKUP, FILTER, SUMIFS, TEXTJOIN, TEXTSPLIT, SUMPRODUCT, Helper Arrays, LET, Python in Excel, and VSTACK.

Table of Contents
(0:00) Problem: Adding Across Sheets that are not lined up
(0:43) How to build a 3-D Reference
(1:19) Does XLOOKUP work Continue reading “Excel Sum Across Sheets When Rows Do Not Line Up – Episode 2622” →

Microsoft Excel Tutorial: Appending data from multiple worksheets using Python in Excel

To download today’s workbook: https://www.mrexcel.com/youtube/3rAJPcjO6Ok/

Today, a question about creating a Python data frame from multiple Excel sheets. I use the CONCAT function in Python but then realize that the headings are repeated.
So I show how to use .tail(-1) to remove the top row from each data frame except the first.

Table of Contents
(0:00) Problem Statement
(0:29) Defining 3 data frames
(1:32) Python CONCAT function
(2:20) Python Tail Function
(3:10) Wrap-up