Excel Advanced Tutorial 1 – Using Named Ranges in Formulas

Using Named Ranges within your formulas Website and Forum: http://yourprogrammingnetwork.co.uk.

Don’t forget to check out our other video tutorials or share this video with a friend.

0 votes

Loading... 2,131 views

5 responses to “Excel Advanced Tutorial 1 – Using Named Ranges in Formulas”

1. Ana Jovanovic says:

   25/10/2014 at 7:29 am

   I don’t know what I am doing wrong…it just doesn’t work for me, excel
   2010. I followed instructions as you said, named the cell ”pass mark” and
   wrote formula =IF(C6<=Pass_mark,''Fail'',''Pass''). ( The equal sign is put in case of equal number). please advise me.

   Reply
2. V Karthik says:

   25/10/2014 at 7:33 am

   Guys, everything is possible in excel!!
   After a long time i built a Monitor Power Saver application in Excel, So I
   thought I’d share some of my application through this site.

   https://www.dropbox.com/s/0xl48by1bjpkmwl/Monitor%20Power%20Saver.rar.

   Any feedback/suggestions would be greatly appreciated!!

   Thanks!

   Reply
3. Anna Brook says:

   25/10/2014 at 8:05 am

   Great video and really helpful – To improve it would be good to have a
   clodeup of the formula bar as sometimes it is quite difficult tosee the
   formula you have just typed

   Reply
4. Prashanthi Anjuri says:

   25/10/2014 at 8:39 am

   Hello Matt

   Your tutorials are really helpful. I have a doubt here.. hope I am making
   some sense. If we are defining the named range by absolute referencing by
   giving $ signs, How does the referencing change dynamically when we move
   the passmark and value around to another cells.

   Thanks

   Reply
5. futurehipay says:

   25/10/2014 at 9:33 am

   but lesley is pretty clever so that does make sense haha

   Reply