Build more efficient spreadsheets by using the dollar sign to lock specific rows, columns, or permanent addresses when referencing cells.

We want to be transparent with you about how we make money. This website uses affiliate links. This means that if you click on an affiliate link and make a purchase, we may receive a commission from ...

Microsoft Excel remains a powerful tool for data analysis and manipulation, and staying up-to-date with the latest formulas is crucial for maximizing your productivity and improving your spreadsheets.

Corrected: An earlier version of this Commentary illustration included an incorrect math formula. The correct formula for calculating the area of a circle is A=πr^2. When I was a kid, I hated math. I ...

This is episode one of a three-part series. You can listen to part two here and part three here. [CLIP: Wind howls] Rachel Feltman: When Tom Crawford climbed Mount Kilimanjaro and stood 5,895 meters ...