AutoFill is a nifty feature of Excel to copy data, values, formulas and functions. You can also easily create a series of dates, weekdays, numbers and more.
See this video tutorial to see how to use it, probably one of the most useful features in Excel.
Gary Schwartz's Blog 