Excel
If you've wrestled with CSV files that open in Excel but look wrong, or spent time in Power Query to coax dates and columns into place, there's good news. Excel now includes two new functions that let you pull file data directly into a worksheet with
delta-companion-certificate
If you hold a Delta credit card that includes a Companion Certificate, this guide explains exactly how to use the Delta Companion Certificate to book a discounted second seat. I walk through eligibility, the booking flow, examples of pricing mechanics, and common pitfalls so you can redeem yours with confidence.
treasury-bills
Purchase T-Bills from Treasury Direct directly from the U.S. Treasury to earn higher returns than many bank accounts, avoid brokerage fees, and manage short-term cash with predictable safety. This guide explains what you need, how the process works, and the practical steps I follow to buy Treasury bills on
microsoft-teams
I noticed three small but powerful updates in Teams: Three New Features December 2025 that have already changed how I work across multiple monitors. These updates let me pop core apps out of the sidebar into separate windows, keep Teams visible while I work in other programs, and find images
OneDrive
I rely on OneDrive every day, and the OneDrive Recycle Bin is one of those quiet lifesavers most people forget about until they panic. Whether it's a Teams meeting recording that a policy removed after 60 days or a spreadsheet I accidentally deleted, knowing how the OneDrive Recycle
excel-formulas
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
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
Writing formulas in Excel can be time-consuming and challenging, even for experienced users. Selecting the right function, referencing the correct cells, and ensuring proper syntax often slows down workflows and leads to errors. Many users spend extra time troubleshooting mistakes, searching for examples, or trying to recall the exact formula
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
Thoughts, stories and ideas.
Microsoft Teams has a great Copilot feature. A Microsoft 365 license is required for this feature. In a Teams meeting, I need AI assistance during a conversation, but the participants do not want the call recorded or transcribed. There are plenty of situations where privacy matters: a vendor asks for
November 4, 2025 Microsoft MVP and productivity expert Chris Menard will be presenting a highly anticipated session titled âExecutive Insights: Harnessing Excel for Strategic Analysisâ at the EA Ignite Conference, held at the Renaissance Nashville Hotel. This premier event, running from November 3â5, 2025, is tailored for executive assistants
Chris Menard will present âMastering Microsoft 365 Copilotâ at EA Ignite in Nashville on Nov 3, 2025. Learn how Copilot boosts productivity in Word, Excel, PowerPoint, Outlook, and Teams during this hands-on session.
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.
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.
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
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
If you're a Microsoft 365 Copilot user, you're in for a treat. This tool offers a feature that can significantly streamline your workflow by turning a simple list of names into a comprehensive list of email addresses. In this article, we'll explore how to
Microsoft Teams is a powerful collaboration tool, but navigating through numerous teams and channels can sometimes be overwhelming. In this guide, we'll explore how you can streamline your experience by focusing on channels alone, without the clutter of team names. This is particularly useful for users who want
Handling data efficiently is crucial. Whether you're a business analyst, an administrative professional, a data scientist, or simply someone who deals with spreadsheets regularly, having the right tools can make all the difference. Enter Microsoft Copilot, a revolutionary tool designed to streamline data cleaning in Excel. In this
Starting in May 2025, Microsoft Excel's Copilot will have a new game-changing feature: It will allow users to create worksheets from prompts. This innovative tool simplifies data management by generating tables and workbooks through intuitive prompts. This article will explore how to use Excel Copilot to maximize efficiency
Microsoft Copilot continues to evolve, bringing powerful new capabilities to improve productivity in Word. One of the most exciting recent updates is the ability to reference an entire folder in Copilot for Word instead of being limited to referencing individual files. Alongside this, Copilot now supports working with massive documents
