As PCMag's resident data journalist, I practically live in Microsoft Excel. I've learned that it's capable of far more than I ...

Ditch manual sorting for live formulas that rank top performers, fastest times, and equal scores as data changes.

Today is Microsoft's April 2026 Patch Tuesday with security updates for 167 flaws, including 2 zero-day vulnerabilities.

In this video, you'll learn three methods to SUM and COUNT cells in Excel based on cell color, as Excel does not have a built ...

Zomato Restaurant Data Analysis Project This project involved analyzing Zomato restaurant data using advanced Excel functions and SQL queries, and creating interactive dashboards using Power BI and ...

Have you ever found yourself sifting through endless rows of data, trying to confirm whether a specific item exists? It’s a tedious, error-prone process that can derail even the most organized ...

A new COPILOT function in Excel lets you use AI in a formula. The new skill is now available to Microsoft 365 insiders. Reduces some of the complexity involved in creating formulas. Get more in-depth ...

Microsoft Excel’s new COPILOT function lets users generate, summarize, and analyze data directly in spreadsheet cells using plain-language prompts. (Microsoft Image) Microsoft is building generative ...

Q. Are there any alternatives to traditional PivotTables in Excel? A. The first thing that comes to mind is the function GROUPBY. The primary purpose of GROUPBY is to make data analysis easier by ...

Excel's COUNTIFS function is a powerhouse for conditional counting. When you combine it with dates, you unlock a whole new level of data analysis. This guide will walk you through the ins and outs of ...