Excel also has some more advanced volatile functions, such as OFFSET and INDIRECT. To use these, head to Excel, click the "fx" icon next to the formula bar, and use Excel's Insert Function guide ...

To create dynamic dropdown lists, you typically need to use named ranges and the INDIRECT function in Excel. The function references a range of cells that change based on what you selected in the ...