The AGGREGATE function has two syntaxes—one for references and one for arrays—though you don't need to get yourself tied up in knots over which one you're using, as Excel selects the relevant ...

Every Excel expert knows how to navigate without a mouse and how to format data using keyboard shortcuts. But do you know how to insert a sum without typing the formula? Have you struggled to ...

Q. One of my duties is to keep a log of employees’ hours worked. I know Excel has a time-function application, so I figured it would not only track the hours but even give me end-of-week totals. But ...