Abstract:This paper first presents the basic method of using the function of Excel to calculate the teaching workload automatically, and then explores on the application of Excel to count and analyze the teaching workload with examples, supplying reference to teaching administrators in colleges and universities。