Learn how to effectively use the ampersand (&) in Excel beyond just linking text. This video explores five practical ...

This is handy when you have a single cell to use in many formulas. Say you want to divide everything by 100. You could do a formula like = (A1/100), but that means you can't change the 100 easily ...