The YouTube video "How to Create Custom List in Excel" explains how to create a custom list in Excel beyond the default month names. To create a custom list, go to File, click on Options, and select Advanced. In the General area, find the "EditCustom List" option. Enter the list items and drag the field handle to populate the list. This allows users to create their own custom lists in Excel.