Have you ever found yourself wrestling with Excel, wishing it could just do *that one thing* to make your work easier? Maybe you’ve spent hours manually replacing text, trying to filter data with ...

Last week I explained how Excel uses its own, unique system of serial numbers to calculate dates and times. That piece covered nine Date & Time functions: NETWORKDAYS(), DATEVALUE(), NOW(), DAY(), ...

Suppose you are a project manager using Excel to track your team’s tasks. You have created a database with columns like Tasks, Assignee, Status, and Due Date. Now you want to ch ...