MrExcel on MSN

Excel formula basics: The role of the dollar sign

This video explains how the dollar sign is used in Excel formulas to control whether cell references stay fixed or change ...
How-To Geek on MSN

How to use the SCAN function in Microsoft Excel to calculate running totals

The SCAN function lives in a single cell and spills the results down the column, ensuring my totals are always structurally and mathematically correct. The SCAN function has three arguments: ...