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.

This new blog is the video podcast companion to the new book, Learn Excel from MrExcel. Download a new two minute video every workday to illustrate one of the 277 tips from the book!