This paper presents a novel Microsoft Excel based virtual electron diffraction experiment, which replicates all functionality of an electron diffraction tube which is an important tool for the verification of the concept of matter waves. Unlike most of virtual labs where accessibility is mostly online; presented simulator is simply a downloadable excel file and can be used offline as a learning resource. Impact of the presented simulator on the learning was analysed by the test conducted for the control and the experimental group of students. Results of the test show the enhanced performance by the experimental group of students, indicating the positive impact of using the simulator along with conventional classroom teaching. This simulator intends to simplify the abstract quantum mechanical concept of matter waves by bringing the laboratory sort of experience in classroom.