Take advantage of relative cell references to add the same values to two different rows in Excel. Relative cell references create relationships between cells so that values entered in one cell are ...

When you add or subtract currency-formatted numbers, Excel 2013 automatically adopts the currency format for the results. Adding and subtracting figures follows similar procedures, but you must be ...

Have you ever thought of the humble SUM function as a secret weapon for advanced analytics? Most Excel users see it as a basic tool for adding numbers, but what if I told you it could do so much more?

It's marginally more efficient: While the difference is negligible, the double-unary operator can be more efficient in ...