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

How to Use the Future Value function Correctly in Excel (Monthly Compounding Fix)

If you model investments in Excel, the future value function is one of the most useful tools you have. The problem is a small but common mistake: dividing an annual return by 12 to get the monthly rate. That shortcut breaks the math when compounding is involved, leading to a

New Excel Functions: IMPORTTEXT & IMPORTCSV Explained!

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

How to use Delta Companion Certificate: step-by-step guide

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.

How to Purchase T-Bills from Treasury Direct: Step-by-Step Guide

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

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.

Teams Three New Features December 2025: How to Pop Out Apps, Pin Teams, and Search Images

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 Recycle Bin Tips and Tricks: How to Recover Files

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

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

Using Copilot's Think Deeper Mode for Financial Calculations and Investment Projections

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

OneDrive Recycle Bin: How to Recover Deleted Files and Use the Second-Stage Safety Net

When you delete a file from OneDrive, it doesn't disappear immediately. Files move to the OneDrive Recycle Bin first, where they stay for 93 days before permanent deletion. Knowing how the recycle bin works — and that there's a second-stage safety net — can save you from losing

How to Add Filter by Selection to Excel's Quick Access Toolbar

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