Microsoft Excel
Microsoft 365 Copilot Chat now has a "Think Deeper" mode designed for complex, multi-step problems. I demonstrates it with a real financial scenario: calculating investment returns and projecting future account values with different contribution amounts. The New Modes in Copilot Chat Copilot Chat offers multiple processing modes. The
Microsoft Excel
Excel's Filter by Selection feature lets you click a cell and instantly filter the entire column to show only matching values — no dropdown menus needed. The catch is that it's hidden by default. Here's how to add it to your Quick Access Toolbar for
Microsoft Excel
Table of Contents * 📋 Why this method works and when I use it * 📋 Setting up the table * 🔎 Extract distinct values with UNIQUE * ↕️ Sort the unique list with SORT * 🔢 Count occurrences using COUNTIF * ✅ Why tables beat ranges for this task * 🔁 When to use this instead of a pivot table * 🔧 Quick checklist to
Microsoft Excel
I tested how well Excel's formula completion with Copilot handles a multi-step calculation that would normally require a nested function. The goal was simple: calculate profit by subtracting the total cost of units sold from total revenue, with unit costs stored in a separate lookup table. Instead of
Microsoft Excel
Excel's Copilot-powered Formula Completion is now available on the desktop app — not just Excel for the Web. Type an equals sign, and Excel suggests complete formulas based on your data context. Here are three examples showing how it works. Extracting First Names With a "Rep Name"
Microsoft Excel
The right-click context menu in Excel holds some powerful features that many users overlook. Here are 8 right-click techniques that can speed up your everyday Excel work — from moving columns without cut-and-paste to autofilling weekdays only. 1. Move Columns with Right-Click Drag Instead of cutting and inserting columns, select a
Microsoft Excel
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
If you've clicked the Copilot icon in Excel and gotten a task pane that doesn't look quite right, you're not alone. The default pane opens a general chat window, but the real productivity gains come from switching to App Skills — the workbook-aware Copilot experience
Microsoft Excel
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
Most people use XLOOKUP or VLOOKUP to combine data from two Excel tables. But there's a smarter approach: Excel's built-in Data Model and table relationships. This method links tables like a database — no formulas, no duplicate columns, and no maintenance when data changes. In this tutorial,
Microsoft Excel
Need fictitious customer data, order records, or test datasets for training, presentations, or projects? You can generate all of it using free Copilot Chat — no paid Microsoft 365 Copilot license required. In this guide, I walk through how to use Copilot Chat to create realistic sample data, structure it into
Microsoft 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 WRAPCOLS function