Dynamic named ranges and offset function

Understanding dynamic named ranges requires a good understanding of the offset function in MS Excel.