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

Unlike SUM, which ignores filters, SUBTOTAL dynamically adjusts to display only visible data. It offers 11 built-in functions, with additional options (101-111) that account for hidden rows. When ...

These days, large language models can handle increasingly complex tasks, writing complex code and engaging in sophisticated ...

Learn more about whether Astronics Corporation or Hexcel Corporation is a better investment based on AAII's A+ Investor ...

Unavoidable costs (mortgage, electricity, food etc) were colour-coded red; those which could be dispensed with easily (eating out) were in green; and those which where somewhere in the middle were ...

Nvidia has effectively acquired AI chip rival Groq through a licensing deal and leadership hire to bypass antitrust scrutiny, ...

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

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

Readers Edition. This is the (nearly) annual tradition of you, RPS readers, telling us where we went wrong in our annual ...