Episode # 151 - Named Formulas

Sponsored by

Learn Excel from MrExcel

Check out this book for more tips
similar to this lesson!

Thursday, December 22, 2005

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.

You don't need to go spend an entire day at the local computer chain store to learn Excel. Take 5 minutes to learn this lesson now with our free video!

Watch Video

Click Play icon to play the video. You might first need to click on the Video to activate Flash player.

Tags/Keywords for this video: Formulas

More Excel Video Lessons

If you like this video, there are hundreds of 2-5 minute videos available here: