This short video shows how to use the INDIRECT command in Excel to change the contents of a drop down list dynamically. This is an original Improve You Excel video that was originally recorded in Excecl 2003 but will work just as well in Excel 2007 and Excel 2010. The file used in this video can be download here I would love to hear what you think of this video – so please leave comments in the box below of use one of the social buttons on the right to register a positive vote for this video.
It is vital that you get to grips with Excel Named Ranges if you are to Improve Your Excel Skills. This video is an original Improve Your Excel video and shows 3 great ways to use Excel Named Ranges. It starts by looking at naming cells and using them in equations. Then it looks at naming a group of cells and finally it looks at one of the secrets of Excel named ranges and how to use them with with Data Validation drop down list. This video was recorded a few years ago – but everything shown works with Excel [More]
This is a really well presented video that shows you some really cool suggestions for using Excel 2007 and Excel 2010 conditional formatting. In the first example it shows you how to insert an IF and OR statement to control the contents of the cell and then applies conditional formatting to the cell to create the icons. What is great about this video is that it does not stop there. In the second group it shows you how to apply data validation to cells to give a drop down list of values the user is able to select (always cool [More]
Skip Ad
Skip Panel
Skip Survey
It would be awesome to hit "like" or "share" and start playing.