Microsoft Excel
Preview: Excel COPILOT() Function and Formula Completion in Action
Live Stream on M365 Copilot Function and Formula Completion in Excel. Registration is NOT required. Just join at noon ET on 03/18/2026
Microsoft Excel
How to Extract Numbers from Text in Excel with REGEXEXTRACT
Excel's REGEXEXTRACT function lets you pull numbers (or any pattern) out of a text string using regular expressions. Unlike functions like TEXTAFTER or TEXTBEFORE that depend on consistent delimiters, REGEXEXTRACT works with messy, inconsistent data — it finds the pattern wherever it appears. In this walkthrough, you'll
Microsoft Excel
Excel Formula Completion: How to Extract Zip Codes from Text with REGEXEXTRACT
Excel's Formula Completion feature can write formulas for you. Just press the equal sign, and Excel suggests the formula based on your data and column headers. In this tutorial, I demonstrate how it works by tackling a common challenge: extracting zip codes from messy address data where the
Microsoft Excel
How to Convert Seconds to Hours, Minutes, and Seconds in Excel
If you have a column of raw seconds in Excel — from video durations, call logs, workout times, or data exports — you need the right formula and formatting to display them as actual time values. Chris walks through the correct approach and explains why the obvious method doesn't work.
excel-formulas
Combine Excel's UNIQUE, LEFT, SEARCH & SORT Functions
What I'm trying to solve 🧩 I had a column of 100 order lines, with each line beginning with the product name, then the order date, then the customer name. My goal was simple: show each product only once. Duplicate products appear throughout those 100 rows, and the product
Microsoft Excel
How Excel Copilot Writes Complex XLOOKUP Formulas Automatically
Excel's Copilot formula completion feature can write complex XLOOKUP formulas for you. Instead of memorizing syntax and figuring out the arguments, you describe what you want in plain English and Copilot generates the formula. In this tutorial, Chris Menard demonstrates this using a sneaker sales dataset. Watch the
Microsoft Excel
How to Link Excel Tables Using the Data Model (Without VLOOKUP or XLOOKUP)
If you've been using VLOOKUP or XLOOKUP to pull data between Excel worksheets, there's a more efficient approach. Excel's Data Model lets you create relationships between tables so you can build PivotTables that pull from multiple sources — without duplicating data or writing complex formulas.
Microsoft Excel
How to Use WRAPCOLS and WRAPROWS Functions in Excel
The WRAPCOLS and WRAPROWS Functions let you reshape a single column of data into a multi-column or multi-row layout. They are useful for transforming long lists into structured grids — and they update automatically when your source data changes. YouTube Video WRAPCOLS: Split a Column into Multiple Columns The
Microsoft Excel
How to Use the TAKE Function in Microsoft Excel
The TAKE function in Excel lets you extract a specific number of rows or columns from a range or array. It's especially powerful when combined with other functions like SUM and AVERAGE to create dynamic calculations. In this tutorial, Chris Menard demonstrates how to use TAKE with practical
Microsoft Excel
How to Use the COPILOT() Function in Excel: AI-Powered Formulas
⚠️ Note: Microsoft has announced that the Excel COPILOT() function will be retired on September 14, 2026. This article is being retained for reference purposes. Excel now has a built-in COPILOT function that accepts natural language prompts directly in cells. Instead of writing complex formulas, you type a plain English
Microsoft Excel
How to Find and Remove Extra Spaces in Excel with Conditional Formatting
Extra spaces in Excel data cause real problems — inconsistent sorting, broken lookups, and formulas that return unexpected results. The tricky part is that extra spaces are invisible. Here's how to use conditional formatting with the TRIM function to find them, and then fix them. The Problem: Hidden Extra
Microsoft Excel
How to Use GROUPBY with HSTACK for Non-Adjacent Columns in Excel
Excel's GROUPBY function is a formula-based alternative to PivotTables that updates automatically and offers more aggregation options — including MEDIAN, MODE, and custom LAMBDA functions. When you need to group by columns that aren't next to each other, HSTACK lets you combine non-adjacent columns into