Learn the difference between Excel COUNT and COUNTA, plus TEXTBEFORE and TEXTAFTER tricks, so you clean text and totals with confidence.

In this video, you’ll learn how to generate the entire alphabet in Excel using a single formula, including both uppercase and ...

In this video, you’ll learn how to add six months to a date in Excel using a simple and reliable formula. This method works ...

Diarmuid Early won first place in the 2025 Microsoft Excel World Championship. He has some pointers for using Excel at work.

Investor reporting still relies on spreadsheets and manual processes, but modern automation and AI can transform data quality ...

FORECAST.ETS applies an exponential triple smoothing (ETS) algorithm to create forecasts that can include trend and seasonal ...

Instead of being replaced by AI, Excel is finding new life with powerful AI overlays and CFOs that are doubling down on what ...

Pieter Pienaar has scored a first-place finish at the 2025 Microsoft Excel Collegiate Challenge (MECC), becoming the first South African to take the title. Pienaar, a 23-year-old student from the ...

Save hours on data entry and formula writing with my game-changing AI tips. From the laptops on your desk to satellites in space and AI that seems to be everywhere, I cover many topics at PCMag. I've ...

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 ...