Learn Excel Episode 151: Named Formulas

Posted in Companies, Podcasts on June 27, 2008


Learn Excel Episode 151: Named Formulas

A reader has a similar formula in thousands of cells on dozens of worksheets and needs to regularly change the formula. This should be a perfect time to use the Named Formula option, but you will discover that this seemingly simple task is incredibly hard. It takes 4+ minutes for Bill to walk you through a maze of functions such as INDIRECT, ROW, COLUMN, and ADDRESS just to set up a simple named formula to take the COS of a cell. Episode 151 shows you how.

Watch Video Watch Video on External Site

Tags: Microsoft, Excel, MrExcel, Formulas