Microsoft's spreadsheet program can do way more than you might imagine. These are the hacks and tricks you need to know.

After four centuries of advances, astronomers now capture the Sun’s swirling, dynamic features in stunning detail.

Dynamic arrays change the rules for formula output in Excel. When I write a formula that returns a list by default, I need to decide whether I want the result to spill across a range of cells or ...

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