To autofill a column with weekdays in Excel we do not need any shortcuts at all.
Mapping and importing/exporting an XML schema to Excel
Here is a short video on how to map XML schemas to Excel.
Here is a short video on how to map XML schemas to Excel.