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 Teams
How to use the newly returned feature that lets you save Chat and Channel Messages in Teams so you can keep important conversations at your fingertips.
Microsoft PowerPoint
Microsoft 365 Copilot can now create PowerPoint presentations directly from Excel files. Instead of manually building slides from spreadsheet data, you point Copilot at your Excel file and it generates a complete presentation with charts, tables, and organized sections — all in under a minute. This feature requires a Microsoft 365
Microsoft Excel
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 instruction, and Copilot returns AI-generated results that spill into adjacent cells — just like SORT or UNIQUE. This function works in Excel for Windows and Excel
Microsoft OneDrive
OneDrive Request Files feature allows you to collect files from people inside or outside your organization, without letting those people see anyone else’s uploads.
Microsoft Excel
Excel now includes a built-in AutoRefresh option for PivotTables. When enabled, the PivotTable updates automatically any time the underlying data changes — no manual refresh needed. The Source Data Start with a table of customer data that includes columns for customer number, last name, first name, city, state, and purchase amounts
Microsoft Excel
Merge and Center is one of Excel's most misused features. It looks great for formatting headers, but it breaks sorting, filtering, copying, and pasting. In this tutorial, Chris Menard explains exactly why Merge and Center causes problems and shows you the better alternative: Center Across Selection. Watch the
Microsoft Teams
As a Microsoft MVP and certified trainer, I’m always excited to share the latest productivity tools that help you work smarter. If you’re a frequent Microsoft Teams user, you’ll be thrilled to hear about the new Teams Follow Threads feature rolling out in public preview as of
Microsoft Excel
When your Excel data has multiple values crammed into a single cell — like office locations separated by commas — sorting and filtering become impossible. Power Query can split those values into separate rows, giving you clean, usable data. The Problem: Comma-Separated Values in One Cell Consider a table with employee names,
Microsoft Excel
Not sure which Excel function to use? Copilot Chat can figure it out for you. Instead of searching through documentation, describe what you want to do in plain English and Copilot will suggest the right function — complete with the formula and an explanation of how it works. This works in
Microsoft Copilot
If you have a Microsoft 365 business or enterprise license, you already have access to a powerful file comparison tool — and it's completely free. Copilot Chat can upload, summarize, and compare documents side by side, whether they're PDFs, Word files, or PowerPoint presentations. Accessing Copilot Chat
Microsoft Outlook
Managing emails efficiently is crucial, especially when it comes to handling attachments. I demonstrate an exciting new feature that has rolled out in Microsoft Outlook’s Copilot — the ability to summarize Outlook attachments with Copilot. While Copilot has long been capable of summarizing email bodies, this new enhancement now extends