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

Excel table formulas shift from cell positions to named columns with #All-style tags, keeping calculations readable when layouts change.

Discover how to calculate the weighted average cost of capital (WACC) in Excel. Learn the steps, formulas, and data required to estimate your funding costs.

In this video, learn how to use the dot operator in Excel to simplify adding formulas. Discover how to avoid unwanted zeros when dragging formulas and apply an IF statement along with the dot operator ...

Daniel Jassy, CFA, is an Investopedia Academy instructor and the founder of SPYderCRusher Research. He contributes to Excel and Algorithmic Trading. David Kindness is a Certified Public Accountant ...