The growth in the use of Automatic Tutoring systems has significantly increased over the past few years. New ideas and techniques are being used to make the automatic teaching as close as possible to human teaching. This project is designed to teach Microsoft Excel with the help of pre-recorded videos. The users are provided with a test designed in Excel that can be taken by the user to check how much the user has learnt. The main contribution of this thesis is the automatic test generation system. This system allows the user to take a test any number of times. It will create new tests based on templates which allow each generated test to have questions of the similar format and level of difficulty.